Homework SourseQuestion 1 Relational Model and Integrity Constraints 1 5
Question 1. Relational Model and Integrity Constraints. [1 ´ 5 = 5 Points]
Can the following record be inserted into the BRANCH table? Why?
BRANCHNUMBER
BRANCHNAME
BRANCHSTREET
BRANCHCITY
BRANCHSTATE
BRANCHZIP
REVENUETARGET
BRANCHMANAGER
b9
Branch9
E 241 52 St
New York
NY
11010
700000
e77
Yes, since the operation will not violate any integrity constraints.
No, since the operation will violate the following integrity constraint:
Can the following record be inserted into the EMPLOYEE table? Why?
EMPLOYEEID
EMPLNAME
EMPFNAME
EMPTITLE
EMPSTARTDATE
EMPBRANCH
EMPSALARY
EMPSUPERVISOR
e39
Joe
Smith
06/23/2004
b19
450000
e2
Yes, since the operation will not violate any integrity constraints.
No, since the operation will violate the following integrity constraint:
Can the following record be deleted from the INSTLINE table? Why?
ORDERNUMBER
INSTTYPE
HOURS
o1
i1
20
Yes, since the operation will not violate any integrity constraints.
No, since the operation will violate the following integrity constraint:
Can the following record be deleted from the EMPLOYEE table? Why?
EMPLOYEEID
EMPLNAME
EMPFNAME
EMPTITLE
EMPSTARTDATE
EMPBRANCH
EMPSALARY
EMPSUPERVISOR
e3
Clay
Cedric
branch_manager
21-JUN-01
b3
450000
e1
Yes, since the operation will not violate any integrity constraints.
No, since the operation will violate the following integrity constraint:
Can the following record be deleted from the ORDERS table? Why?
ORDERNUMBER
ORDDATE
SALESPERSON
CUSTOMERID
o3
04-NOV-07
e5
c3
Yes, since the operation will not violate any integrity constraints.
No, since the operation will violate the following integrity constraint:
| BRANCHNUMBER | BRANCHNAME | BRANCHSTREET | BRANCHCITY | BRANCHSTATE | BRANCHZIP | REVENUETARGET | BRANCHMANAGER |
| b9 | Branch9 | E 241 52 St | New York | NY | 11010 | 700000 | e77 |
Solution
Can the following record be inserted into the BRANCH table? Why?
No, since the operation will violate the following integrity constraint:
Yes, since the operation will not violate any integrity constraints.
answer:
Yes, since the operation will not violate any integrity constraints.
2. Can the following record be inserted into the EMPLOYEE table? Why?
No, since the operation will violate the following integrity constraint:
we pass a null value to the emptitle.
and date format to be :YYYY-MM-DD
3.Can the following record be deleted from the INSTLINE table? Why?
Yes, since the operation will not violate any integrity constraints.
4. Can the following record be deleted from the EMPLOYEE table? Why?
Yes, since the operation will not violate any integrity constraints.
5.Can the following record be deleted from the ORDERS table? Why?
No, since the operation will violate the following integrity constraint:
Date format in sql should be YYYY-MM-DD
![Question 1. Relational Model and Integrity Constraints. [1 ´ 5 = 5 Points] Can the following record be inserted into the BRANCH table? Why? BRANCHNUMBER BRANCHN](/WebImages/12/question-1-relational-model-and-integrity-constraints-1-5-1012664-1761522898-0.webp "Question 1. Relational Model and Integrity Constraints. [1 ´ 5 = 5 Points] Can the following record be inserted into the BRANCH table? Why? BRANCHNUMBER BRANCHN")
![Question 1. Relational Model and Integrity Constraints. [1 ´ 5 = 5 Points] Can the following record be inserted into the BRANCH table? Why? BRANCHNUMBER BRANCHN](/WebImages/12/question-1-relational-model-and-integrity-constraints-1-5-1012664-1761522898-1.webp "Question 1. Relational Model and Integrity Constraints. [1 ´ 5 = 5 Points] Can the following record be inserted into the BRANCH table? Why? BRANCHNUMBER BRANCHN")
![Question 1. Relational Model and Integrity Constraints. [1 ´ 5 = 5 Points] Can the following record be inserted into the BRANCH table? Why? BRANCHNUMBER BRANCHN](/WebImages/12/question-1-relational-model-and-integrity-constraints-1-5-1012664-1761522898-2.webp "Question 1. Relational Model and Integrity Constraints. [1 ´ 5 = 5 Points] Can the following record be inserted into the BRANCH table? Why? BRANCHNUMBER BRANCHN")
