A1Solution.pdf - ISM 218 Database Systems Fall 2017...

This preview shows page 1 - 2 out of 2 pages.

ISM 218 Database Systems Fall 2017 Assignment 1 Solution For each of the descriptions below, perform the following tasks: 1) Express the relationships in each description graphically with an Entity-Relationship diagram. 2) Fill out a table instance chart for each entity. Description 1: A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and a name. In addition, the company wants to maintain information about the designer of the model. Over time, the company often manufactures thousands of pianos of a certain model, and the model designer is specified before any single piano exists. Solution: Table Name: Piano Column Name Serial_Number Mfg_Comp_Date Model_ID Key Type PK FK Null/Unique NN, U NN NN FK Table Model FK Column ID_Number Data Type VARCHAR
Image of page 1

Subscribe to view the full document.

Image of page 2
You've reached the end of this preview.
  • Fall '12
  • Oakley

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern