Expert answer:Using Normalized Databases
Solved by verified expert:You will now have an opportunity to complete a variety of lessons together. Specifically, you will add data to your database and you will write SQL Select statements for each table. You will describe briefly whether or not this database is normalized.
Add data to your database and validate that your records loaded properly. In tabular format, include 3 rows for each table, making sure that the primary key and foreign key relationships are properly applied.
Next, perform queries using JOIN syntax of the database.
•Task 1: Create 3 rows of data for each table ensuring that the referential integrity is valid.
•Task 2: Create a SELECT query for every table that displays all the columns and shows all three rows. Take a screen shot that shows each query and its output.
•Task 3: Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data): ◦Display the employee id, contact id, first_name, middle name, last_name, and phone number for all employees. ◾Rows returned
◦Display the employee id, contact id, first_name, middle name and last_name, and email address for all employees. ◾Rows returned
◦Display the employee id, contact id, first_name, middle name, last_name, phone number, and email address for all employees. ◾Rows returned
Combine all of the DDL/SQL statements (text only), diagram and screenshots into a single Word document.
At the beginning of your Word document, briefly describe whether or not the database is normalized. Summarize your thoughts regarding referential integrity. Support your statements.
Describe your thoughts about the data organizational architecture and considerations or issues associated with the design.
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades