database design lab we need a database for the bus service to the local public school district. our...
TRANSCRIPT
DATABASE DESIGN LAB
We need a database for the bus service to the local public school district.
Our bus drivers drive a bus on a morning route to pick up students up at
each address and take them to school. In the afternoon drivers drive a
route that takes students from the school to their homes. We need to
keep track of the routes each driver drives and who is on those routes.
Session 3
Bus
Route
StudentAddress
Driver
Schoollives attends
belongs services
assigned
assigned
DATABASE DESIGN LABSession 4
We need a database for the bus service to the local public school district.
Our bus drivers drive a bus on a morning route to pick up students up at
each address and take them to school. In the afternoon drivers drive a
route that takes students from the school to their homes. We need to
keep track of the routes each driver drives and who is on those routes.
Each driver is assigned to only one route.
Each driver is usually assigned to only one bus, but might have to use a different one if it is broken.
Question: Do you need to know which driver drove which bus on each route for each day?
Bus
Route
StudentAddress
Driver
Schoollives attends
belongs services
assigned
assigned
DailyDrive
belongs
belongs belongs
DATABASE DESIGN LABSession 4
Work with your group on the exercise files in the lab section for session 4 on the course website:
http://info.slis.indiana.edu/~dingying/S511Spring2013.html
DATABASE DESIGN LAB
VMware Fusion
1. Open from the application menu.
2. Open Finder from the application menu.
3. Under the Go menu at the top select Go to Folder
4. In the box type the path /var/slis/Win7
5. Double click the VMware Icon
6. Click I copied it when prompted
7. Select the Slis user icon
8. Enter password is slizzard! when prompted
If you haven’t already accessed in the last session!
VMware Fusion
If you did access it last session, use only steps 5-8 to access it now.