The following assignment is based on the business scenario for which you created both an entity-relationship diagram and a normalized database design in Week 2. For this assignment, you will create multiple related tables that match your normalized database design. In other words, you will implement a physical design (an actual, usable database) based on a logical design. Refer to the linked W3Schools.com articles “SQL CREATE TABLE Statement,” “SQL PRIMARY KEY Constraint,” “SQL FOREIGN KEY Constraint,” and “SQL INSERT INTO Statement” for help in completing this assignment. To Complete This Assignment: Use the CREATE TABLE statement to create each table in your design. Note that a table in a RDMS corresponds to an entity in an entity-relationship diagram. Recommended tables for this assignment are CUSTOMER, ORDER, ORDER_DETAIL, PRODUCT, EMPLOYEE, and STORE. As part of each CREATE TABLE statement, define all of the columns, or fields, that you want each particular table to contain. Give them short, meaningful names and include constraints; that is, describe what type of data each column (field) is allowed to hold and any other constraints, such as size, range, or uniqueness. Note that any field you marked as a unique identifier in your normalized database design is a key field. Key fields must be described as both UNIQUE and NOT NULL, which means a value must exist for each record and that value must be unique across all records. After you have created all six tables, including relationships between the tables as appropriate (matching the primary key in one table to a foreign key in another table), use the INSERT INTO statement to insert 10 records into each of your tables. You will need to make up the data you insert into your tables. For example, to insert one record into the CUSTOMER table, you will need to invent a customer number, a customer name, and so on—one value for each of the fields you defined for the CUSTOMER table—to insert into the table. To ensure that your INSERT INTO statements succeeded in populating your tables, use the SELECT statement described in Ch. 7, “Introduction to Structured Query Language,” in Database Systems: Design, Implementation, and Management.to retrieve the records you inserted. For example, to see all 10 records you inserted into the CUSTOMER table, you might apply the following SQL statement: SELECT * FROM CUSTOMER; After you have created all six tables and populated ten records in each table, submit to the Assignment Files tab the database containing all of the tables you created, or a Microsoft® Word document listing all of the SQL statements you used. Brewton Order Customer number: 9876 Brewton Enterprises, Inc. Order Form Customer name: John Doe Customer address: 456 Bishop Street Honolulu, Hawaii 96813 Tel: (808) 8650990 Sales agent: Lloyd Johnson Sales agent number: S99 Product No. Description Quantity Unit Price Normalization of Brewton Enterprises, Inc. Order Form (Brewton Business Scenario) UNF 1NF 2NF 3NF Entity Name Product No.* Product No.* -No. of Employees) - No. Employee Positions) -Quantity) - Unit Price) -No. of Employees) - No. Employee Positions) -Quantity) - Unit Price) -Employees - Employee -Quantity - Price Employees Quantity Price No. of Employees) No. Employee Positions) Page Break Location of Business* Quantity) Unit Price)
Our Amazing Features
-
Plagiarism Free Work
Our experts provide 100 % original and customized work On time Delivery
-
24*7 Customer Support
We provide 24*7 online customer supports via online chat or email
-
Cover All Subject
JQA is one stop solution for all subject’s Assignment. We can provide assignment help for almost all subjects.
-
Best Industry experts
We have 1000+ PHD and Post Graduate experts.
Hire a tutor
Assignment hero
USA
I am an experienced tutor of 7+ years in all math, physics, and Spanish, SAT, and ACT tutoring. I love working with students and seeing them improve on and grasp concepts!
Guru
USA
Need help in Maths and science ? Look no further . contact me so i can help you . i have been a academic tutor for 10 years . Hire me for help in assignments.
Vikas
USA
After 13 years of working with students across the country, we have the experience and knowledge to provide the best possible academic support for your academics.
Rgaurav
India
I have experience teaching AP Calculus AB and BC, Algebra I, Algebra II, Trigonometry, SAT Math Preparation, and Geometry. I have tutored students ranging from 8th grade to college students.
Question Attachments
5 attachments —