Answered step by step
Verified Expert Solution
Question
1 Approved Answer
LAB 01 - SUBMISSION Answer the following questions in the provided space. Save your file as a PDF file and name it as following: BTM210_LO1_LastName.sql.
LAB 01 - SUBMISSION Answer the following questions in the provided space. Save your file as a PDF file and name it as following: BTM210_LO1_LastName.sql. Tasks: By navigating through SQL Developer and looking at the Columns, Data, model, and Constraints tabs for the given tables. You will answer the following questions. NOTE: In Question (a), some questions are answered as examples. You need to complete the rest. Add more rows to the tables in the document if you need more space for an answer. Use a different color for your answers. For the given tables in your database, answer the following questions: a) Answer the following Question for the CONTACTS table. 1) How many columns (attributes) are there in this table? 2) How many rows are there in this table? 3) List the table's columns and the requested information in the following format: Column Name CONTACT ID Type NUMBER Not Null YES 4) Sort the data based on the third column in your table and write the data of the first row in the following format: (Make sure CHATACTER type values are enclosed in single quotes.) Column name Column Value CONTACT_ID 218 FIRST_NAME 'Lucius LAST_NAME 'Abbott EMAIL lucius.abbott@lennar.com PHONE +91 80 012 4783 CUSTOMER_ID 218 5) List all constraints in this table. If a constraint is a foreign key, write the reference table. Constraint Name Constraint Constraint on Type Column FK_CONTACTS CUSTOMERS Foreign Key CUSTOMER ID Reference Table Constraint Condition CUSTOMERS 6) What tables are in relationship with this table? List them below. Table Name Column in Common CUSTOMERS CUSTOMER ID Refers to CONTACT (CUSTOMER_ID) 7) What is the model for this table relationships? NOTE: V means MANY means ONE MANY (V) is close to Contacts. You read "many Contacts". ONE (+) is close to customers. You read "one customer". RADOS CONTACTE MAR LAMA EML PON CUSTOMER CONTACT CONTACTS SOTTOSTORY WEBSITE RENTUIT OVITOMERTER 8) Translate the relationships in Question 7 (model) to English. A customer have many contacts. A contact refers to one customer. b) Answer the following Question for the CUSTOMERS table. 1) How many columns (attributes) are there in this table? 2) How many rows are there in this table? 3) List the table's columns and the requested information in the following format: Column Name Type Not Null 4) Sort the data based on the third column in your table and write the data of the first row in the following format: (Make sure CHATACTER type values are enclosed in 'single quotes'.) Column Name Column Value 5) List all constraints in this table. If a constraint is a foreign key, write the reference table. Constraint Name Constraint Type Constraint on Column Reference Table Constraint Condition b) Answer the following Question for the CUSTOMERS table. 1) How many columns (attributes) are there in this table? 2) How many rows are there in this table? 3) List the table's columns and the requested information in the following format: Column Name Type Not Null 4) Sort the data based on the third column in your table and write the data of the first row in the following format: (Make sure CHATACTER type values are enclosed in 'single quotes'.) Column Name Column Value 5) List all constraints in this table. If a constraint is a foreign key, write the reference table. Constraint Name Constraint Type Constraint on Column Reference Table Constraint Condition 6) What tables are in relationship with this table? List them below. Table Name Column in Common Refers to 7) What is the model for this table relationships? NOTE: V means MANY means ONE 8) Translate all the relationships in Question 7 (model) to English. c) Answer the following Question for the EMPLOYEES table. 1) How many columns (attributes) are there in this table? 2) How many rows are there in this table? 3) List the table's columns and the requested information in the following format: Column Name Type Not Null c) Answer the following Question for the EMPLOYEES table. 1) How many columns (attributes) are there in this table? 2) How many rows are there in this table? 3) List the table's columns and the requested information in the following format: Column Name Type Not Null 4) Sort the data based on the third column in your table and write the data of the first row in the following format: (Make sure CHATACTER type values are enclosed in single quotes.) Column Name Column Value 5) List all constraints in this table. If a constraint is a foreign key, write the reference table. Constraint Name Constraint Type Constraint on Column Reference Table Constraint Condition 6) What tables are in relationship with this table? List them below. Table Name Column in Common Refers to 7) What is the model for this table relationships? NOTE: V means MANY means ONE 8) Translate all the relationships in Question 7 (model) to English. d) Answer the following Question for the ORDERS table. 1) How many columns (attributes) are there in this table? 2) How many rows are there in this table? 3) List the table's columns and the requested information in the following format: Column Name Type Not Null 4) Sort the data based on the third column in your table and write the data of the first row in the following format: (Make sure CHATACTER type values are enclosed in single quotes.) Column Name Column Value 5) List all constraints in this table. If a constraint is a foreign key, write the reference table. Constraint Name Constraint Type Constraint on Column Reference Table Constraint Condition 6) What tables are in relationship with this table? List them below. Table Name Column in Common Refers to 7) What is the model for this table relationships? NOTE: V means MANY means ONE 8) Translate all the relationships in Question 7 (model) to English. e) Answer the following Question for the PRODUCTS table. 1) How many columns (attributes) are there in this table? 2) How many rows are there in this table? 3) List the table's columns and the requested information in the following format: Column Name Type Not Null Column Name Type Not Null 4) Sort the data based on the third column in your table and write the data of the first row in the following format: (Make sure CHATACTER type values are enclosed in single quotes.) Column Name Column Value BTM210 - Structured and unstructured Data Management Winter 2021 5) List all constraints in this table. If a constraint is a foreign key, write the reference table. Constraint Name Constraint Type Constraint on Column Reference Table Constraint Condition 6) What tables are in relationship with this table? List them below. Table Name Column in Common Refers to 6) What tables are in relationship with this table? List them below. Table Name Column in Common Refers to 7) What is the model for this table relationships? NOTE: V means MANY means ONE Translate all the relationships in Question 7 (model) to English. Good Luck
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started