solution
You are free to use any application to draw your ER diagram (Lucidchart, Microsoft Visio, Paint…) and then paste your diagram into your .doc or .pdf document.You are also free to hand draw your diagram and put a ‘picture’ of it into your .doc or .pdf document.
For each of the following descriptions:
– Identify the degree and cardinalities of the relationship.- Draw the corresponding E-R diagram. Don’t forget the degree and cardinalities of each relationship.
a) (10 pts)
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. In addition, the company wants to maintain information about the designer of each piano. The name and address of each designer is kept in the database. Each designer is identified by a specific code.Each piano must be created by only one designer. While a designer usually creates multiple pianos, not all designer saved in the database have delivered a piano to this manufacturer.
b) (10 pts )
A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is written by one or multiple authors. Each author is identified by an author number and has a name and date of birth. Each author has either one or multiple books. Occasionally, it is possible that prospective authors who have not yet published any books.In addition, each book can be part of a set, which is also identified as a book and has its own ISBN number. One book can belong to several sets, and a set consists of at least one but potentially many books.
For each of the following descriptions:
– Identify the degree and cardinalities of the relationship.- Draw the corresponding E-R diagram. Don’t forget the degree and cardinalities of each relationship.
a) (10 pts)
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. In addition, the company wants to maintain information about the designer of each piano. The name and address of each designer is kept in the database. Each designer is identified by a specific code.Each piano must be created by only one designer. While a designer usually creates multiple pianos, not all designer saved in the database have delivered a piano to this manufacturer.
b) (10 pts )
A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is written by one or multiple authors. Each author is identified by an author number and has a name and date of birth. Each author has either one or multiple books. Occasionally, it is possible that prospective authors who have not yet published any books.In addition, each book can be part of a set, which is also identified as a book and has its own ISBN number. One book can belong to several sets, and a set consists of at least one but potentially many books.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
