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
Transcript: Welcome to Muskoka Woods Summer Camp! “Together, we will make a difference.” Valuable Information! Where? When? Who? Any children from the ages 7 to 15! What Muskoka Woods is About! Muskoka Woods is a summer came which is based on leadership. When you come to our came, we try and build and create thier leadership skills. In the camp, we include high rope corses which inprove thier leadership becasue for a task to be complete, there needs to be a leader. Our camp is full of fun and exciting activities and there is no way the can become sick of the activites because there are so many to choose from! Meals and Cabins Water Activities In Muskoka Woods we have plenty of water activities including swimming tubing and there are water parks in walking distance that is included with the camp. Activities Well I hope you guys have learned a lot from our slide and talking about camp Muskoka! I hope you take a second look at our camp when you are planning your summer. Hope to see you here! Thank you! July 17th to the 23rd Muskoka Woods! Canada, Ontario By: Brooke and Chelsea In Muskoka Woods theres lots of activities including tubing, swimming, campfires, high ropes and more!
Transcript: What do you your campers do for fun? Camp for Kids Create a place for kids to visit during the summer. What do the campers eat? BE CREATIVE!!! & HAVE FUN!!! Kid's World... Where do your campers sleep?
Transcript: Outline about life about life Intel-NTU creativity lab Intel-NTU creativity lab about research about life summarize about research Summer Trip Representor: Lin Xu Email: firstname.lastname@example.org opportunities favor the prepared mind delicious food Intel-NTU 4C Newly built M2M Four groups SIGCAM SIGARC SIGSSA SIGGSP http://ccc.ntu.edu.tw/ about research travel in Taipei concentration consideration action communication respect cooperation End summarize about life travel in Taipei about research about life summarize Intel-NTU creativity lab summarize Intel-NTU creativity lab about research about life about life Intel-NTU creativity lab about research summarize about research CAM-Context Analysis and Management Autonomous Reconfigurable Connectivity Green Sensing Platform Smart Service and Applications Intel-NTU creativity lab about life summarize
Transcript: Summer Camp at Jae-Hyun with Matt and Lee-Gyeonga In each class (if we have time) we will play improvisation games to get warmed up or cool down at the beginning or end of the lesson. Day 5 Goal: Make a movie in groups Make your movies! Day 6-10 Sports day Day 1-4 Day 1: Intro, Good and Evil Day 2: Clothing and Movement Day 3: Speech, Theme and Symbol Day 4: Movie Analysis Movie Analysis stage
Transcript: Activities Native professors Morning classes 15 days, 5 days a week, 4 hours a day Kayaking Rock climbing Swimming Fun games Summer Camp Spanish Classes Healthy food Seville Toledo Madrid Leon Oviedo People from all around the world
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.
Description: Storytelling is at the heart of great service. Use this stunning, customizable business presentation template to highlight employees who do exceptional work or position your customers as the heroes of your business.
Description: Catch the eye and engage the imagination with this cool-looking Prezi proposal template. The bold, bright design and highly dynamic theme all but guarantee success for your next sales or marketing proposal. All Prezi presentation templates are easily customized.
Description: Add some color to your quarterly business review with this vibrant business presentation template. The bold visuals in this business template will make your next QBR a memorable one.
Description: The sky’s the limit. Boost your new sales initiative into orbit with an engaging and compelling SKO presentation. This template features a effective sales kickoff theme that makes it easy to be engaging. Like all Prezi SKO templates, it’s fully customizable with your own information.
Now you can make any subject more engaging and memorable