Explain theoretical approaches used in database development

Assignment Help Database Management System

Reference no: EM133510673

Database Fundamentals

Learning Outcome 1: Explain the theoretical approaches used in database development and the issues related to data management in an enterprise
Learning Outcome 2: Explain the fundamentals of database languages, models and architecture
Learning Outcome 3: Apply relational modelling concepts and principles to design a database

Overview:
In this assignment, you are required to draw the ER diagram from the written specification and re-create a written specification from an ER diagram.

Activity 1: Draw an ER Diagram

Draw an Entity Relationship diagram (including connectivity and Cardinality) from the above description. State any assumptions or additional constraints you have used. Case Study The owner of Xpresstex (a laptop repair company) wants to keep track of the jobs related to the repair for the laptops they repair, the item utilized for the repair of each job, the labour cost associated for the repair of each job, the repairmen performing each repair job and the total cost associated with each repair job.

When customers bring their laptops in to be repaired, they make a deposit on the repair job and are given a date to return and uplift their laptops. Repairmen then perform repairs on the customers' laptops based on the repair job and detail the labour costs and the items used for each repair job.

When customers return, they pay the total cost of the repair job less the deposit, collect a receipt for their payment, and uplift the repaired laptop using this payment receipt.

Activity 2: Write Specification from ER Diagram

Write out the Business Rules for the following Entity-Relationship Diagram. You do not need to describe the attributes. Ensure you include all cardinalities & participation constraints. Identify weak/strong relationships.

1934_ER Diagram.png

Reference no: EM133510673

Questions Cloud

Culminating experience : In session B of the Culminating Experience, you will be diving into the methodology you would use if you were to conduct your research.

Presentation about healthy eating habits : A nurse is planning a presentation about healthy eating habits for participants at the community health fair.

Diagnosed with rare liver cancer : Seventy-nine-year old Mr. J has been diagnosed with rare liver cancer. The oncologist informs Mr. J that although he is willing to attempt round of chemotherapy

Discussion of the types of statistical tests : A detailed discussion of the types of statistical tests used and why they have been selected is thorough supported with strong rationale.

Explain theoretical approaches used in database development : ITDA1001 Database Fundamentals, Victorian Institute of Technology - Explain the theoretical approaches used in database development and the issues related

Health of aggregate group within community : Describe an example of how cultural factors influence the health of an aggregate group within the community

Opioid use disorder accessing methadone treatment : research questions in The Experience of Women with Opioid Use Disorder Accessing Methadone Treatment.

Nursing serves to transform nursing education : The Essentials of Master's Education in Nursing serves to transform nursing education and is critical to the innovations needed in health care.

Identify the terminology of philosophy : Since philosophy has its own terminology that can be foreign to education majors, this homework is designed to help you identify this terminology of philosophy.

User Account

All Pages