TSU Music Store ERD Supertype of Product for Movie Production & Amazon Entities

User Generated

fnovaguncn990

Computer Science

Tarleton State University

Description

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 like

Unformatted Attachment Preview

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi! Here it is yo...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags