Dormitory Database Design
BOGAZICI UNIVERSITY MANAGEMENT INFORMATION SYSTEMS
Dormitory Database
By
Serpil Erdoğan and Barış Çimen
May,24,2011
For: Assistant Professor Sona Mardikyan
MIS132:Introduction to Database
English
Table of Contents
Page
Introduction..............................................................................................................................4
1.General View of the Database.................................................................................................4
1.1. Aim of the Database
1.2. View of the Dormitory
2.Tables......................................................................................................................................5
2.1. House 2.2. House Staff 2.3.Payment Types 2.4.Room 2.5.Room Service 2.6.Salary 2.7.Service 2.8.Staff 2.9.Student
3.Queries.....................................................................................................................................5
3.1.Age Student 3.2.Alphabetical List of Students
2.3.CrossTab City Order
2.4.Delete a Student
2.5.Parameter Query
2.6.Quarterly Student Birth
2.7.Room with Price
2.8.Select Query
2.9.Service and Staff Salary
2.10.Service Type
2.11.Student According to city
2.12.Ten Oldest Students
2.13.Update Payment for Rooms
2.14.Update Salary Ten Percent
4.Forms...................................................................................................................................7 4.1.Salary Chart
4.2.Room Service
4.3.Staff Information
4.4. Student
4.5.Tabular Student Information
SubForms:
4.6.RoomService subform
4.7.HouseStaff subform
4.8. Service subform
4.9. Student subform
Introduction
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically
Dormitory Database
By
Serpil Erdoğan and Barış Çimen
May,24,2011
For: Assistant Professor Sona Mardikyan
MIS132:Introduction to Database
English
Table of Contents
Page
Introduction..............................................................................................................................4
1.General View of the Database.................................................................................................4
1.1. Aim of the Database
1.2. View of the Dormitory
2.Tables......................................................................................................................................5
2.1. House 2.2. House Staff 2.3.Payment Types 2.4.Room 2.5.Room Service 2.6.Salary 2.7.Service 2.8.Staff 2.9.Student
3.Queries.....................................................................................................................................5
3.1.Age Student 3.2.Alphabetical List of Students
2.3.CrossTab City Order
2.4.Delete a Student
2.5.Parameter Query
2.6.Quarterly Student Birth
2.7.Room with Price
2.8.Select Query
2.9.Service and Staff Salary
2.10.Service Type
2.11.Student According to city
2.12.Ten Oldest Students
2.13.Update Payment for Rooms
2.14.Update Salary Ten Percent
4.Forms...................................................................................................................................7 4.1.Salary Chart
4.2.Room Service
4.3.Staff Information
4.4. Student
4.5.Tabular Student Information
SubForms:
4.6.RoomService subform
4.7.HouseStaff subform
4.8. Service subform
4.9. Student subform
Introduction
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically