12 Jun Database
Database Concepts
Assignment 2
Due date: Monday 20 May 2019, 23:59
Value:
Part A 10% draw the ER diagram
Part B (20%) 10% map the ER diagram to 3NF
10% and Normalisation
Part A: Draw the ER diagram
Identify the business situation that you wish to design a database for. The situation needs to be a real life one (not an imaginary company for example) and ideally be something you are interested in or familiar with. Topics might include hobbies (cricket teams, online games), associations (hockey clubs, childcare centre), work-related concerns (fishing boats, student enrolments, art gallery) or other interests (Star Wars).
Try to pick an application that is relatively substantial, but not too enormous. If you decide to choose your own business situation youwill need to discuss with your lecturer if it is appropriate.
If you are unable to come up with your own you have the option of choosing from a list of cases. No group can choose the same case, unless there is sufficient difference in the case (Remember it will need to be based on a real practical situation).
For example, when expressed in the ER diagram, you might want your design to have a range of entities (more than 4), and a similar number of relationships.
You should certainly include different kinds of relationships (many-one, many-many) and different kinds of data (Alphanumeric, Numbers, etc.), as well as attribute types.
Please hand in the following:
· Describe the situation. Your description should be brief and relatively informal (maximum length 1 A4 page). If there are any unique or particularly difficult aspects of your proposed application, please point them out. Your description will be marked only on suitability and conciseness
· Include a list of business rules (can make assumptions as long as it is logical)
· Draw an ER diagram for your proposed database. You need to show attributes, primary keys, and relationships (needs to use Chen and Crows feet notation)
Part B: Map the ER diagram to 3NF &Normalisation
Map the ER diagram to 3NF
· Translate your ER Diagram into a schema of normalised tables. These must be in at least 3rd Normal Form (database schema)
Normalisation
Use a flat structure table include all attributes:
· Determine functional dependencies
· Use 3nf to develop the relations, show as
o Text notation
List of choices
1. Fast food outlet – food ordering
2. Gym trainer – managing clients – exercise routines
3. Enrolment system
4. IT LOGIT system
5. Taxi system – recording car and journey of a passenger
6. Childcare centre
7. Sport club – tracking teams
8. Investment – tracking buy and selling shares and investments
9. Real estate
10. Hotel
11. Hospital management system database project
12. Health care organization database project
13. Restaurant management database project
14. Art gallery management database project
15. School behaviour management project
16. Construction project
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.