Ask a question from expert

Ask now

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
NIT1201 Database Management System Assignment (DBMS)_1
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.
NIT1201 Database Management System Assignment (DBMS)_2
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)
NIT1201 Database Management System Assignment (DBMS)_3
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)
NIT1201 Database Management System Assignment (DBMS)_4

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 Dictionary
|6
|563
|75

DATABASE DESIGNING.
|5
|449
|68

Database Assignment | Database Management Assignment
|13
|2424
|64