NEED MDF FILE FROM MICROSOFT SQL 2017
NEED MDF FILE FROM MICROSOFT SQL 2017
Assignment: Create a database for a small e-commerce web site. As a minimum, it should include the following entities:
Customer – name, address, city, state, zip, etc.
Inventory – description, category, quantity on hand, unit price, etc.
Order – date, payment info, etc.
OrderDetail – typical shopping cart line items
Supplier – vendor info to include MainPhone, SalesPhone, ShippingPhone, and BillingPhone
StateFees – list of 50 states and the sales tax and shipping costs
Notes:
Inventory and Supplier start out as a N:M, so you’ll need to fix that
The fee info is: 1) Charge 6.25% tax in Texas 2) Charge 8.25% tax in California, 3) All other states have 0% tax…. and 4) Charge $4 to ship to TX, LA, OK, NM, 5) Charge $8 to ship to AK and HI, and 6) Charge $6 shipping to all other states.
Real databases do not always allow you delete records, so please account for this in your table design
Use the database diagram to ensure that there are no “orphan” tables
As a minimum, You must create Views, Table Functions, or Scalar Functions for the following:
query to produce the extended price (a single value) for a given Order and a given Line Item
query to show all order activity details for a given Customer
query to show the total cost (cost of items + tax + shipping) for a given order
query to show the total sales (in $) for each month
query to show the total sales (in $) for each category of product
create a view to demonstrate the use of each of the functions above
You need to have enough sample data in your database to be able to demonstrate that each query works
Notes: You must provide an MDF file from SQL Server 2017… not a later version!
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
