leadership and management theories in contemporary organisational settings. Custom Research Paper Help

leadership and management theories in contemporary organisational settings. Custom Research Paper Help

ScenarioLondon University is a prestigious institution educating students from all overthe world. It offers 40 programmes from five disciplines. The university currentlyuses an old legacy system which is file-based. Due to various difficulties, themanagement have decided to modernize the system by having an onlinesystem with a backend database.As a group of consultants, you are required to produce a database system toupgrade a part of the system that handles the student registration andtimetabling of students.On arriving at the university each student must be enrolled on a programmeand be allocated a personal tutor who would oversee their academic needs atthe college. The maximum duration of a programme is 6 years for part-time,and 4 years for full-time mode. The minimum and maximum number of modulesthat make up a year of a programme is six to eight modules for full-time, andfour to six for part-time students. Each module weight 15 credits, students arerequired to obtain a total of 360 credits to be eligible for an award.Each programme must have a student representative. The student rep is thefirst point of call for fellow students with issues related to the programme,modules, and teachings.Each student must take and pass each module in a given year before they areallowed to move into the next year of the programme or to graduate. A studentis normally allowed two attempts to pass a module. A particular module can beoffered as part of one or more programmes.The university has 5 departments, each of which offers a number ofprogrammes. Each department has a Head of Department (Dean) and eachprogramme has a Programme Leader. Each module is assigned to a ModuleLeader who oversees the teaching and assessment of the module. PrincipalLecturers manages other teaching staff, which can also include ProgrammeLeaders.Staff details, such as, contact telephone numbers, speciality, qualification andawarding institutions and previous employment must be recorded.In order to achieve the business needs and ensure consistency of data in thedatabase you are to develop integrity and referential integrity constraints thatwill ensure the correctness of the data when it is entered. Below is a list ofchecks you should implement.1. For this study, student gender should be recorded as M for male or F for female.2. The name of a student/staff should not contain any numeric characters.3. The staff salary should be greater than ?10,000 and not exceed ?150,000.4. Student email address should have an @ symbol present to be valid.55. The classification of module results must only be one of F , P , M , D , NS , FX .6. Each student s start-date of a programme must always have a value.7. Each student s end-date of a programme should not be earlier thantheir startdate and it should be minimum of 3 years.8. The student degree graduation date should be greater than 27-Oct-2015 .9. Staff and Student numbers should be generated automatically using asequence and a trigger.Assessmenta) A fully UML annotated E-R diagram 1 and 2 showing the entities, primaryand foreign keys, composite keys, relationships and optionality. (15 marks)b) A relational schema of your database in 3NF, clearly indicating attributes, thedata type of each attribute, primary and foreign keys and which attributes arenullable, giving reasons. List any assumptions you need to make.(15 marks)c) Listings of the records in each table. There should be a minimum of tenrecords in each table.(5 marks)d) Ensure consistency of data in the database by developing integrity andreferential integrity constraints that will ensure the correctness of the data whenit is entered.(10 marks)e) Produce SQL listings on the specific questions based on the Case Study.(30 marks)1. List all students details and order by student Id. [3 marks]2. List of student reps in all programmes [4 marks]3. List the names of all students who are enrolled on the BSc ComputerScience and are doing the Database module. [4 marks]4. Find the student with the minimum marks in a specific module, givingthe name of the student and module. [4 marks]5. Give a count of the number of students on a specific module thatstarted on 1st September, 2015. [4 marks]6. Give total credits acquired by each student. [4 marks]7. List the academic s name and salary and their Principle manager sname and salary for all academic staff who earn more than theirmanagers. [ 7 marks]f) Documentation must be logically organised with clarity and completeness.TEAM WORK: Documentation stating how each group member participated inthe development and completion of the assignment.(5 marks)6g) Group presentation presenting the design and implementation of thesolution in Oracle.(20 marks)


Comments are closed.