Question: Assignment Task I would like you to reflect on what you have learned in this module. To do so, you will write a SQL Script

 Assignment Task I would like you to reflect on what you

Assignment Task I would like you to reflect on what you have learned in this module. To do so, you will write a SQL Script that creates a database called Assignment01DB_YourNameHere. Design your database tables to hold the data shown here: ProjectName Accounting DB Upgrade Accounting DB Upgrade ProjectDescription EmployeeName Date Hours Upgrade the Accounting Database to our new SQL 2Bob Smith Upgrade the Accounting Database to our new SQL 2... Bob Smith 3 Accounting Application Upgrade Modify our existing Accounting Application to conne... Sue Jones 4Accounting Application UpgradeModify our existing Accounting Application to conne... Sue Jones 2017-01-01 00:00:00.000 6.00 2017-01-02 00:00:00.000 4.00 2017-01-01 00:00:00.000 5.50 2017-01-02 00:00:00.000 6.00 Figure 1: The data of the Assignment01DB_YourNameHere database The data is not normalized so, you will need to re-organize it into a normalized design and then create your tables accordingly. Steps to take I recommend you use the following steps to perform this task: 1. 2. 3. 4. Notes: Review the data Identify normalization issues Create an ERD Create the database script You will find code for creating databases and tables in your module's Module01Code- Normalization.sql file . You do not have to create any Constraints in the database other than the Primary Keys . You do not need to import the data into the database, you a working SQL Script

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!