Our Services

Get 15% Discount on your First Order

Purpose: To demonstrate your ability to analyze a business scenario

November 30, 2021

Purpose: To demonstrate your ability to analyze a business scenario and create a “real world” database

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!

Expectations: A single “detached” Microsoft SQL Server 2017 database file (an *.mdf file)

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

· The write-up should be at most 1,000-words (12-point font,

· The write-up should be at most 1,000-words (12-point font, 1.5 spaced) 1. “Cyber Breach at Target” Case Questions 1. What is your diagnosis of the breach at Target—was Target particularly vulnerable or simply unlucky? 2. What, if anything, might Target have done better to avoid being breached? What technical or

Concurrent and Parallel Algorithms

Question 2 There is a public swimming pool with a limit of 4 swimmers in the pool at one time. (It is a very small pool!) The code for each swimmer is given below. It uses a semaphore poolSpace, to represent whether there is space left in the pool for

HSA 4421 FIU Health & Medical Improving Clinical Operations Question Nursing Assignment Help

Answer Question #2 only Expert Solution Preview Introduction: As a medical professor responsible for creating assignments and evaluating medical college students, my primary goal is to provide a comprehensive learning experience that tests their knowledge and skills. By designing and conducting lectures, evaluating student performance, and offering feedback through

The Japanese Criminal Justice System Review Chapter 10 in the

The Japanese Criminal Justice System Review Chapter 10 in the textbook and analyze Japanese policing, the court structure and trial process, and corrections. Evaluate the Japanese criminal justice system and compare it to the United States. Evaluate Japanese policing and investigative agencies. Were there any areas of the Japanese

Psychiatric notes are a way to reflect on your practicum experiences and connect the experiences to the learning you gain from your weekly Learning

Psychiatric notes are a way to reflect on your practicum experiences and connect the experiences to the learning you gain from your weekly Learning Resources. Focused SOAP notes, such as the ones required in this practicum course, are often used in clinical settings to document patient care. For this Assignment,

IT 700 SNHU Major Challenges of Facing Healthcare Systems Project Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor responsible for creating college assignments and assessing student performance, my primary goal is to provide comprehensive and relevant education to medical college students. I design and conduct lectures, evaluate students through examinations and assignments, and offer constructive feedback to facilitate their

1. What are the factors in deciding what form of

1. What are the factors in deciding what form of ownership is best suited for the potential business? (min 200 words) 2. Briefly describe the advantages and disadvantages of a sole proprietorship and partnership. 3. Explain the corporate form of ownership and how a business is incorporated. 4. List the

Hospice or palliative care Describe the mission, vision, nature of

Hospice or palliative care Describe the mission, vision, nature of the business, the services or products, and customers served by your chosen health care organization (Item 1). Identify two to three key problems that have profound impacts on one of the stated areas (Item 2). Propose a minimum of one

What are potential barriers to forming an effective relationship with families? What, if any, might be potential conflicts of interest?

For this journal, you will reflect on what you have learned so far in the course. Select and research the financial documents of a firm to include balance

For this journal, you will reflect on what you have learned so far in the course. Select and research the financial documents of a firm to include balance sheet, income statement, etc. Examine the firm’s working capital management. Look at the firm’s annual report and answer the following questions: What

Global Journal Assignment #3. Write 3 or 4 well-developed paragraphs

Global Journal Assignment #3. Write 3 or 4 well-developed paragraphs about this topic Topic: Give a specific business example of how people in different regions are interconnected. For example, choose a company or product that is made in one country and sold in another country. (made in US and sold abroad

Holistic and Patient-Centered Care

Holistic Care and Treatments The use of complementary and alternative therapies in the treatment of cancer patients, terminal patients, and many other types of patients is steadily increasing. The Resources also contain much information about the various alternative therapies currently being used. For this Discussion, you will consider alternative therapies

English 093 | Essay 2 Assignment The American Dream

The American Dream Topic introduction: What is the American Dream? There are many definitions, and you should find two or three perspectives on what this dream is; you should also analyze how definitions or understandings of the dream have changed over time. (For example, was the American Dream described differently

Define stress, including the three important aspects of stress explained

Define stress, including the three important aspects of stress explained in your book. Describe the main differences between acute and chronic stress. Explain how stressors are different today than they were in our ancestors’ times. Relate this to why and how stress has become a major contributing factor to

Apa format citation and answer the question as asked Week

Apa format citation and answer the question as asked Week 1 assignment Prepare report on Haptic Interface for Mobile Technology. It should be in IGU writing format Your two pages MS Word document should address the following topics. Definition of haptic interface. The difference between Haptic Touch vs 3D Touch

Chapter 4: How do you think planning in today’s organizations compares to planning in an organization 25 years ago? Do you think planning becomes more

Chapter 4: How do you think planning in today’s organizations compares to planning in an organization 25 years ago? Do you think planning becomes more important or less important in a world where everything quickly changes and crises are a regular part of organizational life? Why? Chapter 4: Is

Answer the questions in the end based on the case

Answer the questions in the end based on the case study- 70 words per answer NO REFERENCES NEEDED Leaked Movie Trailer and a Confidentiality Agreement Jessica Silliman Luke Cavanaugh was an assistant editor at a large-scale, Los Angeles-based company which produced movie trailers, television spots and other promotional material. As

Also, for For each of the learning objectives, provide an an Nursing Assignment Help

Also, for For each of the learning objectives, provide an analysis of how the course supported each objective AND show how you met each objective using both classroom and project examples. Explain how the material learned in this course, based upon the objectives, will be applicable to professional practice. Provide