Hogwarts
The Task
The distinguished Professor Dumbledore has asked me to assist in
designing a database to handle the school. I am respectfully passing his
request on to you. Build a database, including forms reports and
queries, to handle the H. School Management System, or HSMS in short,
described below. Remember all data are inserted, updated, deleted, and
retrieved only through these forms, reports, and queries. Hence, these
forms, reports, and queries, should handle all the work processes that
you think are needed.
HSMS will keep a record of all students, their name, address, telephone,
and parents. It should also keep track of the single pet each student
brings to school. Pets are only owls, cats, rats, or frogs. A pet must
be related to a student, have a name, species, gender, and special
powers. Special powers may be of many kinds.
Keep track of the professors, their name, address, telephone, and wizard
specialty. Also keep track of which classes each professor teaches and
the grades the professor gives each student per class and term.
The students are lodged in one of four houses, with a designated
professor in change of each house. But, since some professors, such as
Snape, have some problems standing some students, such as Harry, you
should keep track of that too.
A celebrated activity in the school is Quidditch, which is a witch game
of rugby played on brooms. Each of the four houses has its team. Keep
track what students play on what team and how many points they scored
each season. Also keep track what broom type each Quiddotch playing
student prefers. There are a limited number of broom types. There needs
to be at least 20 rows in each table and that all processes are
supported by forms and reports.
Deliverables:
1. ER diagram that supports the above case.
• Tables in 3NF
2. Working database that supports the above case.
• Tables matching the ER diagram
• Indexes
• Relationships in Relationship window
• Appropriate queries
• Forms, some must be with subforms and all must have buttons to open
related
forms and to print current form
• Reports
Computer Science Homework Solutions
#84494
Access Database & ER Diagram: Student database
The distinguished Professor Dumbledore has asked me to assist in designing a database to handle the school. I am respectfully passing his request on to you. Build a database, including forms reports and queries, to handle the H. School Management System, or HSMS in short, described below. Remember all data are inserted, updated, deleted, and retrieved only through these forms, reports, and queries. Hence, these forms, reports, and queries, should handle all the work processes that you think are needed.
HSMS will keep a record of all students, their name, address, telephone, and parents. It should also keep track of the single pet each student brings to school. Pets are only owls, cats, rats, or frogs. A pet must be related to a student, have a name, species, gender, and special powers. Special powers may be of many kinds.
Keep track of the professors, their name, address, telephone, and wizard specialty. Also keep track of which classes each professor teaches and the grades the professor gives each student per class and term.
The students are lodged in one of four houses, with a designated professor in change of each house. But, since some professors, such as Snape, have some problems standing some students, such as Harry, you should keep track of that too.
A celebrated activity in the school is Quidditch, which is a witch game of rugby played on brooms. Each of the four houses has its team. Keep track what students play on what team and how many points they scored each season. Also keep track what broom type each Quiddotch playing student prefers. There are a limited number of broom types. There needs to be at least 20 rows in each table and that all processes are supported by forms and reports.
Deliverables:
1. ER diagram that supports the above case.
• Tables in 3NF
2. Working database that supports the above case.
• Tables matching the ER diagram
• Indexes
• Relationships in Relationship window
• Appropriate queries
• Forms, some must be with subforms and all must have buttons to open related
forms and to print current form
• Reports
This posting contains a student's table in 3rd Normal form along with an ER diagram representing the relationships between various tables.
What is this?
By OTA - Overall OTA Rating
Neha Jain, ME - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$47.88)
Included in Download
- Plain text response
- Attached file(s):
- ERDIAGRAM.xls
- Student_db1.mdb
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- What problems does redundancy in a database cause? - What problems does redundancy in a database cause?
- Student Library system design - Electronic download for registered students. 1. Student visit library website. 2. Student search for downloadable resources. 3. Student input his student ID no. and date of birth. 4. Students su ...
- Database Concept - What is an ERD and why are they important for a database?
- Database Concept - Provide a real world example that demonstrates one of the normal forms.
- questions - Name two key points that data requirements must address and why? What might be some of the strategies used to define database requirements/ needs? How might data be managed to support a function ...
