Order from us for quality, customized work in due time of your choice.
Consider the relationships between Books and Authors. A book can have a number o
Consider the relationships between Books and Authors. A book can have a number of authors
and an author can have many books to his/her name. Taking into account this particular
example, you are required to carry out the below tasks to design a database:
a. Identify all the ENTITIES. Give each ENTITY a suitable name.
b. Identify all the ATTTRIBUTES associated with each ENTITY. Make sure that each
ENTITY has a proper PRIMARY KEY which is underlined. A minimum of 3 attributes is
required for each
ENTITY.
c. Draw an ENTITY RELATIONSHIP DIAGRAM (ERD) clearly stating the relationships
between the ENTITIES, the CARDINALITIES and ATTRIBUTES with correct notations.
d. Convert the ERD (drawn in “c”) into a relational schema. The PRIMARY KEY and
FOREIGN KEY must be clearly shown for each relation.
e. Produce sample records (3 records at least per ENTITY) to represent the relational
schema.
The records can be presented in the form of a table for each entity.
Order from us for quality, customized work in due time of your choice.