Insert Title
-236220-838835Create a DatabaseThe 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 articles “SQL CREATE TABLE Statement,” “SQL PRIMARY KEY Constraint,” “SQL FOREIGN KEY Constraint,” and “SQL INSERT INTO Statement” for help in completing this assignment.Note: In the industry, even the most carefully thought out database designs can contain mistakes. Feel free to correct in your tables any mistakes you notice in your normalized database design. Also, note that in Microsoft? Access?, you follow the steps below to launch the SQL editor:Figure 1. To create a SQL query in Microsoft? Access?, begin by clicking the CREATE tab.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. ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- lab 2 introduction to ms access
- insert title
- table valued functions the key idea
- you want to create tables with sql because
- large object storage database or filesystem
- data definition statements in ms access
- introduction claros data management hach
- disaster recovery for sql server
- microsoft word
- sql final project jason muhle s e portfolio
Related searches
- frontline gold package insert pdf
- excel insert list box
- fluzone package insert 2019
- fluzone package insert 2019 20
- fluzone package insert pdf
- fluzone high dose package insert 2019
- fluzone package insert 2018 19
- fluzone package insert fda
- fluzone quadrivalent package insert 2019
- fluzone package insert 2019 2020
- insert math problem get answer
- how to insert mla citation