What are the aspects of your proposed application

Reference no: EM132303179

Assignment: This assignment is to be done in groups of threes (two in a group is also acceptable) Note this is for Internals, Externals have this option also. Please submit both parts of the assignment together.

In this assignment you will identify a business situation and design a database for it. See List of choices.

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 you will 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 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

Reference no: EM132303179

Questions Cloud

How the mss supports establishing a competitive advantage : You have been hired by a small start-up manufacturing company, with less than 500 hundred employees that specializes in electronic devices.

What you think about all of the strange incidents : Your boss mentions that recently a number of employees have received calls from individuals who didn't identify themselves and asked a lot of questions about.

Define how would you apply the concepts you identified : Read at least three (3) academically reviewed articles on Management Information Systems and complete the following activities: Discuss at least 3 different.

Define strengths and weaknesses of managers versus leaders : Understanding the difference between leadership and management is an important skill for project managers. Write a two-page essay (not counting the references).

What are the aspects of your proposed application : HIT234 escribe the situation. Your description should be brief and relatively informal (maximum length 1 A4 page). If there are any unique or particularly.

Consider how mapping can be used in your own project : While each of you have very unique projects, consider how mapping can be used in your own project?

What is the objective of the paper : What is the objective of the paper and What rationale is given by the authors, attributing importance to the research problem

Describe the piece and reflect on the message : GWC SOC 100 INTRODUCTION TO SOCIOLOGY: If you could design one education policy that would fundamentally change public education, what would it be and why?

Define factors that determine the availability of a system : Measuring and analyzing software defects is critical for software and system development. Describe the relationship between defect detection and rolling-wave.

User Account

All Pages