I need help with the attached database assignment in Access. I've already populated the tables, I just need assitance with the rest. Please assist.

I have 4 deliverables:

*Create  a database in your DBMS named MDC, and use the MDC SQL scripts for your DBMS to  create and populate the database tables. Create a user named MDC-User with the  password MDC-User+password. Assign this user to database roles so that the user  can read, insert, delete, and modify data.

1. *Create  an appropriate ODBC data source for your database.
2. *You  need about 20 INVOICE transactions with supporting INVOICE_ITEMs in the  database. Write the needed SQL statements for any needed additional INVOICE  transactions and insert the data into your database.

*Design a data  warehouse star schema for a dimensional database named MDC-DW. The fact table measure will be ExtendedPrice.

• Attachment 1
• Attachment 2

 ATTACHMENT PREVIEW Download attachment

Marcia’s Dry Cleaning Case Questions:Ms. Marcia Wilson owns and operates Marcia’s Dry Cleaning, which is an upscale drycleaner in a well-to-do suburban neighborhood. Marcia makes her business stand out fromthe competition by providing superior customer service. She wants to keep track of each ofher customers and their orders. Ultimately, she wants to notify them that their clothes areready via email.Assume that Marcia has hired you as a database consultant to develop an operationaldatabase named MDC that has the following four tables:CUSTOMER (CustomerID, FirstName, LastName, Phone, Email)INVOICE (InvoiceNumber, CustomerID, DateIn, DateOut, Subtotal, Tax, TotalAmount)INVOICE_ITEM (InvoiceNumber, ItemNumber, ServiceID, Quantity, UnitPrice,ExtendedPrice)SERVICE (ServiceID, ServiceDescription, UnitPrice)A Microsoft Access 2013 version of the MDC database and SQL scripts to create andpopulate the MDC database are available for Microsoft SQL Server 2014, Oracle DatabaseExpress Edition 11g Release 2, and MySQL 5.6 at the Database Concepts website atwww.pearsonhighered.com/kroenke. Sample data for the CUSTOMER table are shown inFigure 7-32, for the SERVICE table in Figure 7-33, for the INVOICE table in Figure 7-34, andfor the INVOICE_ITEM table in Figure 7-35.

 

• 1495504693-MDC.accdb

ComputerScienceExpert

(11)

Status NEW Posted 23 May 2017 01:05 AM My Price 8.00

-----------

Attachments

file 1495504693-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer