Database Design

Database Design and Implementation
Assessment Description

This is an individual assignment. You must make a reasonable attempt at all parts to obtain a passing grade.

Don't use plagiarized sources. Get Your Custom Essay on
Database Design
From as low as $9/Page
Order Essay

Objective: Construct a small commercial database and demonstrate its functionality

Identify and examine three different websites that offer an online purchasing facility. Look particularly at the interactive pages used for the purchasing function and from these lists all the fields that have to be completed by the purchaser for each site. (Note that you do not have to limit yourself to data-entry fields, for higher marks analyze the websites for other possible attributes.) From your three sets of attributes, produce one generic list. (15%)
From this generic list, construct an Extended Entity-Relationship (EER) diagram for a database that would support an on-line purchasing facility. Construct a supporting Table Schema. Explain your thinking, and any assumptions made in this process. (25%)
Using the software provided, build tables to represent the entities from the Table Schema. Invent data to represent stock for the tables created. Insert six records into each table. Provide screen dumps of all the CREATE TABLE statements and the completed tables. (10%)
Design five data retrieval queries for this database that demonstrate your skill with SQL and run them. Provide screen dumps to show each query and its output, explain for each query what it was intended to do, and how the data from the tables proves its successful operation. Demonstrate complex system queries for higher marks. (50%) For more information on Database Design check on this: https://en.wikipedia.org/wiki/Database_design

Custom Homework Writing Service

The Homework Writings
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

Thehomeworkwritings.com’s team of writers write all papers from scratch. We deliver 100% original, unique papers. That’s what makes us the best custom homework writing service

Free Revisions

We provide unlimited free revisions to all customers and on all papers. Try The Homework Writings today for the best custom homework writing service and experience in the industry.

Title-page

Thehomeworkwritings.com gives clients title pages free of charge. Your only job is to fill out our order form. We will handle the rest.

Bibliography

As the leading essay writing service, we never submit any paper without a reference/bibliography page. We do this free of charge too.

Originality & Security

At Thehomeworkwritings.com, we take great pride in delivering only high-quality 100% original papers to all our clients. We also never share any of our clients’ information with third parties. Your data is safe with us.

24/7 Customer Support

No other custom homework writing service has a friendly, always available customer support team to respond to clients like us.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Why outsource our services

We have the best customer support team for your essay writing needs.

Pricing

Flexible Pricing

You won’t find any other custom homework writing service with pricing as flexible and affordable as ours.

Communication

Admission help & Client-Writer Contact

We provide a direct line of communication with our writers for the best writing experience.

Deadlines

Paper Submission

As the leading custom homework writing service, we take deadlines very seriously. You will have your paper submitted on time without any delays.

Reviews

Customer Feedback

We truly value your feedback, good or bad, and always use your feedback to help us provide you with an even better custom homework writing service