AusEd Inc: A Not-for-Profit Private Education Organisation
We know that in conceptual database design we need to describe entity name and relationship in the entities. So according to case study there are 11 entities and these are following: –
- EMPLOYEE
- EDUCATION
- BACKGROUND
- STAFF
- TEACHING_STAFF
- ADMINISTRATIVE_STAFF
- STAFF_ACTIVITIES
- LEAVE_ABSENCE
- DATE_LEAVE_ABSENCE
- STAFF_TIMESTAFF
- SUBJECTS
- 1:1 between EMPLOYEE and EDUCATION. Here one EMPLOYEE has one and only one EDUCATION and each EDUCATION also belong to one and only one employee.
- 1:1 between EMPLOYEE and BACKGROUND. Here one EMPLOYEE has one and only one BACKGROUND and each BACKGROUND belongs to one and only one EMPLOYEE.
- 1:1 between EMPLOYEE and STAFF. Here one EMPLOYEE place for one and only one STAFF post and Each STAFF is related to one and only one EMPLOYEE.
- 1:1 between STAFF and TEACHING_STAFF. Here one STAFF has post on one and only one TECAHING_STAFF and Each TEACHING_STAFF is belonging to one and only one STAFF.
- 1:1 between STAFF and ADMINISTRATIVE_STAFF. Here one STAFF has post on one and only one ADMINISTRATIVE_STAFF and each ADMINISTRATIVE_STAFF belonging to one and only one STAFF.
- 1:1 between STAFF and LEAVE_ABSENCE. Here one STAFF has one and only one LEAVE_ABSENCE and each LAEVE_ABSENCE is related to one and only one STAFF.
- 1:M between STAFF and STAFF_TIMESTAFF. Here a STAFF has one or more STAFF_TIMESTAFF and each STAFF_TIMESTAFF is related to one and only one STAFF.
- 1:M between SUBJECTS and STAFF_TIMESTAFF. Here a SUBJECT has one or more STAFF_TIMESTAFF and each STAFF_TIMESTAFF is related to one and only one SUBJECTS.
- 1:M between STAFF and DATE_LEAVE_ABSENCE. Here a STAFF has one or more DATE_LEAVE_ABSENCE and each DATE_LEAVE_ABSENE related to one and only one STAFF.
- 1:M between STAFF and STAFF_ACTIVITIES. Here a STAFF has one or more STAFF_ACTIVITIES and each STAFF_ACTIVITIES related to one and only one STAFF.
We know that in logical database design contains entities name, relationship between entities, attributes, primary key and foreign key. Entities and relationship between entities describe in conceptual database design. Now I explain attributes, primary key and foreign key of entities and there are following: –
- EMPLOYEE: – EMPLOYEE_ID, TITLE, FIRST_NAME, MIDDLE_NAME, LAST_NAME, BIRTHDATE, STREET_ADDRESS, CITY_STATE, POSTAL_CODE, PHONE, MOBILE, DATE_HIRED, DATE_TERMINATED, TFN, DEPARTMENT, LOCATION are attributes. Here EMPLOYEE_ID is primary key.
- EDUCATION: – EMPLOYEE_ID, HIGHEST_EDUCATION_ATTAINMENT, QUALIFICATION, YEAR_COMPLETED, SCHOOL are attributes. Here EMPLOYEE_ID is primary and foreign key.
- BACKGROUNG: – EMPLOYEE_ID, YEAR_STARTED_WORKING, YEAR_FINISHED_WORKING, POSITION, ORGANISATION_NAME, LOCATION are attributes. Here EMPLOYEE_ID is primary and foreign key.
- STAFF: -STAFF_ID, EMPLOYEE_ID, STAFF_STATUS are attributes. Here STAFF_ID is primary key and EMPLOYEE_ID is foreign key.
- TEACHING_STAFF: – STAFF_ID, LOCATION, CONTACT_DETAIL are attributes. Here STAFF_ID is primary and foreign key.
- ADMINISTRATIVE_STAFF: -STAFF_ID, STAFF_POSITION are attributes. Here STAFF_ID is primary and foreign key.
- LEAVE_ABSENCE: – STAFF_ID, NO_OF_LEAVE_ALLOCATED, NO_OF_SICKLEAVE_ALLOCATED, REMAINING_LEAVE, REMAINING_SICKLEAVE are attributes. Here STAFF_ID is primary and foreign key.
- DATE_LEAVE_ABSENCE: – STAFF_ID, DATE, TYPE_OF_LEAVE, PAID_OR_NOPIAD_LEAVE, LA_STATUS are attributes. Here STAFF_ID and DATE is primary key and STAFF_ID is foreign key.
- STAFF_TIMESTAFF: – STAFF_ID, SUBJECT_NO, HOURS_WORKED_PERWEEK, TYPE_OF_WORK, HOURLY_RATE, NO_OF_STUDENT are attributes. Here STAFF_ID and SUBJECT_NO is primary and foreign key.
- STAFF_ACTIVITIES: – STAFF_ID, ACTIVITY_DATE, ACTIVITY_TYPE, DESCRIPTION, REPORT_SUBMITTED, FUNDING_TYPE are attributes. Here STAFF_ID and ACTIVITY_DATE is primary key and STAFF_ID is foreign key.
- SUBJECTS: – SUBJECT_NO, SUBJECT_NAME are attributes. Here SUBJECT_NO is primary key.
- Employee Table
CREATE TABLE EMPLOYEE
(
EMPLOYEE_ID VARCHAR(10) NOT NULL,
TITLE VARCHAR(50) NOT NULL,
FIRST_NAME VARCHAR(50) NOT NULL,
MIDDLE_NAME VARCHAR(50) NOT NULL,
LAST_NAME VARCHAR(50) NOT NULL,
BIRTHDATE DATE NOT NULL,
STREETADDRESS VARCHAR(50) NOT NULL,
CITY VARCHAR(50) NOT NULL,
STATE VARCHAR(50) NOT NULL,
POSTAL_CODE INT(10) NOT NULL,
PHONE VARCHAR(20) NOT NULL,
MOBILE VARCHAR(20) NOT NULL,
DATE_HIRED DATE NOT NULL,
DATE_TERMINATED DATE,
TFN VARCHAR(20),
DEPARTMENT VARCHAR(50) NOT NULL,
LOCATION VARCHAR(100) NOT NULL,
PRIMARY KEY (EMPLOYEE_ID)
)
;
Education Table
CREATE TABLE EDUCATION
(
EMPLOYEE_ID VARCHAR(10) NOT NULL,
HIGHEST_EDUCATION_ATTAINMENT VARCHAR(100) NOT NULL,
QUALIFICATION VARCHAR(255) NOT NULL,
YEAR_COMPLETED YEAR NOT NULL,
SCHOOL VARCHAR(100) NOT NULL,
PRIMARY KEY (EMPLOYEE_ID),
FOREIGN KEY (EMPLOYEE_ID) REFERENCES EMPLOYEE(EMPLOYEE_ID)
)
;
Background Table
CREATE TABLE BACKGROUND
(
EMPLOYEE_ID VARCHAR(10) NOT NULL,
YEAR_STARTED_WORKING YEAR NOT NULL,
YEAR_FINISHED_WORKING YEAR,
EMP_POSITION VARCHAR(100) NOT NULL,
ORGANIZATION_NAME VARCHAR(100) NOT NULL,
LOCATION VARCHAR(100) NOT NULL,
PRIMARY KEY (EMPLOYEE_ID),
FOREIGN KEY (EMPLOYEE_ID) REFERENCES EMPLOYEE(EMPLOYEE_ID)
)
;
Staff Table
CREATE TABLE STAFF
(
STAFF_ID VARCHAR(10) NOT NULL,
EMPLOYEE_ID VARCHAR(10) NOT NULL,
SATFF_STATUS VARCHAR(100) NOT NULL,
PRIMARY KEY (STAFF_ID),
FOREIGN KEY (EMPLOYEE_ID) REFERENCES EMPLOYEE(EMPLOYEE_ID)
)
;
Teaching_Staff Table
CREATE TABLE TEACHING_STAFF
(
STAFF_ID VARCHAR(10) NOT NULL,
LOCATION VARCHAR(100) NOT NULL,
CONTACT_DETAIL VARCHAR(20) NOT NULL,
PRIMARY KEY (STAFF_ID),
FOREIGN KEY (STAFF_ID) REFERENCES STAFF(STAFF_ID)
)
;
Administrative_Staff Table
CREATE TABLE ADMINISTRATIVE_STAFF
(
STAFF_ID VARCHAR(10) NOT NULL,
ASTAFF_POSITION VARCHAR(50) NOT NULL,
PRIMARY KEY (STAFF_ID),
FOREIGN KEY (STAFF_ID) REFERENCES STAFF(STAFF_ID)
)
;
Subjects Table
CREATE TABLE SUBJECTS
(
SUBJECT_NO VARCHAR(10) NOT NULL,
SUBJECT_NAME VARCHAR(100) NOT NULL,
PRIMARY KEY (SUBJECT_NO)
)
;
Staff_Timesheet Table
CREATE TABLE STAFF_TIMESTAFF
(
STAFF_ID VARCHAR(10) NOT NULL,
SUBJECT_NO VARCHAR(10) NOT NULL,
HOURSE_WORKED_PERWEEK DOUBLE NOT NULL,
TYPE_OF_WORK VARCHAR(100) NOT NULL,
HOURLY_RATE DOUBLE NOT NULL,
NO_OF_STUDENT INT NOT NULL,
PRIMARY KEY (STAFF_ID),
FOREIGN KEY (STAFF_ID) REFERENCES TEACHING_STAFF(STAFF_ID),
FOREIGN KEY (SUBJECT_NO) REFERENCES SUBJECTS(SUBJECT_NO)
)
;
Date_Leave_Absence Table
CREATE TABLE DATE_LEAVE_ABSENCE
(
STAFF_ID VARCHAR(10) NOT NULL,
DATE_OF_LA DATE NOT NULL,
TYPE_OF_LEAVE VARCHAR(10) NOT NULL,
PAID_OR_NOTPAID_LEAVE VARCHAR(10) NOT NULL,
LA_STATUS VARCHAR(100) NOT NULL,
PRIMARY KEY ( STAFF_ID, DATE_OF_LA),
Challenges of Maintaining Employee Information with Spreadsheets
FOREIGN KEY (STAFF_ID) REFERENCES STAFF(STAFF_ID)
)
;
Leave_Absenec Table
CREATE TABLE LEAVE_ABSENCE
(
STAFF_ID VARCHAR(10) NOT NULL,
NO_OF_LEAVE_ALLOWED INT NOT NULL,
NO_OF_SICKLEAVE_ALLOWED INT NOT NULL,
REMAINING_LEAVE INT NOT NULL,
REMAINING_SICK_LEAVE INT NOT NULL,
PRIMARY KEY (STAFF_ID),
FOREIGN KEY (STAFF_ID) REFERENCES STAFF(STAFF_ID)
)
;
Staff_Activities Table
CREATE TABLE STAFF_ACTIVITIES
(
STAFF_ID VARCHAR(10) NOT NULL,
ACTIVITY_DATE DATE NOT NULL,
ACTIVITY_TYPE VARCHAR(100) NOT NULL,
DESCRIPTION VARCHAR(255),
REPORT_SUBMITTED VARCHAR(255),
FUNDING_TYPE VARCHAR(100),
PRIMARY KEY (STAFF_ID, ACTIVITY_DATE),
FOREIGN KEY (STAFF_ID) REFERENCES STAFF(STAFF_ID)
)
;
Insert Data Into Mysql Database Tables: –
1. Employee Table Data
INSERT INTO EMPLOYEE VALUES(‘E101’, ‘ABC’, ‘ROBIN’, ‘JAENE’, ‘MAAN’, ‘194-10-02’, ‘AB101’, ‘US’, ‘US’, 1234,’34565456546′, ‘87678987’,’2012-10-02′,’2018-10-02′ ,’ertd’ ,’CS’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E102’, ‘ABC’, ‘JAKEN’, ‘JANNI’, ‘BOONI’, ‘194-10-03’, ‘AB102’, ‘US’, ‘US’, 1234,’3456509899′, ‘9777987’,’2012-10-03′,’2018-10-02′ ,’ertd’ ,’B.COM’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E103’, ‘ABC’, ‘CANDID’, ‘JANIE’, ‘MAAN’, ‘194-10-04’, ‘AB103’, ‘US’, ‘US’, 1234,’34568989990′, ‘36768987’,’2012-10-04′,’2018-10-02′ ,’ertd’ ,’BA’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E104’, ‘ABC’, ‘COBOL’, ‘CAAN’, ‘JNICA’, ‘194-10-05’, ‘AB104’, ‘US’, ‘US’, 1234,’86788996546′, ‘87677697’,’2012-10-05′,’2018-10-02′ ,’ertd’ ,’BSC’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E105’, ‘ABC’, ‘MANIK’, ‘RAAN’, ‘JANIA’, ‘194-10-06’, ‘AB105’, ‘US’, ‘US’, 1234,’657586856546′, ‘87676908’,’2012-10-06′,’2018-10-02′ ,’ertd’ ,’MSC’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E106’, ‘ABC’, ‘JAINE’, ‘CAAN’, ‘CAAN’, ‘194-10-07’, ‘AB106’, ‘US’, ‘US’, 1234,’345868688746′, ‘87608786’,’2012-10-07′,’2018-10-02′ ,’ertd’ ,’CS’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E107’, ‘ABC’, ‘ROHIN’, ‘JAENE’, ‘MAAN’, ‘194-10-08’, ‘AB107’, ‘US’, ‘US’, 1234,’3414346546′, ‘87677689’,’2012-10-08′,’2018-10-02′ ,’ertd’ ,’CS’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E108’, ‘ABC’, ‘RONANI’, ‘JAENE’, ‘BOONI’, ‘194-10-09’, ‘AB108’, ‘US’, ‘US’, 1234,’34565487998′, ‘87623456’,’2012-10-09′,’2018-10-02′ ,’ertd’ ,’BA’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E109’, ‘ABC’, ‘MISCAN’, ‘MANI’, ‘MAAN’, ‘194-10-10’, ‘AB109’, ‘US’, ‘US’, 1234,’34516759846′, ‘876876554’,’2012-10-10′,’2018-10-02′ ,’ertd’ ,’B.COM’,’US’);
INSERT INTO EMPLOYEE VALUES(‘E110’, ‘ABC’, ‘BRNJIC’, ‘JAENE’, ‘CAAN’, ‘194-10-11’, ‘AB110’, ‘US’, ‘US’, 1234,’97766556546′, ‘876234567’,’2012-10-02′,’2018-10-02′ ,’ertd’ ,’CS’,’US’);
2. Education Table-
INSERT INTO EDUCATION VALUES(‘E101′,’MCA’,’MCA’,1992,’ABC’);
INSERT INTO EDUCATION VALUES(‘E102′,’M.COM’,’M.COM’,1993,’ABCD’);
INSERT INTO EDUCATION VALUES(‘E103′,’MBA’,’MBA’,1994,’ABCIF’);
INSERT INTO EDUCATION VALUES(‘E104′,’MCA’,’MCA’,1991,’ABCWE’);
INSERT INTO EDUCATION VALUES(‘E105′,’MCA’,’MCA’,1993,’ABCTYF’);
INSERT INTO EDUCATION VALUES(‘E106′,’MA’,’MA’,1992,’ABCPO’);
INSERT INTO EDUCATION VALUES(‘E107′,’M.COM’,’M.COM’,1992,’ABCBN’);
INSERT INTO EDUCATION VALUES(‘E108′,’MCA’,’MCA’,1995,’ABCAS’);
INSERT INTO EDUCATION VALUES(‘E109′,’MA’,’MA’,1993,’ABCUY’);
INSERT INTO EDUCATION VALUES(‘E110′,’MCA’,’MCA’,1994,’ABCBV’);
3. Background Table-
INSERT INTO BACKGROUND VALUES(‘E101′,2012,2030,’SATFF’,’CS’,’US’);
INSERT INTO BACKGROUND VALUES(‘E102′,2012,2030,’SATFF’,’B.COM’,’US’);
INSERT INTO BACKGROUND VALUES(‘E103′,2012,2030,’SATFF’,’BA’,’US’);
INSERT INTO BACKGROUND VALUES(‘E104′,2012,2030,’SATFF’,’BCA’,’US’);
INSERT INTO BACKGROUND VALUES(‘E105′,2012,2030,’SATFF’,’MA’,’US’);
INSERT INTO BACKGROUND VALUES(‘E106′,2012,2030,’SATFF’,’M.COM’,’US’);
INSERT INTO BACKGROUND VALUES(‘E107′,2012,2030,’SATFF’,’BA’,’US’);
INSERT INTO BACKGROUND VALUES(‘E108′,2012,2030,’SATFF’,’CS’,’US’);
INSERT INTO BACKGROUND VALUES(‘E109′,2012,2030,’SATFF’,’CS’,’US’);
INSERT INTO BACKGROUND VALUES(‘E110′,2012,2030,’SATFF’,’BSC’,’US’);
4. Staff Table-
INSERT INTO STAFF VALUES (‘S101′,’E101′,’FULL TIME’);
INSERT INTO STAFF VALUES (‘S102′,’E102′,’FULL TIME’);
INSERT INTO STAFF VALUES (‘S103′,’E103′,’FULL TIME’);
INSERT INTO STAFF VALUES (‘S104′,’E104′,’FULL TIME’);
INSERT INTO STAFF VALUES (‘S105′,’E105′,’FULL TIME’);
INSERT INTO STAFF VALUES (‘S106′,’E106′,’FULL TIME’);
INSERT INTO STAFF VALUES (‘S107′,’E107′,’PART TIME’);
INSERT INTO STAFF VALUES (‘S108′,’E108′,’PART TIME’);
INSERT INTO STAFF VALUES (‘S109′,’E109′,’PART TIME’);
INSERT INTO STAFF VALUES (‘S110′,’E110′,’PART TIME’);
AusEd’s Goal: Enabling Students to ‘Be What They Want to Be’
5. Teaching_Staff Table-
INSERT INTO TEACHING_STAFF VALUES(‘S101’, ‘US’, ‘78656788689’);
INSERT INTO TEACHING_STAFF VALUES(‘S102’, ‘US’, ‘45868798986’);
INSERT INTO TEACHING_STAFF VALUES(‘S103’, ‘US’, ‘34656789899’);
INSERT INTO TEACHING_STAFF VALUES(‘S104’, ‘US’, ‘57668798000’);
INSERT INTO TEACHING_STAFF VALUES(‘S105’, ‘US’, ‘43678798090’);
INSERT INTO TEACHING_STAFF VALUES(‘S106’, ‘US’, ‘47657670989’);
INSERT INTO TEACHING_STAFF VALUES(‘S107’, ‘US’, ‘08766565443’);
INSERT INTO TEACHING_STAFF VALUES(‘S108’, ‘US’, ‘12435687899’);
INSERT INTO TEACHING_STAFF VALUES(‘S109’, ‘US’, ‘54668798980’);
INSERT INTO TEACHING_STAFF VALUES(‘S110’, ‘US’, ‘96643446576’);
6. Administrative_Staff Table-
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S101’, ‘ADMIN’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S102’, ‘ADMIN OF BCA’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S103’, ‘ADMIN OF CS’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S104’, ‘ADMIN OF BA’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S105’, ‘ADMIN OF MA’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S106’, ‘ADMIN OF BBA’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S107’, ‘ADMIN OF MBA’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S108’, ‘ADMIN OF B.COM’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S109’, ‘ADMIN OF M.COM’);
INSERT INTO ADMINISTRATIVE_STAFF VALUES (‘S110’, ‘ADMIN OF IT’);
7. Subjects Table-
INSERT INTO SUBJECTS VALUES(‘SB101′,’C’);
INSERT INTO SUBJECTS VALUES(‘SB102′,’C++’);
INSERT INTO SUBJECTS VALUES(‘SB103′,’JAVA’);
INSERT INTO SUBJECTS VALUES(‘SB104′,’HTML’);
INSERT INTO SUBJECTS VALUES(‘SB105′,’MYSQL’);
INSERT INTO SUBJECTS VALUES(‘SB106′,’VISIO’);
INSERT INTO SUBJECTS VALUES(‘SB107′,’CSS’);
INSERT INTO SUBJECTS VALUES(‘SB108′,’ORACEL’);
INSERT INTO SUBJECTS VALUES(‘SB109′,’DIGITAL’);
INSERT INTO SUBJECTS VALUES(‘SB110′,’SYSTEM ANALYSIS’);
8. Staff_Timestaff Table-
INSERT INTO STAFF_TIMESTAFF VALUES(‘S101′,’SB101′,5,’sessional’,12.2,30);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S102′,’SB102′,4,’sessional’,14.2,31);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S103′,’SB103′,5,’sessional’,11.2,32);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S104′,’SB104′,6,’sessional’,12.2,33);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S105′,’SB105′,7,’sessional’,13.2,34);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S106′,’SB106′,2,’sessional’,14.2,35);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S107′,’SB107′,5,’sessional’,15.2,36);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S108′,’SB108′,1,’sessional’,12.2,37);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S109′,’SB109′,2,’sessional’,11.2,37);
INSERT INTO STAFF_TIMESTAFF VALUES(‘S110′,’SB110′,3,’sessional’,12.2,30);
9. Date_Leave_Absence Table-
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S101′,’2018-12-01′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S102′,’2018-12-04′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S103′,’2018-12-06′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S104′,’2018-12-08′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S105′,’2018-12-10′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S106′,’2018-12-17′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S107′,’2018-12-18′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S108′,’2018-12-19′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S109′,’2018-12-22′,’SICK’,’NOTPAID’,’ACTIVE’);
INSERT INTO DATE_LEAVE_ABSENCE VALUES(‘S110′,’2018-12-23′,’SICK’,’NOTPAID’,’ACTIVE’);
10. Leave_Absence Table-
INSERT INTO LEAVE_ABSENCE VALUES(‘S101’,4,4,2,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S102’,4,4,1,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S103’,4,4,2,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S104’,4,4,1,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S105’,4,4,2,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S106’,4,4,1,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S107’,4,4,2,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S108’,4,4,1,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S109’,4,4,2,2);
INSERT INTO LEAVE_ABSENCE VALUES(‘S110’,4,4,1,2);
11. Staff_Activities Table-
INSERT INTO STAFF_ACTIVITIES VALUES(‘S101′,’2018-5-20′,’MATCH’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S102′,’2018-5-10′,’PARTY’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S103′,’2018-5-20′,’MATCH’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S104′,’2018-5-02′,’MATCH’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S105′,’2018-5-21′,’MATCH-FOOTBALL’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S106′,’2018-5-22′,’MATCH’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S107′,’2018-5-23′,’PARTY’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S108′,’2018-5-24′,’PAINTING’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S109′,’2018-5-25′,’MATCH’,’IKKL’,’YES’,’ALL’);
INSERT INTO STAFF_ACTIVITIES VALUES(‘S110′,’2018-5-26′,’MATCH’,’IKKL’,’YES’,’ALL’);
References: –
Chia, K., Seow, E. and Teo, K. (2004). Database. Singapore: Pearson Prentice Hall.
DuBois, P. (1999). MySQL. Indianapolis, IN: New Riders.
DuBois, P. (2009). MySQL. Upper Saddle River, NJ: Addison-Wesley.
Eliot, G. (2016). The mill on the Floss. New York: Open Road Integrated Media.
Elmasri, R. and Navathe, S. (2017). Fundamentals of database systems. 1272 Seiten: [Verlag nicht ermittelbar].
Kambayashi, Y. (1981). Database. Berlin: Springer.
Knottingham, E. (2001). How to do everything with Microsoft Visio 2002. Berkeley, Calif.: Osborne/McGraw-Hill.
Kofler, M. (2001). MySQL. Berkeley, CA: Apress.
MacWhinney, B. (2000). The database. Mahwah, NJ [u.a.]: Lawrence Erlbaum.
Munnelly, B. and Holden, P. (2002). ECDL3 for Microsoft Office 95/97. London: Prentice Hall.
O’Neil, P. (2014). Database. Elsevier Science.
Parker, D. (2007). Visualizing information with Microsoft Office Visio 2007. New York: McGraw Hill.
Walker, M. and Eaton, N. (2004). Microsoft Office Visio 2003 inside out. Redmond, Wash.: Microsoft Press.
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
