Create given tables with ID as suffix (for example, I would create REP table as REP_0111111, where
Fantastic news! We've Found the answer you've been seeking!
Question:
- Create given tables with ID as suffix (for example, I would create REP table as REP_0111111, where 0111111 is my college ID) with provided column names. Fail to do so will result in 0 points for the assignment. Use most appropriate data types for each column based on data in it. Use DEFAULT value 0 for Balance column in CUSTOMER table. Identify PRIMARY KEY for each table, name and define it at the time of table creation. Copy your CREATE statements in a file as you will submit them.
- Add a new table: CATEGORY (CatId, CatDesc) with CatId with same data type as Category field in the ITEM table.
- Add a PaymentStatus column to ORDER table to store ‘P’ or ‘U’ (paid or unpaid) data in the future.
- Use created tables to add FOREIGN KEY, NOT NULL, UNIQUE and CHECK constraints with the ALTER statement, as appropriate.
- INSERT given records in to the tables. For CATEGORY table, use CatID from ITEM table’s Category column and use appropriate CatDesc.
- Add a record for yourself in the CUSTOMER table and create appropriate record in ORDERS and ORDERLINE table.
Upload the following to Blackboard drop-box in single MS-Word file.
- all CREATE/ALTER statements used to accomplish the tasks
- structures (DESCRIBE), data records (SELECT *) and constraint information by each table in form of screenshots.
Expert Answer:
Related Book For 
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
