Question: I need some help doing this project. It is due at 11:59 tonight CIS 305 -Project 3 This project consists of one big deliverable. Be

I need some help doing this project. It is due at 11:59 tonight

I need some help doing this project. It is due at 11:59tonight CIS 305 -Project 3 This project consists of one big deliverable.Be sure to number the pages in your report. Deliverable: Table CreationUsing ERwin and Microsoft SQL Server, create the tables and populate themwith data. The source of your data will be the Microsoft Excelspreadsheet provided to you on the Blackboard assignment. You should realize that

CIS 305 -Project 3 This project consists of one big deliverable. Be sure to number the pages in your report. Deliverable: Table Creation Using ERwin and Microsoft SQL Server, create the tables and populate them with data. The source of your data will be the Microsoft Excel spreadsheet provided to you on the Blackboard assignment. You should realize that the spreadsheet is poorly designed, and you will need to normalize the data to populate your tables. Use ERwin to create the tables, and then forward engineer them to automatically generate the schema in SQL Server. Include your .erwin file with your deliverables, as well as your SQL database. NOTE: your database and ERwin files should be named using the syntax of Lastname_F (where F is your first initial) Reminder: To obtain your SQL database file, first make sure that there are no open connections to your SOL database (either your Query Session or ERwin), then right-click on your database and select task and then detach option. Detaching your database will produce two output files, (.mdf & .ldf). Both are necessary to attach a database, so be sure to include both. Hereis list of the entities for this project CUSTOMER T CustomerID (PK) CustomerName CustomerStreet CustomerCity CustomerState CustomerZip CreditLimit SalesRepID (FK) of EMPLOYEE_T ORDERT OrderlD CustomerlD (FK) of CUSTOMER_T CustomerPONumber (This means the Customer Purchase Order Number) OrderDate DueDate ShipDate (PK) ORDER LINE T OrderlD ProductID composite (PK), (FK) of PRODUCT_ T OrderQuantity composite (PK), (FK) of ORDER T

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!