1- For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 3. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key

Based on the following ER model and business rules, write an SQL statement to create COURSE and COURSE_PREREQ table. Be sure to implement all related data integrity constraint. For each column, use the data type as you think appropriate. Business rule • A course may have more than one prerequisites. The prerequisite courses may have their own prerequisite courses (more than one). COUSE entity • CourseNo is a UID (unique identifier). • Credit hours should be greater than 0 and less than 7. COURSE_PREREQ entity • UID is the composite of CourseNo and CourseNo (i.e., prerequisite courseNo). COURSE COURSE_PREREQ CourseNo: UID Title Description CourseNo: LCourseNo: UID CreditHours

What is commonly used to represent a relation? Select one: a. an index b. a schema c. a table d. a view

You are working with a database table that contains invoice data. The table includes columns for invoice_id and billing_state. You want to remove duplicate entries for billing state and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the billing_state column. NOTE: The three dots (...) indicate where to add the clause. SELECT ... FROM invoice ORDER BY invoice_id What billing state appears in row 17 of your query result? 1 point 1-CA 2-NV 3-WI 4-AZ

For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None.

QUESTION 13 If a table is in "third normal form" it means that it is in: O a. first normal form and all secondary keys depend on the entire primary key. O b. first normal form and has three secondary keys. O c. first normal form and has no transitive dependencies O d. second normal form and has no repeating groups. O e. second normal form and has no transitive dependencies. QUESTION 14 Which the following is NOT a rule of relational database tables? O a. duplicate columns and rows are not allowed within a table O b. the sequence of rows and columns does not matter O c. each table in the database must have a unique name O d. every table must have a designated primary key O e. every table must have at least two columns QUESTION 15 Consider the following data table: Project 101 102 The above data table has: O a. a composite primary key O b. a transitive dependency Description Interim audit Tax Work c. a repeating group O d. a partial dependency O e. a DESCRIPTION field insert anomaly…

Question 3: Create the DDL statements to create the tables described in your modified ER diagram in question 2: DDL Statement: CREATE TABLE School ( school_code integer Primary Key(10), location varchar(25), name varchar(10) ); CREATE TABLE Professors ( staff_id integer(10), name varchar(20), school varchar(30) ); CREATE TABLE Course ( subject_code varchar(10), school varchar(30), name varchar(10) ); CREATE TABLE Subject ( subject_code(10), school varchar(30), name varchar(10) ); CREATE TABLE Student ( student_id number(10), name varchar(10), address varchar(30), phone number(10) ); Table Description desc table School; Select * from School; Name                       Null              Type school_code Not null integer location Not null varchar(25) name Not null varchar(10)   desc table Professor; Select * from Professor; Name               Null              Type staff_id Not null number(10) name   varchar(20) school   varchar(30)   desc table Course; Select * from…