You are required to create a database for a fictitious Online Shoe Store called WalkthisWay' (think...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are required to create a database for a fictitious Online Shoe Store called WalkthisWay' (think Williams Shoes or Novo) for Task 1. Write an SQL script that builds a database to match the relational model below. These SQL statements in the script must be provided in the correct order. The solution will be demonstrated in one or more MySQL screen snapshots that include the Execute SQL tab SQL code and the results of the executed statements. StoreEmployee (empid, eName, eAddress, ePostCode, eEmail, eMobPh, eStartDate, storeld) Customer (custid. cName, cMobilePh, cEmail, cBirthDate) Order (orderld. oDate, total, GST, deliveryAddress, orderStatus, custid) OrderDetail (orderld, prodld, quantity, retailPrice) Payment (payld, type, amount, pDate, bank TransactNo, orderld) Product (prodid, size, colour, style, qtyOnHand, reorderQty, retail Price, supirid) ProductSupplier (prodid, supirid) Supplier (suplrld, supirName, suplrAddress, suplrPostCode, suplrEmail, suplrMobPh) FOREIGN KEYS • StoreEmployee(storeld) references Store (storeld) • Order (custld) references Customer(custld) • OrderDetail(orderld) references Order(orderld) • OrderDetail(prodld) references Product(prodid) • Payment(orderld) references Order(orderld) • Product(supirid) references Supplier(suplrld) • ProductSupplier(prodid) references Product(prodid) • ProductSupplier(supirld) references Supplier(suplrld) Other Constraints and Remarks • All primary and foreign key attributes are strings (not text) comprising seven digits. • All PostCodes are strings comprising four digits. • INTEGER type must be used for total, GST, quantity, retailPrice, qtyOnHand, reorderQty, and amount. • TEXT type must be used for all other attributes. • sName, eName, cName, suplrName must contain a value (you will need to add values to these attributes) • MY SQL has order as a keyword, to create this table you will need to use the backward quotation mark as shown Order". You are required to create a database for a fictitious Online Shoe Store called WalkthisWay' (think Williams Shoes or Novo) for Task 1. Write an SQL script that builds a database to match the relational model below. These SQL statements in the script must be provided in the correct order. The solution will be demonstrated in one or more MySQL screen snapshots that include the Execute SQL tab SQL code and the results of the executed statements. StoreEmployee (empid, eName, eAddress, ePostCode, eEmail, eMobPh, eStartDate, storeld) Customer (custid. cName, cMobilePh, cEmail, cBirthDate) Order (orderld. oDate, total, GST, deliveryAddress, orderStatus, custid) OrderDetail (orderld, prodld, quantity, retailPrice) Payment (payld, type, amount, pDate, bank TransactNo, orderld) Product (prodid, size, colour, style, qtyOnHand, reorderQty, retail Price, supirid) ProductSupplier (prodid, supirid) Supplier (suplrld, supirName, suplrAddress, suplrPostCode, suplrEmail, suplrMobPh) FOREIGN KEYS • StoreEmployee(storeld) references Store (storeld) • Order (custld) references Customer(custld) • OrderDetail(orderld) references Order(orderld) • OrderDetail(prodld) references Product(prodid) • Payment(orderld) references Order(orderld) • Product(supirid) references Supplier(suplrld) • ProductSupplier(prodid) references Product(prodid) • ProductSupplier(supirld) references Supplier(suplrld) Other Constraints and Remarks • All primary and foreign key attributes are strings (not text) comprising seven digits. • All PostCodes are strings comprising four digits. • INTEGER type must be used for total, GST, quantity, retailPrice, qtyOnHand, reorderQty, and amount. • TEXT type must be used for all other attributes. • sName, eName, cName, suplrName must contain a value (you will need to add values to these attributes) • MY SQL has order as a keyword, to create this table you will need to use the backward quotation mark as shown Order".
Expert Answer:
Answer rating: 100% (QA)
we have created a database called walkthisway CREATE DATABASE Walkthisway USE Walkthisway Create the store table CREATE TABLE store storeid CHAR7 NOT ... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
Question 4 $1200. $700 h $100 800 1500 2000 D Q Given the market for cups depicted in the graph above, the producer surplus is equal to: 2 pts
-
You are required to write a Python program that will manage character (heroes and villain) information. Character (hero and villain) information will be stored in a text file that will be read in...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Identify and describe a time (that you would be comfortable sharing for the purposes of this assignment) when you faced a challenge in a friendship, like a betrayal or geographic distance.
-
Perform the operation and write the result in standard form. 1. (5 + i) + (2 + 3i) 2. (13 2i) + (5 + 6i) 3. (9 i) (8 i) 4. (3 + 2i) (6 + 13i)
-
What is a pie chart? What is a bar chart? When might one be preferable over the other?
-
Which of the following procedures is not appropriate for identifying laws and regulations that management may have overlooked? a. Discussing laws and regulations with the entity's chief financial...
-
Short-term automobile rentals are Snap Rentals, Inc.s specialty. Average variable operating costs have been $20 per day per automobile. The company owns 50 automobiles. Fixed operating costs for the...
-
Super Challenge Problem Determined to test gravity, a student walks off the Burj Khalifa (aka really tall building) in Dubai, which is 829 m high, and falls freely. His initial velocity is zero....
-
An older man has just lost his job after repeated warnings to come to work sober and seek help for his alcohol addiction. He has decided that he should get help now. Too little, too late, he says...
-
Refer to the 4-month data below of telephone bill, apply the high-low method to answer the question. If the company uses 380 minutes in May, how much will the total bill be? Minutes January 460...
-
Explain how the stockholding period is calculated.
-
Explain the circumstances in which return on investment is preferable as a measure of divisional performance.
-
Rather than a focus group, for this activity think about depth interviews with your friends. What questions would you ask them? Compare these questions to the focus group questions. How are they...
-
ACT Doorland was founded in 1957 as a small concern whose core business was the supply and installation of garage doors. Since then it has diversified its interests and expanded to become Canberras...
-
How do the managers of a business maintain its competitive position.
-
Study the standard reduction potential given below and answer the questions that follow. The letters are not actual symbols of the elements Actual symbols of elements EQ values M (aq) 2+ + 2e M(s)...
-
What is the back work ratio? What are typical back work ratio values for gas-turbine engines?
-
Describe the purpose of the INTERSECT command in relational algebra.
-
What is an OODBMS?
-
For the following exercises, you will address problems and answer questions from management at TAL Distributors. You do not use the TAL Distributors database for any of these exercises. 1. While...
-
Find the flexibility and stiffness influence coefficients of the torsional system shown in Fig. 6.28. Also write the equations of motion of the system. (GJ)1 01 Compressor (GJ)2 (Jan) Turbine (142)...
-
Derive the flexibility matrix of the system shown in Fig. 5.42. 00000 2m 8(t) * 2m ellee x(t) m 00000 FIGURE 5.42 Rigid bar connected to masses and springs.
-
Derive the stiffness matrix of the system shown in Fig. 5.39. mo e(t) ellee k1 k2 lllll m x(t) FIGURE 5.39 Mass hanging from a pulley.
Study smarter with the SolutionInn App