Create a data structure for the screen in the diagram

Assignment Help Database Management System
Reference no: EM13872137

Assignment

Consider the diagram at the end of the document, which shows a screen for book publisher who allows teachers to construct their own text books from a variety of chapters by various authors.

There are two data stores used for this application. One is Course, which contains information about an instance of a class, such as IS 315 HO Fall 2015, the dates of the term, the instructor, etc. The other data store is Chapter, which lists all the chapters, authors, pages, and price for each chapter in the inventory.

1. Decide which elements in the diagram are base elements and which are derived elements. Make a list of the derived elements and say how each is derived.

2. Of the remaining base elements, create two data structures to represent the two data stores Course and Chapter. Specify the details for each.

3. Create a data structure for the screen in the diagram. This will have components from both data stores.

4. Create an XML document from the information in problem 3 that only contains the information needed to send to the printer to have the book printed. Don't worry about adding anything not there (like a shipping address) but do worry about what you can chop out. The printer should not get all the information on that data structure.Justify what you are leaving out.

748_BYOB.png

Reference no: EM13872137

Questions Cloud

Sarbanes-oxley act of 2002 : Evaluate what changes should be made to both the Sarbanes-Oxley Act of 2002 and other current laws in order to make them more effective in deterring companies from committing crimes.
Discuss the difference between book values and market values : Discuss the difference between book values and market values and explain which one is more important to the financial manager and why.
Build the web site for flyhigh : Build the web site for FlyHigh including the following content: Specific trip information travelers need to plan their ( costs, accommodations, options , and so on) and Information international customers will need ( passports , visas, vaccination..
Write the facts about vectors? : Write the facts about Vectors?
Create a data structure for the screen in the diagram : Create a data structure for the screen in the diagram. This will have components from both data stores
What are the arithmetic and geometric returns for the stock : A stock has had returns of −19.1 percent, 29.1 percent, 25.2 percent, −10.2 percent, 34.9 percent, and 27.1 percent over the last six years. What are the arithmetic and geometric returns for the stock?
What is the after tax cash flow from the sale of this asset : Consider an asset that costs $810,000 and is depreciated straight-line to zero over its nine-year tax life. The asset is to be used in a five-year project; at the end of the project, the asset can be sold for $185,000. If the relevant tax rate is 30 ..
General ledger and reporting systems : Develop a proposal for migrating your firm to IFRS from GAAP. Discuss how you will educate your users in IFRS.
Find the gauge pressure at a second point in the line : At one point in a pipeline the water's speed is 3.00 mls and the gauge pressure is 5.00 X 104 Pa. Find the gauge pressure at a second point in the line, no m lower than the first, if the pipe diameter at the second point is twice that at the first

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd