Semester 1, 2019 Database ConceptsHIT234 Assignment 2Due date: Friday 17 May 2019, 23:59Presentation: Internal students need to present the assignment in class in Week 11 Monday and outline the case, ERD and the normalisation that took place. Presentation is a maximum of 5 minutes, plus 2 minutes question time.Value: Part A 10% draw the ER diagram Part B (20%) 10% map the ER diagram to 3NF 10% and NormalisationSubmission details: For Internal and External students: submission is via Learnline. Instructions on how to submit the assignment is located under Assessments / Guidelines.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 & NormalisationMap 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)NormalisationUse a flat structure table include all attributes:· Determine functional dependencies· Use 3nf to develop the relations, show aso Text notationList of choices1. Fast food outlet – food ordering2. Gym trainer – managing clients – exercise routines3. Enrolment system4. IT LOGIT system5. Taxi system – recording car and journey of a passenger6. Childcare centre7. Sport club – tracking teams 8. Investment – tracking buy and selling shares and investments9. Real estate10. Hotel 11. Hospital management system database project12. Health care organization database project13. Restaurant management database project14. Art gallery management database project15. School behaviour management project16. Construction project
by Writers Nests | Nov 7, 2024 | category | 0 comments
Semester 1, 2019 Database ConceptsHIT234 Assignment 2Due date: Friday 17 May 2019, 23:59Presentation: Internal students need to…
A professional Academic Services Provider
Writings Hub champions Privacy, Timely Delivery, Professionalism, High-Quality
Writings Hub is the home of qualified professionals attending to customers’ needs. Our pool of experts cut across all fields including Medicine, Engineering, Architecture, Business, and Social sciences among others. We write proposals, dissertations, essay writing, term papers, and articles among others. The company always delivers quality papers that meet our clients’ expectations.Our Fundamental Ideals
1. Privacy: What we share with our customers is highly classified and is not shared with any other party.
2. Timely Delivery: We always deliver On-Time.
3. High-Quality We have adequate software and experts to deliver quality products, free of plagiarism and grammar errors. The papers are written from scratch as per the customers’ instructions.
Guarantees
4. Professionalism: We uphold the highest level of professionalism treating our clients with utmost respect. The papers are thoroughly assessed to ensure they meet the expected standards.
5. Money Back Policy: As a client-oriented service, we offer 100% refund for the following: if we received a double payment from you; if you placed similar orders twice (or more) and paid for all of them; the writer has not been assigned; you asked to cancel the order within 20 minutes after placing it; an e-Check payment has been sent (the Dispute Manager will contact you accordingly). Other cases involve a comprehensive investigation by the Dispute Department and feedback given within 24 hours. We value our customers; therefore, the process will be fair, fast, and precise.
5 .Free Revisions: Changes are done at no additional cost. However, this does not include complete change of the paper due to new instructions not specified in the original order and if it is not past ten days upon your approval.
6. 24/7 Customer Care: Our Support Team is always available for you.
Process of Placing an Order
NOTE: For any inquiries feel free to contact the Support Team before we start your project. ALL THE BEST”:
Recent Comments