Part II. Table creation and data insertion 2- Write a SQL script to create a...
90.2K
Verified Solution
Link Copied!
Question
Accounting
Part II. Table creation and data insertion 2- Write a SQL script to create a new database called "UCL". Create the tables based on your designs in Part I in this database. Save the script as Asg3_Q2.sql. Name the constraints using tableName columnName constraint format. For example, if the customer name is a required field (not null), name the constraint as CUSTOMER_NAME_NN. 3- Run the above script and verify that the tables and constraints were created properly by executing the command describe "tableName" 4- Add at least two rows in each table, you can use the description given in Assignment 1 or think about your usage experience with Seneca Security Lab to give you an idea for sample data. Create a script to enter the information. Save the statements in a script named Asg3_Q4.sql. 5- When done, query all rows of all tables (select *) save the script as Asg3_Q5.sql and save output in Asg3_Q5.txt
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
