write the SQL statements to create the database and tables.

Sigchi4life
Category:
Computer Science
Price: $40 USD

Question description

Lab5_kcds.docx 

Catalog_ID

Column Name

Title

Rating

Charges

Null?NorY

Y

Y

N

Data

The Conformist

5

visa/master

Item_ID

Column Name

Item number

Price

Genre

Null/NorY

Y

N

Y

Data

B2211334

$6.00

drama

Order_ID

Column Name

Order Number

Order Date

Order Done

Null/NorY

Y

N

N

Data

ON20

10/3/2015

10/3/2015

Member_ID

Column Name

member name

Address

Email

Phone Number

Null/NorY

N

Y

Y

Y

Data

Joe

121 Orr RD.

J@aol.com

(321) 444-1111

Supplier_ID

Column Name

Supplier Name

Address

Email

Phone Number

Null/NorY

N

Y

Y

Y

Data

Marks Paper

696 Ross St.

Mark@Gmail.com

(144) 999-2776

CD_ID

Column Name

CD Quality

MP3

Blue Ray

HD

Null/NorY

Y

N

Y

Y

Data

Digital Audio

None

50 gigabytes 

16-bit digital audio

  • In Microsoft Access, create the database and tables that you identified in W3 Assignment 2. In Microsoft Word, write the SQL statements to create the database and tables.
  • Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables.

·  Refine your database and SQL statements by incorporating your instructor's feedback.

  • Verify that the database completely follows the business logic and design you created in the previous weeks.
  • Create queries using your new database to demonstrate that the data is useful and meaningful.
  • Submit the final database and database scripts to the instructor for testing and installation

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Cornell University
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1821 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors