Reminder: The steps of the project are: ER, mapping, SQL tables, SQL rows, SQL querles. Attach a report about these steps. Project Submission Project Title Company database Requirements // data requirements form the given list ER diagram Frame Mind Lame Number N Namne Address WORKS FOR Location Name Say Number Employees DEPARTMENT StartDate EMPLOYEE 1 MANAGES CONTROLS Hours M supervisor Supervise WORKS_ON PROJECT SUPERVISION N Name Location Number DEPENDENTS_OF DEPENDENT Name Sex Birth Date Relationship Mapping EMPLOYEE FNAME MINIT NAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT LOCATIONS DNUMBER DLOCATION PROJECT PNAME PNUMBER PLOCATION DNUM WORKS ON ESSN PNO HOURS DEPENDENT ESSN DEPENDENT NAME SEX BDATE RELATIONSHIP SQL Tables - dbo.department dbo.dependent #dbo.dept locations dbo.employee Columns fname (varchar(25), not null) minit (varchar(1), null) Iname (varchar(25), not null) ssn (PK, char(9), not null) bdate (date, null) address (varchar(50), null) sex (char(1), null) salary(int, null) superssn (FK char(9), null) - dno (FK, int, null) Keys Constraints Triggers Indexes Statistics dbo.project Columns pname (varchar(25), not null opnumber (PK, int, not null) plocation (varchar(25), null) w dnum (FK, int, not null) SQL Data Rows EMPLOYEE FNAME MINIT LNAME Smit SEN 123456789 33344555 989887777 BDATE 1905-01-09 SEX M M F SALARY 30000 40000 SUPERSON ONO 333445505 5 S S87654321 T J Zelaya Frank Akce Jenner Ramesh Joyce Ald James ADDRESS 731 Fordon Houston TX Vol. Houston, TX 3321 Categ. TX 291 Bany, Belle, TX 975 Freak. Humble. TX 5631 Rios, Hoston, TX Wo Dalia, Hun, TX 150 Stone Houston, TX Narayan 1968-07-19 1981-06-20 1992-09-15 1ST2-07-31 K A V E 333445505 DO6884444 453453453 M F M DO 38000 25000 2-5000 52 5 S Jabbar 1937-11-10 DEPT LOCATIONS DNUMBER DLOCATION 4 Stafford DEPARTMENT DNUMBER MGRSTARTDATE DNAME Research Administration How 5 MGRSSN 333445555 987654321 B65565 Sugarland Houten 4 1 1995-01-01 1981-06-10 WORKS ON HOURS ESSN 123456789 PNO 1 463453463 1 2 PROJECT PNAME 333646565 333146565 PNUMBER 1 PLOCATION Eclaire 3 10 20 200 200 1010 100 1010 100 300 100 DNUM 5 5 5 4 Product Product Computation Nienburts Houston 10 20 30 Houston GOOSB7777 10 68 886 888 50 987654321 087654321 150 20 20 DEPENDENT ESSN IS 333445565 DEPENDENT NAME Ale Theodoro Joy Abner BDATE 1-01-05 1983-10-25 RELATIONSHIP DALKHTER SON SEX F M F M M F F S87654321 171456 123456789 123456789 Alice Elsbeth 1942-02-28 1988-12.30 1967-05-05 SPOUBE SON DAUGHTER SPOUSE SQL queries List the SSN and full name of all employees Select SSN, fname, Iname from Employee . Reminder: The steps of the project are: ER, mapping, SQL tables, SQL rows, SQL querles. Attach a report about these steps. Project Submission Project Title Company database Requirements // data requirements form the given list ER diagram Frame Mind Lame Number N Namne Address WORKS FOR Location Name Say Number Employees DEPARTMENT StartDate EMPLOYEE 1 MANAGES CONTROLS Hours M supervisor Supervise WORKS_ON PROJECT SUPERVISION N Name Location Number DEPENDENTS_OF DEPENDENT Name Sex Birth Date Relationship Mapping EMPLOYEE FNAME MINIT NAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT LOCATIONS DNUMBER DLOCATION PROJECT PNAME PNUMBER PLOCATION DNUM WORKS ON ESSN PNO HOURS DEPENDENT ESSN DEPENDENT NAME SEX BDATE RELATIONSHIP SQL Tables - dbo.department dbo.dependent #dbo.dept locations dbo.employee Columns fname (varchar(25), not null) minit (varchar(1), null) Iname (varchar(25), not null) ssn (PK, char(9), not null) bdate (date, null) address (varchar(50), null) sex (char(1), null) salary(int, null) superssn (FK char(9), null) - dno (FK, int, null) Keys Constraints Triggers Indexes Statistics dbo.project Columns pname (varchar(25), not null opnumber (PK, int, not null) plocation (varchar(25), null) w dnum (FK, int, not null) SQL Data Rows EMPLOYEE FNAME MINIT LNAME Smit SEN 123456789 33344555 989887777 BDATE 1905-01-09 SEX M M F SALARY 30000 40000 SUPERSON ONO 333445505 5 S S87654321 T J Zelaya Frank Akce Jenner Ramesh Joyce Ald James ADDRESS 731 Fordon Houston TX Vol. Houston, TX 3321 Categ. TX 291 Bany, Belle, TX 975 Freak. Humble. TX 5631 Rios, Hoston, TX Wo Dalia, Hun, TX 150 Stone Houston, TX Narayan 1968-07-19 1981-06-20 1992-09-15 1ST2-07-31 K A V E 333445505 DO6884444 453453453 M F M DO 38000 25000 2-5000 52 5 S Jabbar 1937-11-10 DEPT LOCATIONS DNUMBER DLOCATION 4 Stafford DEPARTMENT DNUMBER MGRSTARTDATE DNAME Research Administration How 5 MGRSSN 333445555 987654321 B65565 Sugarland Houten 4 1 1995-01-01 1981-06-10 WORKS ON HOURS ESSN 123456789 PNO 1 463453463 1 2 PROJECT PNAME 333646565 333146565 PNUMBER 1 PLOCATION Eclaire 3 10 20 200 200 1010 100 1010 100 300 100 DNUM 5 5 5 4 Product Product Computation Nienburts Houston 10 20 30 Houston GOOSB7777 10 68 886 888 50 987654321 087654321 150 20 20 DEPENDENT ESSN IS 333445565 DEPENDENT NAME Ale Theodoro Joy Abner BDATE 1-01-05 1983-10-25 RELATIONSHIP DALKHTER SON SEX F M F M M F F S87654321 171456 123456789 123456789 Alice Elsbeth 1942-02-28 1988-12.30 1967-05-05 SPOUBE SON DAUGHTER SPOUSE SQL queries List the SSN and full name of all employees Select SSN, fname, Iname from Employee
