Complete the Business Project described in the text in excel, assignment help

The purpose of this assignment is to interpret the written narrative into a database design. Read the narrative carefully and be thorough in documenting the following:

  • the tables
  • the columns (fields) within each table
  • the logical relationships between the tables (i.e., primary keys and foreign keys)

NOTE 1

  • The last sentence of the problem says “He has asked you to create an ERD from the information described here using the Chen model’.
  • The purpose of this assignment is not to demonstrate your knowledge of the Chen model for documenting a database design. There are several ways to document a database model, and students can use the Chen model if they want; but it would also be acceptable (and probably easier) to document the data entities and entity relationships using the simple model shown on the bottom of page C2 –or, using a template similar to what’s shown on the bottom of page C8.

NOTE 2

  • To reiterate, the purpose of this assignment is to document the database model: the tables, the fields within the tables and the relationships between the tables -which is separate and distinct from creating a test-bed of sample data. If you find yourself creating records of sample data, see me, you’re probably headed in the wrong direction
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp