Question

data base

Given the data model shown below, please define the following: 1) Table names 2) Primary keys for each table. If the key is composite, please indicate. 3) Foreign Keys for each table and what table/field the FK relates to 4) Define which table is the "Parent" and is the "Child" in the relationship. EMPLOYEE(Employee Number, ElastName, FirstName, EAddress, Ecity, EZipCode, EDepartCode) DEPARTMENT(DepartmentCode, DeptName, Dept Div) DIVISION(DivisionCode, DivName, DivvP) EPHONE(PhoneID, EmpNum, Phone Number, Phone Type) TTT Arial 3 (12pt) - T. . Pathep Words:0

Answer 1

Daie : ................ 11) Table name in Dbms is relation name Table names for the data modd given is : EMPLOYEE DEPARTMENT, DIVISION ÉPHONE in key or primary is a column set of columns in a table that uniquely identi -fies rows of the table! key for EMPLOYEE is Employee number which uniquely identifies all the rows in tablet EMPLOYEE. Primary key for DEPARTMENT is Department code which uniquely de identifies all ru in the table DEPARTMENT

Date: Primary key for table DIVISION is Diulision code? Primary key for EPHONE table is phone. In EmbNum) which is a composite key because it consists I of more than - 3). foreign they a colun or *012 that? uniquely in another tal EmpNum of EPHONE table is anker and it references to EMPLOYEE table. EPHONE referenus EMPLOYEE 4). Empnum Employee Number foreign by se table Foreign Primary key boy

Dale ....... A pament is the table that melores the primary rekrences the X barent with a foreign wey so EMPLOYEE is Parent an wiltra Employer Number as primary key and EPHONE is a child relation with Emplum as foreign key -------------------------