NIT1201 Database Management System Assignment (DBMS)
20 Pages2180 Words351 Views
Introduction to Database Systems (NIT1201)
Added on 2020-05-08
NIT1201 Database Management System Assignment (DBMS)
Introduction to Database Systems (NIT1201)
Added on 2020-05-08
BookmarkShareRelated Documents
Running head: DATABASE MANAGEMENT SYSTEMDatabase Management SystemName of the Student:Name of the University:Author Note
1DATABASE MANAGEMENT SYSTEM List of Business RulesThe list of business for the Western Melbourne University is provided below;The database is required to store all the basic information about the students.The database is required to store all the basic information about the staffs of theuniversity.The database is required to store the information about the enrollment of the studentsThe database is required to store all the information about the teachers in the university.The database is required to store all the assessments and the results of the students in theuniversity.The database is required to store all the information about the units in the semesters.
2DATABASE MANAGEMENT SYSTEM ER DiagramsStudentStaffsTeachersEnrollmentResultsStudentIdPKStudentNameAddressStaffIdPKStaffNameStaffAddressTeachersIdPKTeacherNameDepartmentIdEnrollmentIdPKStudentIdStudentNameStudentIdUnitIdGradeStaffIdDepartmentIdUnitIdUnitNameTotalPaymentContactNumberEmailEmergencyNameEmergencyContactRelationshipTeacherAddressDepartmentNameenroll in universityenrolls the studentsteachesofData dictionaryStudents (studentsID (pk), StudentName, Address, ContactNumber, Email, EmergencyName,emergencyContact, Realtionship)Staffs (StaffID (pk), StaffName, StaffAdress)Teachers (TeacherID (pk), TeacherName, TeacherAddress, DepartmentID, DepartmentName)
3DATABASE MANAGEMENT SYSTEM Enrollment (EnrollmentID (pk), studentID, StudentName, StaffID, DepartmentID, UnitID,UnitName, TotalPayment)Results (StudentID, UnitID, Grade)Functional DependenciesNormalizationThe following are tables are already provided in the first normal form. Hence, The 1NF for the database:Students (studentsID (pk), StudentName, Address, ContactNumber, Email, EmergencyName,emergencyContact, Realtionship)Staffs (StaffID (pk), StaffName, StaffAdress)Teachers (TeacherID (pk), TeacherName, TeacherAddress, DepartmentID, DepartmentName)Enrollment (EnrollmentID (pk), studentID, StudentName, StaffID, DepartmentID, UnitID,UnitName, TotalPayment)Results (StudentID, UnitID, Grade)The 2NF for the database:Students (studentsID (pk), StudentName, Address, ContactNumber, Email)Emergency (EmergencyName, emergencyContact, Realtionship)Staffs (StaffID (pk), StaffName, StaffAdress)
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
ER Diagram, Relational Data Logical Model, Data Dictionarylg...