Question: Please answer this question about SQL cardinality and degree the following SQL script which contained a SQL CREATE TABLE which created the storage structure to
Please answer this question about SQL cardinality and degree

the following SQL script which contained a SQL CREATE TABLE which created the storage structure to store that created an employee table named EMP and Department table name named DEPT mployee Table epartment Table CREATE TABLE EMP CREATE TABLE DEPT EMPNO CHAR(6) NOT NULL, DEPTNO DEPTNAME MGRNO ADMRDEPT LOCATION CHAR(3) NOT NULL , VARCHAR(29) NOT NULL , CHAR(6) , CHAR(3) NOT NULL, CHAR(16) ); FIRSTNME VARCHAR(12) NOT NULL , CHAR(1) NOT NULL, MIDINIT LASTNAME VARCHAR(15) NOT NULL, WORKDEPT PHONENO HIREDATE JOB EDLEVEL SEX BIRTHDATE SALARY BONUS COMM CHAR(3), CHAR(4), DATE CHAR(8), SMALLINT NOT NULL, CHAR1), DATE DECIMAL(9,2) DECIMAL(9,2), DECIMAL(9,2 1.3 Questions Degree and Cardinali 5. Using relational model terminology and given previous CREATE TABLE statement, what would be the degree of the relation as applied to the EMP table? Answer => 6. Using relational model terminology and given previous CREATE TABLE statement, why would the degree of the EMP table would be describe asn-ary? Answer> 7. Based on concepts of the relational model, describe the concept of the cardinality as applied to the EMP table? Answer 8. Based on the concept of the cardinality, provide a practical explanation that would explain why cardinality may increase from 10 to 15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
