MU Database Design Questions

Description

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



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.