WEEK 2 ASSIGNMENT
May 13, 2020
Any topic (writer’s choice)
May 13, 2020
Show all

Creating a Personal Data Base

You will be developing, designing, building and querying your own personal database. Here are the instructions:

1. Select a very narrow domain for your database. Limit 5 entities.

2. Create a description of the domain of the database including the key entities. Describe the entities  including the relevant attributes of each entity and the attribute which defines a single instance of the entity.

3. Narratively  describe the relationships between the entities, including the cardinality of the relationships. 

4. Narratively describe the types of questions that users of the database could answer using the database.

5. List three specific question that can be answered only by looking at data from two or more tables of the database.

6. Once you have completed the narrative description of your database, use the MySQL ERD modeling module to create an ERD depicting the database.

7. Next, forward engineer the database, and create an Excel spreadsheet containing between 5 and 10 records for each table.use MySQL to load the data from the Excel spreadsheets into your database. Once the data has been loaded, create a data dictionary for your database. Finally, write a query to answer each of the three questions you described in the first part of the project.

Leave a Reply

Your email address will not be published. Required fields are marked *