DATABASE DESIGN PROBLEMS:

NOTE*: I have to help someone who is not physically here finish his assignment, but I've never learned anything about database. Show me the right answers please. Read carefully and full answers will be greatly rated. Thanks!!!

============

Question:

For each of the descriptions below and using Oracle SQL Developer Data modeler, express the relationships in each description graphically with an E-R diagram.

NEED SCREENSHOTS of all of the E-R diagrams

============

Part 01

a. 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 design is specified before any single piano exists.

b. A piano manufacturer employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least two technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.

c. The piano technicians have a hierarchy of reporting relationships: Some of them have supervisory responsibilities in addition to their inspection role and have multiple other technicians report to them. The supervisors themselves report to the chief technician of the company.

Part 02

d. A vendor builds multiple types of tablet computers. Each has a type identification number and a name. The key specifications for each type include amount of storage space and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet computer type; obviously, the same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturers unique code that identifies it.

e. Each individual tablet computer manufactured by the vendor (see 2h) is identified by the type identification number and a serial number that is unique within the type identification. The vendor wants to maintain information about when each tablet is shipped to a customer.

f. Each of the tablet computer types (see 2h) has a specific operating system. Each technician the company employs is certified to assemble a specific tablet typeoperating system combination. The validity of a certification starts on the day the employee passes a certification examination for the combination, and the certification is valid for a specific period of time that varies depending on tablet typeoperating system combination.

Part 03

g. An Artist Management company would like to store information about artists. Artists are identified by an Id and are described by their Name, Age and Gender. Most of the artists are under contract with the company and for them the company stores multiple Samples of their work. There are however also interested in tracking prospective artists, for whom they have no sample of their work but they may have recommendations about them from different sources.

h. There are a lot of sources that hint the company about prospective artists. These sources are identified by an Id and they may also have a name, description (critic or newspaper article or local performance stage) and a Quality index which is an attribute that describes the quality of the information that this source has provided in the past. Each source is making any number of recommendations about prospective artists and every prospective artist may be recommended by any number of sources.

i. Now update the previous diagram to take into account that for each recommendation the company needs to store a summary, a quality evaluation from the source for the prospective artist and the date that the recommendation was received. Notice that every recommendation that comes from one source can be a recommendation for more than one prospective artists (as they may be a group).

j. The company would also like to store information about News Items that are published for each of the artists. These Items are identified by an Id are described by the source of the news and the content. Every news item is for one of more artists of the company, while each artist may have any number (even zero) of news items associated with him.