Chat with us, powered by LiveChat NEED MDF FILE FROM MICROSOFT SQL 2017 | WriteDen

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!

HOW OUR WEBSITE WORKS

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of 
HIGH QUALITY & PLAGIARISM FREE.

Step 1

To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
 Deadline range from 6 hours to 30 days.

Step 2

Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Discounts

Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.