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

  Types of input control and explain the function of each

Explain the function of input controls. Identify four (4) types of input control and explain the function of each

  Use of databases and data communication technologies

Discuss with your team how the bookstores use the Internet and if they use collaboration technology. The use of databases and data communication technologies

  Activity-based costing to assign overhead costs to products

How much overhead cost would be assigned to each of the two products using the company's activity-based costing system

  A database to keep track of information for her business

A database to keep track of information for her business

  Objectivesto analyse and comprehend a provided er diagram

objectivesto analyse and comprehend a provided er diagram and database schemato implement a database based on the

  Draw an e-r diagram

Draw an E-R Diagram and draw an E-R Diagram for Student Information System.

  How an organization would allow programmatic access

A few years have passed, and the restaurant has grown to become a national restaurant chain. Now, they are concerned that remote and branch offices and restaurants in all fifty states will not have ready access to the data.

  When does oracle stop processing the query

How does Oracle process this query? That is, what does Explain Plan tell you about how the query is processed - how would you recognize that the results were not correct?

  Design of database systems

Write a trigger that will increment the new field numHours in the Employee table automatically whenever a record is inserted in the Works table - Create a view that shows the eids and managerids in Sales department.

  Convert database tables to the first normal form

Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form

  Explain the di?erence between external internal and concept

Explain the di?erence between external, internal, and conceptual sche-mas. How are these di?erent schema layers related to the conceptsof logical and physical data independence?

  Determine impacts on revenue resulting

If you need to determine impacts on revenue resulting from an increase or decrease in prices and/or sales, the best option to use is a

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