D. Combine the models you developed in your answers to B and C. Create new entities...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
D. Combine the models you developed in your answers to B and C. Create new entities if necessary, but strive to keep your model as simple as possible. Specify identifiers and attributes of new entities, name new relationships, and indicate their cardinalities. CO TRACK can Tak Number Song B ARTIST PARENT ARTIST INDIVIDUAL RELATIONSHIP ROLE ROLE CHILD TYPE Subtype Strang CARDINALITY [Blue = Inferable] MAX 1.N N.M MIN M-O CUTRIN CUComments COCON M-O Wh/ W-WlBy SONGWISTER Adistama Agency Puschw ARBST NOMOUAL | AE1FDAITHA Atisasie AN The E-R Crow's Foot model above is based on the answer to question C, but adds back in the ROLE entity. Now however, we must figure out how to deal with ROLE. We could create an entity named PERFORMER and make ARTIST and ROLE its subtypes. But if we do that we would also need a relationship between ARTIST INDIVIDUAL and ROLE, which creates a "looping problem with the aupedype subtype hierarchy identifiers. The solution is recognizing ROLE as another subtype of ARTIST. This is a change for the solution in B., but in that diagram ARTIST really referred to what we are now calling ARTIST INDIVIDUAL. The new entity and relationships are shown in the following data: IS SINGER IS SONGWRITER Max/ Twin -On ANTIST At AllTyp Plays! Tallaved & Composed-Cl/ &லினாய்- M SINGER Antara Vocalyp 08 Gy App/ Ay SONG Song Sanglims Pamy! ARBST GROUP Arti Numb ROLE ArtiNama Hok We can infer that: . the one-to-many relationship between ARTIST and ROLE can be inferred from the definition of a supertype/subtype relationship. • the M-O relationship between ARTIST and ROLE can be inferred from the definition of a superype/subtype relationship. • the many-to-many relationship between ARTIST INDIVIDUAL and ROLE can be inferred because one INDIVIDUAL ARTIST is included in many ROLEs on the West Side Story CD (when we include group ROLEs such as "Entire Cast"), and one ROLE may include many ARTIST INDIVIDUALS (when we include group ROLEs such as "Entire Cast"). We need to determine if: • the M-O relationship between ARTIST INDIVIDUAL and ROLE is correct. We have assumed that a ROLE must be played or filled by an ARTIST INDIVIDUAL, but that we may have ARTIST INDIVIDUALS in the database who have not played or filled any ROLE. D. Combine the models you developed in your answers to B and C. Create new entities if necessary, but strive to keep your model as simple as possible. Specify identifiers and attributes of new entities, name new relationships, and indicate their cardinalities. CO TRACK can Tak Number Song B ARTIST PARENT ARTIST INDIVIDUAL RELATIONSHIP ROLE ROLE CHILD TYPE Subtype Strang CARDINALITY [Blue = Inferable] MAX 1.N N.M MIN M-O CUTRIN CUComments COCON M-O Wh/ W-WlBy SONGWISTER Adistama Agency Puschw ARBST NOMOUAL | AE1FDAITHA Atisasie AN The E-R Crow's Foot model above is based on the answer to question C, but adds back in the ROLE entity. Now however, we must figure out how to deal with ROLE. We could create an entity named PERFORMER and make ARTIST and ROLE its subtypes. But if we do that we would also need a relationship between ARTIST INDIVIDUAL and ROLE, which creates a "looping problem with the aupedype subtype hierarchy identifiers. The solution is recognizing ROLE as another subtype of ARTIST. This is a change for the solution in B., but in that diagram ARTIST really referred to what we are now calling ARTIST INDIVIDUAL. The new entity and relationships are shown in the following data: IS SINGER IS SONGWRITER Max/ Twin -On ANTIST At AllTyp Plays! Tallaved & Composed-Cl/ &லினாய்- M SINGER Antara Vocalyp 08 Gy App/ Ay SONG Song Sanglims Pamy! ARBST GROUP Arti Numb ROLE ArtiNama Hok We can infer that: . the one-to-many relationship between ARTIST and ROLE can be inferred from the definition of a supertype/subtype relationship. • the M-O relationship between ARTIST and ROLE can be inferred from the definition of a superype/subtype relationship. • the many-to-many relationship between ARTIST INDIVIDUAL and ROLE can be inferred because one INDIVIDUAL ARTIST is included in many ROLEs on the West Side Story CD (when we include group ROLEs such as "Entire Cast"), and one ROLE may include many ARTIST INDIVIDUALS (when we include group ROLEs such as "Entire Cast"). We need to determine if: • the M-O relationship between ARTIST INDIVIDUAL and ROLE is correct. We have assumed that a ROLE must be played or filled by an ARTIST INDIVIDUAL, but that we may have ARTIST INDIVIDUALS in the database who have not played or filled any ROLE.
Expert Answer:
Answer rating: 100% (QA)
A What is normalization Normalization is a process used in database design to organize and simplify data structures in order to reduce data redundancy and improve data integrity It is the process of d... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
Consider the CD cover in Figure 5-61. A. Specify identifiers and attributes for the entities CD, ARTIST, ROLE, and SONG. B. Construct a crow's foot model showing relationships among these four...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Company Lalo Company, headquartered in Vaduz, is a company listed in Amsterdam, Paris and Zurich. It is the third largest small home appliance manufacturer in Europe. The company was founded in...
-
A student has six textbooks, each with a thickness of 4.0 cm and a weight of 30 N. What is the minimum work the student would have to do to place all the books in a single vertical stack, starting...
-
Campbell Manufacturing intends to start business on January 1, 2014. Production plans for the first four months of operations are as follows: January ..........20,000 units February ........50,000...
-
This case is a lawsuit within a lawsuit. The primary case was a malpractice lawsuit brought by a patient against a pharmacist who had allegedly dispensed to her an incorrect medication. The judge in...
-
Which of the following sampling plans varies sample size? a. Attribute estimation sampling. b. Sequential sampling. c. Discovery sampling. d. Stratified sampling. Choose the best answer.
-
Solar Designs is considering an investment in an expanded product line. Two possible types of expansion are being considered. After investigating the possible outcomes, the company made the estimates...
-
As discussed there are different interview styles that dictate how an investigator will seek information. One effective theme or style is for the investigator to sympathize with the suspect. In the...
-
After its first month of operations, Paquette Advisors showed the following account balances in its General Ledger accounts as at January 31, 2014. During February, the following transactions...
-
Explain the dc motor characteristics of Speed-Torque Relationship ?
-
Which of the following is not true concerning the behavior of a use case? (a) An extending use case is always independently meaningful (b) An extended use case is always independently meaningful (c)...
-
The purpose of scenarios is to (a) decompose the use case process (b) identify variations on the use case process (c) identify interactions between use cases (d) run test cases
-
Which of the following steps is involved in creating a use case model? (i) Defining the system (ii) Identifying the actors and the use cases (iii) Defining the relationships between the actors and...
-
Explain whether each of the following is a perfectly competitive market or not. For each market that is not perfectly competitive, explain why it is not. a. Books b. Pizza market c. IT companies d....
-
Which of the following is NOT an advantage of object-oriented approaches? (a) Low maintenance costs (b) Follows the life-cycle model sequentially (c) Seamless progression between development stages...
-
Liquid ammoia at -20C is stored in spherical vessel of inner and outer radius 1m and 1.05 m respectively. The inner shell of 3 cm thick is made of nickel steel (k= 19 W/mK) and the outer shell of...
-
Swifty company is a publicly held corporation whose $1 par value stock is actively traded at $30 per share. The company issued 3400 shares of stock to acquire land recently advertised at $93000. When...
-
Jan has two jobs during 2012. One employer withheld and paid FICA taxes on $66,600 of Jan's salary, and the other employer withheld and paid FICA taxes on $44,400 in salary paid to Jan. Calculate the...
-
In 2012, Gale and Cathy Alexander hosted an exchange student, Axel Muller, for 9 months. Axel was part of International Student Exchange Programs (a qualified organization). Axel attended tenth grade...
-
Marty is a sales consultant. Marty incurs the following expenses related to entertainment of his clients in 2012: Dues to a country club......................................................$4,500...
-
A mass attached to a linear spring sliding on a surface with Coulomb damping is an example of a nonlinear system. Indicate whether the statement presented is true or false. If true, state why. If...
-
The swinging spring is an example of a two degree-of-freedom system with a cubic nonlinearity. Indicate whether the statement presented is true or false. If true, state why. If false, rewrite the...
-
The convolution integral can be applied to solve nonlinear problems. Indicate whether the statement presented is true or false. If true, state why. If false, rewrite the statement to make it true.
Study smarter with the SolutionInn App