Reference no: EM13950136
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
|
Two publicly-traded companies in same health care segment
: For the second part of the course project, you will perform a critical evaluation and comparison of two publicly-traded companies in the same health care segment. Your answer should apply the financial concepts and practices covered in this course to..
|
|
Managing human resources in health and social care
: Critically reflect and analyse the different approaches that can be used in the recruitment process at Silver Meadows Care Home - evaluate the different approaches that can be used to ensure the selection of the best individuals for work within Silv..
|
|
Which policy do you think has the largest deadweight losses
: When the government of Trade land decides to impose an import quota on foreign cars, three proposals are suggested: (1) Sell the import licenses in an auction. (2) Distribute the licenses randomly in a lottery. (3) Let people wait in line and dist..
|
|
Short article from the wall street journal
: Options traders were quick to take positions in Research In Motion Ltd. after the BlackBerry maker said fourth-quarter earnings were likely to come in at the lower end of projections. Early in the day, one trader backed out of a bullish "call spread"..
|
|
Working database that supports the tables
: 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.
|
|
What are the pros and cons of fiscal and monetary policy
: What are the roles of each and what are each responsible for obtaining? What are the responsibilities of each institution and what tools do they have at their disposable to impact the economy? Can you say that their objections are in tandem with o..
|
|
Calculate the annual return on the mutual funds
: Suppose an individual invests $38,000 in a load mutual fund for two years. The load fee entails an up-front commission charge of 4.2 percent of the amount invested and is deducted from the original funds invested. calculate the annual return on the m..
|
|
What is the net rate of return from this investment
: An investor purchases a mutual fund share for $100. The fund pays dividends of $7, distributes a capital gain of $8, and charges a fee of $6 when the fund is sold one year later for $101. What is the net rate of return from this investment?
|
|
Zero growth firm with an expected EBIT
: The Wallace Corporation is a zero growth firm with an expected EBIT of $800,000 on a permanent basis, and corporate tax rate of 40 percent. Wallace uses no debt, and the cost of equity to an unlevered firm in the same risk class is 12.0 percent. The ..
|