Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke

1st Edition

0130086509, 978-0130086501

More Books

Students also viewed these Databases questions

Question

Understand how to design effective service guarantees.

Answered: 1 week ago