Create all the tables that you had finally designed through the normalization process (that is the final tables in 3NF

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Task: Table creation and Management

Online students – Please listen to the class lecture Recording before starting this assignment otherwise you might lose points if done incorrectly.

1. From Project 1 - Create all the tables that you had finally designed through the normalization process (that is the final tables in 3NF). Remember to create them with constraints for primary and foreign keys – give constraint names ending with _PK, _FK,

_CK along with their column names. Paste the screen shots of the SQL you used to create each one. (6 points).

2. Perform DESC command and query the user_constraints table to confirm the constraints you added – for ‘each’ of the Tables created in above step. Paste the screen shot of the DESC and user_constraints query SQL and results.

(3 points).

3. Insert the ‘data’ rows (Project 1 – 3NF) into each table. Paste screen shot of each of the insert SQLs and result for each table. Please remember to end each of your INSERT commands with a COMMIT; otherwise you might lose the rows you inserted if you didn’t exit out of Oracle correctly. (3 points)

4. Query each of the Tables using Select * query and verify the data. Paste the SQL and results showing the data you inserted in the table. (3 points)

Note: Incase your table has a Foreign key then follow these pointers:

• Make sure you create ‘first’ the table for which the field is a PK.

• FK constraint name should be same as PK constraint name except for fk in the end – example

invoice_num_pk, invoice_num_fk… … more examples…

Now incase you need to ALTER the constraint name you can use ALTER command

ALTER TABLE invoice_info RENAME CONSTRAINT test1_pk TO test_pk;

• When inserting data/rows the FK column ‘data values’ should ‘exactly’ match the PK column values otherwise you get an error.

Attachments:

Expert's Answer

887 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme