Information Systems and Databases Assignment

The following is the assignment as set out for the module of Information Systems and Databases (B7IS100).

Read the following case study and then carry out the required tasks.

Midlands Technological University (MTU) is a 3rd level provider of Level 6,7,8 and 9 QQI recognised programs serving principally the counties of the midlands area of Ireland. MTU Students Union (MTU SU) is the representative body for all students (full time and part time ) in MTU. All registered students are automatically registered as members of the Students Union (SU). MTU has a student enrolment of approximately 9000 students.

MTU SU is entirely independent of MTU but operated from offices based in the college. MTU SU’s primary focus is to provide support, information and advice on a wide range o issues to students. It also provides student centred services and facilities to its members such as a shop, printing and room booking functions. MTU defines itself as ‘an organisations run by students to facilitate for the students’ needs’. The union is bound by its constitution and is affiliated with and is represented nationally by the USI. 

The day-to-day operations of the union are carried out by the Executive Committee that is elected by student ballot annually. The Executive Committee is made up of 6 members with an additional chairperson. The Executive Committee consists of three full time sabbatical officers, President, Vice President (academic affairs) and Vice President (Student Welfare). There are three elected part-time officers (Clubs & Societies, IS362 CA 2 Entertainment and Equality). All of these positions are directly elected by the entire student body using proportional representation.

The Chairperson is elected by the Class Representative governing council using proportional representation. The Class Representative governing council consists of individual class reps elected by each year of course (e.g. class rep for Yr1 BIS, class rep for Yr2 BIS etc…), who meet on a monthly basis to make representation and lobby on behalf of the class. Class reps are elected informally in class at the start of each academic year. The Chairperson chairs all the class rep meetings and the Executive Committee meetings. The Chairperson must remain impartial and only has a vote on the Executive Committee in the case of a tie.

MTU SU also has two full time members of staff to support administrative and office duties. A lot of time and work is spent on manual processes e.g. traditional calendar facilities are in use and the office staff have only a basic knowledge of MS Word and Excel etc… while the Executive Officers are less advanced users.

The SU President has recruited you as a team of consultants to design and implement a database system which will help them better utilise their resources. This is part of a large project to cloud-enable many aspects of the SU activities and the SU Presidents hopes it will provide accurate reporting facilities, which at the moment is very difficult to achieve.

The requirements gathering phase of the project has already been completed and the following requirements have been identified for the new database:

 Keep track of Class Reps (who they are, contact details, course they are representing, date of class rep training, academic year etc…).

 Record MTU SU staff details.

 Maintain a record of the contact details for all students in the college.

 Maintain a record of clubs and societies in the college.

 Record which students have registered/signed up for each club/society.

The following is a sample of the reporting requirements which have been identified for the new database system;

1. Provide a list of all class reps

2. Identify any courses without a class rep

3. Produce a monthly calendar of events for students

4. Produce a report showing the numbers of students signed up to each club/society.

IS362 CA 3

Read about Database Application System Assignment.

Requirements:

1. You are required to produce an Entity Relationship Diagram to represent the logical design for the proposed database system. Each ERD should be clear and you must state any assumptions made. ERD’s must be drawn using the crows feet notation. You should use MS Visio for diagramming. 

The ERD must include:

a. Relationships should indicate optionality.

b. Define the Primary Key for each entity

c. Define any Foreign Keys for each entity

d. For each entity you are required to identify at least five suitable attributes.

e. Diagrams must be drawn using the Crows Feet notation.

(30 marks)

2. Using the ERD developed in Part 1, you are then required to develop the physical database using SQL Server.

a. Creation of suitable tables with well-chosen primary and foreign keys.

b. Implementation of required relationships, as per your ERD.

c. Populate tables with at least 5 records each.

d. Create at least 4 queries, which would meet the reporting requirements of MTU SU.

e. Create one suitable view for the SU management.

f. Create one suitable stored procedure for the SU management.

(45 marks)

3. Provide the following details in a MS Word document.

a. Cover page, table of contents etc… (i.e. a well-structured document).

b. A copy of the ERD, along with an explanation of any assumptions made.

c. Screenshot of the tables & relationships created using MS SQL Server.

d. Copies of the SQL code used to create the queries, views and stored procedures, along with a brief explanation as to what each was seeking to achieve.

(15 marks)

4. Demonstration of database in class.

IS362 CA 4

a. Each student must demonstrate their working system during class time in week 24.

(10 marks)

TOTAL: 100 Marks

Submission Details:

Students must submit the following:

 Evidence of progress must be demonstrated in class during week 13.

 You must submit your Word document electronically via Moodle by 6pm on the day of the deadline. Late submissions will be subject to penalties as outlined in the DBS Assessment Regulations document.

 All submissions must be clear and legible and I must be able to view your files in a Windows environment.

 It is the students’ responsibility to ensure their work is submitted on-time, to the correct location and in a legible format.

Assignment objectives:

 Demonstrate understanding of concepts of good database design.

 Demonstrate ability at data modelling.

 Apply practical database skills to produce a database.

 Manage time and enhance personal project management experience.

IS362

Programming Assignments Help is the best assignment help provider in the United Kingdom. Our online assignment writing help UK is especially dedicated for the students studying in all UK colleges and universities. Submit assignment to get the best quality assignment help.