Project 2 Part 1 Design a database

Design a database

A collection of books is being stored in a spreadsheet, and needs to be stored in a database. Below is a page from the spreadsheet

Questions

What are some problems which can be caused by storing this datadirectly in the database Assume that the owner wanted to keep track of friends and family who he leant books to. Make a list of the nouns in the description (These would become entities. Note that an entity may become a table in the database.) Make a list of 3 entities (separate tables) to store the data For each entity listed, list the attributes.

Project 2 Part 2 (To be submitted separately)

Using the instructions given in a previous assignment , create the database you designed in part 1 using Oracle.

To Download Click Here > Project 2 Part 1 Design a database.pdf