Data Modelling in Data Governance and Management

Assignment Task

1. What am I required to do in this assignment?

You are required to

1) Model a use case using UML use case diagram for the school scenario below

2) Model the basic entity of your system by an Entity Relationship Diagram for the school scenario. You must identify minimum 2 actors - one for a pupil and one for a subject and link these two tables together using a suitable field

3) Convert your logical design (ERD) into a physical design by creating tables and insert some necessary records 4) Using some SQL query to demonstrate you can do the needed data access and information retravel.

Scenario

A local secondary school in Luton is looking to develop a new database system that stores details on pupils, staff, and the subjects that pupils take. The pupil can be identified by a unique student number, pupil should have first name, surname, address and postcode as property; The staff should have a unique staff number, first name, surname in the profile; the subject can be identified by a unique subject code, subject name and a cross-reference to the student ID who is taking that subject.

The basic function of the system should be able to answer question involves both pupils and subjects or pupils and staff, staff, pupils and the subjects.

2. What do I need to do to pass? (Threshold Expectations from UIF)

• You need to present your design process which applies to any data syst4em solution to a business organization.
• Exhibits the ability suing proper tools in each step of your syst4eme design.
• A Use Case Diagram with correct graphical presentation syntax to show the core function of the system, the necessary actions the system needs to perform to utilize the functions.
• An Entity Relationship Diagram to shows your conceptual and logical design for your system
• A physical design (implementation of your logical design) for example, if you use relational database, it should be the tables with relevant columns
• 2 or three queries to the database to demonstrate that your system can perform the functions you identified at the beginning of your design.

3. How do I produce high quality work that merits a good grade?

4. You should clearly explain the rationale behind each of your design decisions and what are the options for each step.

5. How does this assignment relate to what we are doing in scheduled sessions?

6. This tests the knowledge, understanding and application of database modelling and implementation.

This IT Computer Science has been solved by our PhD Experts at My Uni Papers.