Reference no: EM13949971
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
|
Finding the optimal capital balance seems quite nebulous
: It seems clear that more debt leads to more risk, which is bad, but more debt also leads to higher expected returns, which is good. However, finding the optimal capital balance seems quite nebulous. Moreover, the textbook indicates that capital struc..
|
|
Why adding environmental perspective to balanced scorecard
: Explain why adding an environmental perspective to the Balanced Scorecard is considered to be legitimate. Express the environmental improvement strategy as a series of cause-and-effect relationships in the form of if-then statements.
|
|
Describe the distinguishing features of social policy
: Analyse the differences in formation and adaption of social policy initiatives from other national perspectives - Discuss the implementation of health and social care policy in different institutions in the United Kingdom.
|
|
Working database that supports the above case.
: 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.
|
|
Estimate the thermal efficiency and the refrigerant
: Cooling water is available at 208C. Specify the preliminary design of the cycle and estimate the thermal efficiency and the refrigerant and cooling water flow rates, in kg/h.
|
|
Evaluate the normalizing constant c
: Let f(x) be the uniform density on [0,1] and let g(x) be the density on [0,1] given by g(x)=ce^x, where c is the normalizing constant. Let F, and G be the corresponding CDFs. Find the density function corresponding to the new CDF H(x) = F(x)G(x).
|
|
Working fluid passing through the steam generator
: Water is the working fluid in an ideal Rankine cycle. Steam enters the turbine at 1400 lbf/in.2 and 10008F. The condenser pressure is 2 lbf/in.2 The net power output of the cycle is 1 3 109 Btu/h. Cooling water experiences a temperature increa..
|
|
The graduate examines fundamental concepts
: The body of scientific knowledge and understanding constantly undergoes change and refinement. Scientific discoveries and historical events have the capacity to alter our understanding of scientific concepts and the natural world.
|