INFO6001: University X – Requirement Analysis and Conceptual Design – University Of Newcastle – Database Management

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

Added on: 0000-00-00 00:00:00Order Code: Question Task Id: 0

Internal Code: MAS6935
Database Management:

You have been approached by University X and asked to provide a design for a database system that will store information on the programmes, faculties, staff, student and course information. An initial requirements collection and analysis phase of the database design process has been completed. The following (very incomplete and in some situations incorrect) project specifications for the university is given in section 2 below. The proposed database is developed in various modules, including requirements analysis, conceptual database design, logical database design, and physical database design. In assignment 1, you are required to develop user requirements specification
and the conceptual database model for University X. Your lecturer will discuss the details of the requirements in class as well as act as the
client of the system. You need to implement all the details mentioned in the lecture as well as described in this document. You are encouraged to ask questions to the lecturer to clarify requirements.

University X has similar requirements to UoN. There are a number of organizational units which make up the university. Each organization unit has a unique code, a unique name, an abbreviated name, a description, a title for the head of the unit (such as ‘Head of School’, ‘Pro Vice-Chancellor’) and the main contact number. Examples of organizational units include – Academic Division, Research Division, Faculty of
Engineering and Built Environment, Faculty of Business and Law, Centre for Teaching and Learning, etc. Some units may have sub-units (for example, Faculty of Engineering and Built Environment may contain School of Electrical Engineering and Computing). A number of staff members work at the university (both academic and administration staff). Each staff member has a unique staff number, name, address, email and contact number. Each member of staff is associated with at least one unit in the university. It is possible for staff to move to different units. Hence, there is a start date, end date and the role played (e.g. ‘Lecturer’, ‘PVC’, etc.) in the unit that needs to be
maintained for an association between a staff member and a unit. Each unit has a current head/manager for the unit who is a staff member.
There a number of different academic programmes offered by certain units in the university (e.g. “Bachelor of Information Technology”, “Bachelor of Computer Science”, etc. offered by the School of Electrical Engineering and Computing). A programme has a programming code (unique), a descriptive name (unique), total credits to complete, level (Certificate, Bachelor, Masters, Ph.D.) and certification achieved
(e.g. Dip, BSc, MSc, Ph.D. etc.). The university has a number of campuses physically located in different parts of the country and overseas. Each campus has a campus id, a name, suburb or city where it is located and a country. There are a number of facilities that belong to each campus (e.g. classrooms, office rooms for staff, laboratories etc.). Each facility has an id (which is unique for the campus), room number, building name, a capacity and the type of the facility (room, classroom, laboratory etc.) Each year, the university has a number of time periods called semesters and trimesters where subjects are offered. Each semester/trimester has a unique id to identify it, a semester or trimester name, and a year. A number of courses are offered by the university. A subject has a course id (unique), course name (unique), number of credits assigned to the subject, and a brief description. Each course belongs to at least one academic programme. A course may
be assigned to multiple academic programmes. You need to maintain the start and end date for each course assignment to the academic programme. Also, the courses assigned to the academic program should specify the role the course plays in the academic program (e.g. core course, compulsory course etc.). Some courses have other courses as assumed knowledge. When a course is offered, it is termed a “course offering”. A course offering contains a single subject, a semester/trimester it is offered and a campus it is offered in. A staff member coordinates a course offering, called the Course Coordinator. Each course offering has a number of timeslots in which students and lecturer/tutor meets in different facilities (classroom, lab etc.) for particular activities (e.g. lecture, lab, tutorial, workshop etc.). The timetable information needs to be maintained in the database. There are a number of students who are enrolled in the university. A student enrolls in
a particular academic programme in a particular semester/trimester. This is also known as “student enrolments”. The date a student enrolls in an academic programme must be maintained.

 

Uploaded By : celina
Posted on : February 15th, 2018
Downloads : 0

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services