Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help really bad CIS 305 -Project 3 This project consists of one big deliverable. Be sure to number the pages in your report.
I need help really bad
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 TStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started