IST210project - We go to different parks and organize a...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
We go to different parks and organize a database to best suit the customer. We put together a database so staff and students can view information easily. Right now we are working on The National Historical Park of Philadelphia.
Background image of page 2
This database is created for The National Historical Park of Philadelphia will: Allow people to choose their classes with ease Allow instructors to monitor their students Keep records of students and classes
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This park’s database will contain 6 tables A student table to keep track of students Student(ID, Fname, lname, sex, email, address, phonenumber) A course table to keep track of courses Course(ID, Course_desc, Course_name, Time, Section) A courseTaken table to keep track of which students are taking which classes Courses_Taken(COURSEID, STUDENTID )
Background image of page 4
A faculty table to keep track of instructors and staff members Faculty(id, fname, lname, sex, email, address, phone number A staff_in_courses to keep track of which staff is in which courses. staff_in_courses (STAFF_ID, COURSE_ID)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/18/2008 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Fall '08 term at Pennsylvania State University, University Park.

Page1 / 15

IST210project - We go to different parks and organize a...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online