Lab 3 Assignment Supertypes and Primary Keys
1. Redo the Music store ERD from the previous lab assignment. This time,
create a supertype of product and have three subtypes for product. These
subtypes should be sheet music, instruments for sale, supplies, and
recorded music. Determine what fields these items all share in the
supertype and then provide at least three attributes for each subtype that
are particular to that type of product.
2. Create a supertype and a subtype for employees in a movie production.
Create a supertype PERSON and then define at least 4 subtypes that might
exist in a movie. Include at least two attributes that would be specific to
that subtype. You might want to look at imdb.com if you need more info
about the types of people that work on a movie and some of the specific
types of information that might be stored about these job types. Complete
an ERD for this supertype/subtype structure.
3. Look at three databases on the internet. Some examples, kbb.com,
amazon.com, oldnavy.com, chemspider.com, baseballreference.com….any
online database, I don’t care. Ok, I care a little….keep it PG13, please and
you can’t use IMDB because I’m going to use that for examples. Spend a
few minutes getting familiar with what you can search for, what data a
search returns, etc.
a. For each database, list three entities that you think exist in the
database. For example, if I do imdb.com, I would imagine that there
is an actor table, a title table, a director table, etc
b. For each table, identify two possible primary keys. Some of these are
likely to be composite keys to increase likelihood of uniqueness.
c. Discuss which of your two possible primary keys is the best selection
for the table and tell me WHY it is the best selection for that table.
Submit assignment in Canvas by the due date
Lab 3 Assignment Supertypes and Primary Keys
1. Redo the Music store ERD from the previous lab assignment. This time,
create a supertype of product and have four subtypes for product. These
subtypes should be sheet music, instruments for sale, supplies, and
recorded music. Determine what fields these items all share in the
supertype and then provide at least three attributes for each subtype that
are particular to that type of product.
UPDATED QUESTION: If you want to do one with the music lessons, you
can answer this question instead. Redo the Music store ERD from the
previous lab assignment. This time, create a supertype of product and have
four subtypes for product. These subtypes should be sheet music,
instruments for sale, supplies, and lessons. Determine what fields these
items all share in the supertype and then provide at least three attributes
for each subtype that are particular to that type of product.
2. Create a supertype and a subtype for employees in a movie production.
Create a supertype PERSON and then define at least 4 subtypes that might
exist in a movie. Include at least two attributes that would be specific to
that subtype. You might want to look at imdb.com if you need more info
about the types of people that work on a movie and some of the specific
types of information that might be stored about these job types. Complete
an ERD for this supertype/subtype structure.
3. Look at three databases on the internet. Some examples, kbb.com,
amazon.com, oldnavy.com, chemspider.com, baseballreference.com….any
online database, I don’t care. Ok, I care a little….keep it PG13, please and
you can’t use IMDB because I’m going to use that for examples. Spend a
few minutes getting familiar with what you can search for, what data a
search returns, etc.
a. For each database, list three entities that you think exist in the
database. For example, if I do imdb.com, I would imagine that there
is an actor table, a title table, a director table, etc
b. For each table, identify two possible primary keys. Some of these are
likely to be composite keys to increase likelihood of uniqueness.
c. Discuss which of your two possible primary keys is the best selection
for the table and tell me WHY it is the best selection for that table.
Submit assignment in Canvas by the due date
Purchase answer to see full
attachment