You're about to create your best presentation ever

Free Summer Camp Powerpoint Template

Create your presentation by reusing a template from our community or transition your PowerPoint deck into a visually compelling Prezi presentation.

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

powerpoint template

Transcript: Nobody knows babies like we do! Quality products . Good Customer service. Every Kid really loves this store.. BABYLOU ABOUT US About Us BabyLou was established in 2004. It has been more than a decade since we started, where we have ensured to take care of every need and want of every child and infant under one roof, true to the caption “NO BODY KNOWS BABIES LIKE WE DO”. Our benchmark is to provide 100% customer service and satisfaction and continue to deliver the same with a wide range of toys, garments and Baby Products. Play and Create We Are Best 01 02 03 Block games Building Blocks help Kids to use their brain. PLAY TO LEARN in Crusing Adventures Our Discoveries Enjoy a sunny vacation aboard a luxury yacht with the LEGO® Creator 3in1 31083 Cruising Adventures set. This ship has all the comforts you need, including a well-equipped cabin and a toilet. Sail away to a sunny bay and take the cool water scooter to the beach. Build a sandcastle, enjoy a picnic, go surfing or check out the cute sea creatures before you head back to the yacht for a spot of fishing. Escape into the mountains Disney Little Princes in Also available for your Babies..... Also... Out of The World… Our reponsibility BABYLOU…. Our Responsibility All children have the right to fun, creative and engaging play experiences. Play is essential because when children play, they learn. As a provider of play experiences, we must ensure that our behaviour and actions are responsible towards all children and towards our stakeholders, society and the environment. We are committed to continue earning the trust our stakeholders place in us, and we are always inspired by children to be the best we can be. Innovate for children We aim to inspire children through our unique playful learning experiences and to play an active role in making a global difference on product safety while being dedicated promoters of responsibility towards children.

Now you can make any subject more engaging and memorable