A. What does the integrity constraint perform in DBMS? Create a table and use at least...

 

Transcribed Image Text:

A. What does the integrity constraint perform in DBMS? Create a table and use at least 3 constraints on its attributes, then insert one record into that table [5 points] B. Write SQLite queries for each of the following [15 points]: 1. Given the following table instructor: ID name dept_name salary 22222 Einstein Physics 95000 12121 Wu Finance 90000 32343 El Said History 60000 45565 Katz Comp. Sci. 75000 98345 Kim Elec. Eng. 80000 76766 Crick Biology 72000 10101 Srinivasan Comp. Sci. 65000 58583 Califieri History 62000 83821 Brandt Comp. Sci. 92000 15151 Mozart Music 40000 33456 Gold Physics 87000 76543 Singh Finance 80000 Find all departments which have more than 2 instructors 2. Creating relation account = (account number, customer_name, account_type, branch_name, balance). The primary key of the table is account number, and the branch_name is a foreign key from the branch table. For account_type, you must use an integrity constraint to check so that only "checking" or "savings" are allowed to insert 3. Display a sorted list of all the departments in the table instructor by their average salaries. A. What does the integrity constraint perform in DBMS? Create a table and use at least 3 constraints on its attributes, then insert one record into that table [5 points] B. Write SQLite queries for each of the following [15 points]: 1. Given the following table instructor: ID name dept_name salary 22222 Einstein Physics 95000 12121 Wu Finance 90000 32343 El Said History 60000 45565 Katz Comp. Sci. 75000 98345 Kim Elec. Eng. 80000 76766 Crick Biology 72000 10101 Srinivasan Comp. Sci. 65000 58583 Califieri History 62000 83821 Brandt Comp. Sci. 92000 15151 Mozart Music 40000 33456 Gold Physics 87000 76543 Singh Finance 80000 Find all departments which have more than 2 instructors 2. Creating relation account = (account number, customer_name, account_type, branch_name, balance). The primary key of the table is account number, and the branch_name is a foreign key from the branch table. For account_type, you must use an integrity constraint to check so that only "checking" or "savings" are allowed to insert 3. Display a sorted list of all the departments in the table instructor by their average salaries.