Summer Camp
Transcript: List Of Users Cont. alter table joiner ADD FOREIGN KEY(SVno) REFERENCES supervisor(SVno) / alter table joiner ADD FOREIGN KEY(TentNO) REFERENCES Tent(TentNO) / ALTER TABLE JOINER MODIFY(TentNO NOT NULL) / alter table Joiner add constraint DepaartmentNo check( DepaartmentNo>=1 and DepaartmentNo<=4) / alter table Joiner modify (DOB DATE) / SELECT name_D, sum(monthlypayroll) as total_salary from department group by Name_D Easy control for inputs & outputs is the main goal behind this summer camp database. The database provides simplicity & efficiency by making it easy to control the different services that are provided by the camp such as registration procedures, tents & sleeping arrangements, nutrition and scientific & sport activities. It also facilitates controlling of camp members information and financial data such as camp fees and staff’s salaries. Insert Script File Physical Model Nada Yahya Saphia Osama Arwa Salem -Joiners - Campers - Employees - Coach - Instructor - Nurse - Accountant - Supervisor - Manager Mission Statement Queries Script File CREATE TABLE Joiner( Jssn NUMBER(10) NOT NULL PRIMARY KEY, SVno NUMBER(10), Fname VARCHAR2(8) NOT NULL, Lname VARCHAR2(8) NOT NULL, DOB NUMBER(10) NOT NULL, Sex VARCHAR2(1) NOT NULL, Educational_Degree VARCHAR2(25), ID NUMBER(7), DepaartmentNO NUMBER(1), TentNo NUMBER(2)) group by : select name_a, count(activityNo) as NumberOfCampers from activity group by name_a order by name_a desc E-R Diagram • The database will provide an organized way of keeping track of either employees or campers. • The database allows joiners (employees or campers) to fill or update their information in the registration form. • The database allows employees to insert or update their employment experience. • The database allows accountants in the financial department to insert, update and keep track of employee’s payroll information. • The database allows nurse in the medical care department to insert, update and keep track of their patient’s health information. • The database allows campers to insert what activities they are going to do. Summer Camp List Of Users Objectives / insert into joiner values(11111101,123111,'Sarah','Johns','10-feb-81','F','Master in Finance', 1111,1,1) insert into Supervisor values(123113,'manager') insert into Department values(3,'nutrition',null,2500) insert into tent values(5,1) insert into Activity values (1,'Math','Educational') insert into Joiner_Does values(1,00000001) insert into Joiner_Experience values (11111103,'5 ys nutrisionist') insert into JOINER_PAYMENT values(00000001,200) insert into Joiner_healthR values(00000003,'allergy') select jssn,fname,lname from joiner where jssn in ( select jssn from joiner_healthr where upper(health_records)='ALLERGY') Our database serves Summer Camps. You can register as an employee or a camper. Each one of them have its own limited access to it.It store the information about the campers,employees and the different activities and payrols in it. Aggregate Functions: Create Table Script File Objectives Cont. Nested Query: • The database allows instructors & coatches to specify, update and keep track of activities each camper is going to do. • The database allows managers and supervisors to arrange tents and sleeping arrangements by inserting, updating and keeping track of tents information. • The database allows managers and supervisors to keep track of joiner’s information. • The database allows managers to update joiner’s information. • The database allows managers and supervisors to keep track of each department in the summer camp. • The database allows managers to insert and update department’s information. • The database allows managers to insert and update supervisor’s information. Defining Our Project
Prezi Present
Prezi Video
Prezi Design
