190 likes | 538 Views
Database system for kindergarten and nursery. kindergarten and nursery Database. Be composed of staff members, each of whom is registered the name, ID number, mobile number, day of birth, Degrees, on employment, the type of job, and salary. kindergarten and nursery Database.
E N D
kindergarten and nursery Database Be composed of staff members, each of whom is registered the name, ID number, mobile number, day of birth, Degrees, on employment, the type of job, and salary.
kindergarten and nursery Database When the children enrolled are recorded as follows name, identification number of the parent, and guardian's mobile number, day of birth, sex, diseases that affect them, day of registration, examination and are selected on the basis of its share. And each child affairs supervisor for reference in times of need or the occurrence of child health problems or study, and also has several teachers materials they use, each with the name, number, and degree. It can be employed to register them with the sons of the rest of the children and have them deducted according to the Center its affiliates.
Initial design of entity type: Employee e. salary e.id e. name e. Type of employ EMPLOYEE e. phone e.Date of employ e. Birth day e. certificate
Initial design of entity type: CHILd c. parent id c. name c. installment c. Parent phone CHILD c. Birth day e. Date of enrolment c. sex c. Study c. disease
Initial design of entity type: course Co. number COURSE Co. name
Relationships between entity M EMPLOYE 1 degree 1 supervisor teach has N COURSE N CHILD N
Schema Diagram for the relation database schema: Employee child course
Erto relation mapping Employee child supervisor
Erto relation mapping (2) Employee child has
Erto relation mapping (3) Employee child course teach
Create table Employee (e_id char(10) primary key, e_name varchar2(100), e_phone char(20), e_birth_day number(20), e_certificate char(50), e_date_of_employ char(10), e_type_of_employ char(10), e_salary number(10)); Sql code (1)
Create table Child (c_parent_id char(10), c_namevarchar2 (100), primary key(c_parent_id,c_name), c_parent_phone char(20), c_birth_day number(10), c_sex char(6), c_diseasevarchar2 (50), c_studyvarchar2 (50), c_date_of_enrolment char(20)); Sql code (2)
Create table Course (co_number char(10) primary key, co_namevarchar2 (100)); Sql code (3) • Create table Supervisor (e_id char(10), c_parent_id char(10), c_namevarchar2 (100), primary key(e_id, c_parent_id, c_name), foreign key(e_id) references Employee on delete cascade, foreign key(c_parent_id, c_name) references Child on delete cascade);
Sql code (4) • Create table Has (e_id char(10), c_parent_id char(10), c_namevarchar2 (100), primary key(e_id, c_parent_id, c_name), foreign key(e_id) references Employee on delete cascade,foreign key(c_parent_id, c_name) references Child on delete cascade);
Sql code (5) • Create table Teach (degree number(10), e_id char(10), c_parent_id char(10), c_namevarchar2 (100), co_number char(10), primary key(e_id, c_parent_id, c_name, co_number), foreign key(e_id) references Employee on delete cascade,foreign key(c_parent_id, c_name) references Child on delete cascade, foreign key(co_number ) references Course on delete cascade);
Ala’a Jameel Ahmed. Amwaj Miayed Ajole. Fatimah Moussa Essa. Prepared by