2. a) Using SQL query language technique Construct the following relational model. department ld Name Compenyid...

Transcribed Image Text:

2. a) Using SQL query language technique Construct the following relational model. department ld Name Compenyid department employeee Departmentid Employeeld Title company Vid Name employee ld LastName FintName b) Prepare the "Customer" table using the following SQL Constraints. (Customer table Column name is: Id, name, Salary, Age) "UNIQUE", "DEFULT" and "NOT NULL" c) Illustrate the different types of "JOIN" clauses supported in ANSI-standard SQL. 2. a) Using SQL query language technique Construct the following relational model. department ld Name Compenyid department employeee Departmentid Employeeld Title company Vid Name employee ld LastName FintName b) Prepare the "Customer" table using the following SQL Constraints. (Customer table Column name is: Id, name, Salary, Age) "UNIQUE", "DEFULT" and "NOT NULL" c) Illustrate the different types of "JOIN" clauses supported in ANSI-standard SQL.

Answer rating: 100% (QA)

a Here is an SQL query to create the tables for the given relational model sql CREATE TABLE departme... View the full answer