Long term and short-term managerial decisions

Coursework

2021-2022

Module Leader: Naji Saravanabavan

E-mail: naji@nsbm.ac.lk

2. Registration department wanted to have the student details for the registrations and maintain their personal information’s for the educational aspects.

3. Library wanted to have the student details for the library access and the book issuing

1. Allow the administrative staff to enter and maintain details about all the project activities. Your application should include appropriate data validation mechanisms (constraints), triggers and user defined functions.

2. Allow authorized parties to view details to generate meaningful management reports to make strategic, long term and short-term managerial decisions. Your application should include appropriate views and stored procedures to retrieve operational data.

• A basic introduction to the scenario with the important facts you have identified and considered to your solution. (Do not copy and paste the given scenario as it is)

• An Entity Relationship (ER) or Extended Entity Relationship (EER) Diagram showing all of the entities, their attributes, relationships, cardinality ratio and the participation constraints. (Should include a sensibly resized diagram which clearly show all the elements)

Section 2:

• Microsoft SQL Server Create Table statements with related Constraints for each table to validate data. (Should include sensibly resized screenshots of all the table creation statements which clearly show all the SQL statements)

• Microsoft SQL Server Create Function statements for the user defined functions that you have created. (Should create at least two user defined functions for your database and should provide sensibly resized screenshots of the SQL statements)

• Microsoft SQL Server Create View statements for the database views that you have created. (Should create at least two database views for your database and should provide sensibly resized screenshots of the SQL statements)

Deliverable 2

A complete backup of your database (.bak) with a softcopy of the report (.docx or .pdf) and the presentation slide show (.pptx) archived as a ZIP file. Note that any part of your submission in an incorrect file format cannot be marked. Coursework may be submitted at any time ahead of the deadline time. Please note the University regulations concerning late submission of coursework. Please note that the late submissions of project deliverables will not be assessed.

Assessment

The assignment assesses the Learning Outcomes of the module,

Moodle e-submission through Plymouth Digital Learning Environment (DLE) is compulsory for each module.

Assignment Feedback:

• Coursework can be submitted at any time ahead of the deadline.

• Please note that work submitted late without valid extenuating circumstances will be penalized. Work submitted within 24 hours after the deadline will receive a mark, but it will be capped at the normal pass mark for that module. Work submitted more than 24 hours after the official deadline will receive an automatic mark of zero.

Academic offences occur when activity is undertaken which could confer an unfair advantage to any candidate(s) in assessment. The University recognises the following (including any attempt to carry out the actions described) as academic offences, regardless of intent:

a) Copying or paraphrasing of other people’s work or ideas into a submitted assessment without full acknowledgement (plagiarism).

f) Being party to any arrangement which would constitute a breach of these regulations.

g) The inclusion in a piece of assessed work (other than an examination or test) of material which is identical or substantially similar to material which has already been submitted for any other assessment within the University.