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

Please answer this question about SQL cardinality and degree the following SQL

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!