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

  Validity of the collected data and include the survey report

Describe the easy and difficult aspects of creating and conducting an online questionnaire. Assess the reliability of the collected data and include the survey report. Assess the validity of the collected data and include the survey report

  Computer applications that run on desktop and laptop

computer applications that run on desktop and laptop computers have for a long time been designed to be driven by

  Database management challenge than relational database

What is it about a 200 MB video or audio file which makes it so much more of database management challenge than relational database the same size?

  Verify the values inserted by using a query

Write INSERT statements for adding the following data to the new table: Verify the values inserted by using a query. Display each distinct agency (each agency only once)

  Propose enhanced database management strategy

Propose an efficient data structure that may hold the tour operator's data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.

  What are input and‘output tax accounts in sap

Explain the ‘Document Principle' as used in SAP. What information is presented in the ‘header' section of a document versus the ‘line item' section?

  A motor vehicle maintenance center wants to enhance its

write a 200- to 300-word short-answer response for the followinga motor vehicle maintenance center wants to improve its

  Complete development of a relational database

Complete development of a relational database. You are to do the following: Use Visio to create the appropriate diagrams. Create a script named mdbXXX.sql (where XXX are your initials) that Create the tables in 3NF needed to implement your DB schema

  Review the subsequent list of data management difficulties

how data warehousing, online transactional databases, and data mining can solve or reduce these difficulties. Be specific.

  Explain the apache web server in regard to cost

Discuss the Apache Web server in regard to cost, functionality, and compatibility. Are there certain implementations were it may not be suitable

  Database for a library of a university

Each book has different ID (also each book of same name and same author (but number of copies) will have different ID), author name and any additional information you think it is important

  Create and passunittests for each repository method

Create and PassUnitTests for each repository method in Your Mongo Participant Repository, Create Participant

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