Services FAQs Pricing Login
Home > Questions > Construct a small commercial database and demonstrate its functionality …
diff_months: 15

Construct a small commercial database and demonstrate its functionality

Download Solution Now
Added on: 2023-02-13 04:59:32
Order Code: 485141
Question Task Id: 0
  1. Identify and examine three different websites which 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 analyse the websites for other possible attributes.) From your three sets of attributes, produce one generic list.  (15%)
  2. 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%)
  3. Using the software provided, build tables to represent the entities from the Table Schema. Invent data to represent stock for the tables created. Insert a decent number of records into each table. Provide screen dumps of all the CREATE TABLE statements and the completed tables. (10%)
  4. 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%)
Download Solution Now
  • Uploaded By : Katthy Wills
  • Posted on : February 13th, 2023
  • Downloads : 0
  • Views : 308

Download Solution Now

Download Solution Now
Download Solution Now

Can't find what you're looking for?

Get Solution Now!

Whatsapp Tap to ChatGet instant assistance

Choose a Plan

Premium

80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing
Most
Popular

Gold

30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%

Silver

20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more