Subject Code & Title : CSE2DCX Relational Model And ER Diagrams
Assignment Type: Individual Assignment
Objectives :
This is an individual assignment. Students are not permitted to work in a group when writing this assignment.
CSE2DCX Relational Model And ER Diagrams Assessment 1 – La Trobe University Australia.
Copying and Plagiarism :
This is an individual assignment. Students are not permitted to work in a group when writing this assignment. Plagiarism is the submission of another person’s work in a manner that gives the impression that the work is their own. La Trobe University treats plagiarism seriously. When detected,penalties are strictly imposed.
Submission Guidelines:
Your assignment submission should be typed, not written/drawn by hand.
Submit the electronic copy of your assignment through the subject LMS.
Submission after the deadline will incur a penalty of 5% of the available assignment mark per day capped at 5 days. No assignment will be accepted after 5 days. If you have encountered difficulties that lead to late submission or no submission, you should apply for special consideration.
Background:
For years ABC Vocational School has depended on their manual information recording procedures to store information about their students, teachers and courses. The school maintains these different types of information in separate paper-based files.
This manual procedure is quite difficult to handle and maintain, especially in the instances where retrieval of data or a search for information is required. As you can imagine, retrieving a required record from a
massive file is both difficult and time consuming. Apart from these problems storing many paper-based files requires significant storage space.
To overcome these problems ABC Vocational School has decided to take advantage of technology available today to create an application that will allow them to perform these functions in a more efficient manner.
The school has decided to handover the design of the database of this project to an Information Technology student, you! Below is a description of the data needed and how it interrelates. You are expected to model
this information via an ER / EER diagram and map it to relations.
The database will need to model information about three different types of people that the application will be concerned with: students, teachers, and administrators. Each person will have some common information recorded against them, including their ID, first name, last name, date of birth, phone, address 1, address 2, suburb, postcode, and type (which can be “student”, “teacher”, or “administrator”).
In addition to the general information above, these types of people have some additional information that pertains themselves only. For students, the qualification code and start date will be stored. For teachers,their registration number and password will be stored. For administrators, the role and password will be stored.
Students can enroll in a qualification. Each qualification has qualification code, name, and duration. As examples only, qualifications might be the “Diploma of Website Development” or the “Diploma of Software Development”. Note that a student may only enroll in one qualification and the qualification can have any number of students.
Each qualification has courses mapped to it. The course information comprises of the course ID, name, year, semester, and the teacher responsible. In addition, each course can be mapped in any number of
qualifications. For example, the “Diploma of Website Development” might include in part “Programming in HTML” and “Programming in Java”, whilst the “Diploma of Software Development” might include in part“Data Structures” and “Programming in Java”. Each course only has one teacher and a teacher can teach any number of courses.
CSE2DCX Relational Model And ER Diagrams Assessment 1-La Trobe University Australia.
Students will be enrolled in their courses to complete their qualification. Students will therefore be enrolled in multiple courses and each course will have any number of enrollments. Each enrollment record will also record the mark that was obtained.
Task 1:
Draw an ER/EER diagram for the above-mentioned database in Microsoft Visio 2016 using Crow’s Foot Database Notation.
For each entity:
1.Give the entity an appropriate name.
2.Include all attributes. Be aware that not all primary keys and/or foreign keys may have been explicitly mentioned in the problem statement above. It is your job to add these as necessary for a correct solution.
3.Annotate the primary key attribute(s) as
4.Annotate the foreign key attribute(s) as
For each relationship:
5.Annotate the cardinality at each end as “zero or more”, “one or more”, “one and only one”, or “zero or one” (“Database Systems”, Coronel and Morris, 2017, p. 132).
6.Use an arrow to represent any inheritance relationship(s).
7.Add a label to each relationship. For example, if you wanted to model the relationship between a Supplier and a Product in an inventory database, you could use the annotation “provide” to say that suppliers “provide” products.
Task 2
In this task, you will create a relational model for the above-mentioned database.
1.Map the above diagram from Task 1 to a relational model for all relations in Microsoft Word. For example, for a product relation, Product(Product ID, Product Name, Price, Supplier ID), the primary key attribute(s) are in underline, the foreign key attribute(s) are in italics, and both styles would need to be applied if an attribute is both primary and foreign.
2.You must also check that your solutions for Tasks 1 and 2 are compatible with each other. Update your solution(s) as necessary.
CSE2DCX Relational Model And ER Diagrams Assessment 1-La Trobe University Australia.
Submitting your Assignment
When you have completed your answers, submit the assessment on the LMS system. You should submit the following:
• Submit your Task 1 answers in a drawing called xxx_cse 2 dcx_ assessment 1. vsdx (where xxx is your student number).
• Submit your Task 2 answers in a document called xxx_cse 2 dcx_assessment 1. docx (where xxx is your student number).
Excellent Assignment Help
We Aim At:
- Lowest Price.
- 100% Uniqueness.
- Assignment Fastest Delivery.