Databases
Assignment Purpose
The purpose of this assignment is to use SQL commands to create and query a database.
INSTRUCTIONS
- Open MySQL workbench.
- Choose one of the example normalization assignment databases:
M2: Database Design – Normalization Employee Project Assignment
M2: Database Design – Normalization Grey’s Rooming House Assignment
M2: Database Design – Normalization Project Task Assignment - Implement the tables. Be certain to assign the primary and foreign keys.
- Insert an appropriate amount of data (5-10 rows) in EACH table.
- Open a word document. Enter your name and date.
- Briefly summarize the database you selected in your word document.
- Run a “SHOW” query command to show the tables in your database schema.
Screenshot your “SHOW” query results and paste them into your Word document. - Select *From each table in your database to show the rows you inserted in step 4.
Screenshot the results of *From for EACH table and paste in your Word document. - Create and run 2 different queries (not already needed for other questions) that you think the users of this database may be interested in. Note: Do -not- use * in the query.
Screenshot the results and paste into your Word document. - Briefly describe why you chose these two queries.
- I choose Grey’s Rooming House Assignment