Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Database Design and Development
Typology: Assignments
1 / 17
This page cannot be seen from the preview
Don't miss anything!
PROGRAM TITLE: …… ………………………………...... UNIT TITLE: …………………………………………………………………....... ASSIGNMENT NUMBER: …………………1…………………………....... ASSIGNMENT NAME:...... Database Design & Development ……….. SUBMISSION DATE: ……………………………………...... DATE RECEIVED: …………………………………………………………........ TUTORIAL LECTURER: ……… Nguyen Quang Huy…………......... WORD COUNT: ………………………………………………………….......... STUDENT NAME: ………Do Long Nhat……………………………. STUDENT ID: ………………BKC12174……………………………… MOBILE NUMBER: ………… 0901569964 ………………………
Summative Feedback: Internal verification:
I. Introduction This report will discuss, design database about dormitory management scenario of BKACAD. Describe the entities, attributes, and relationships between entities. Supply system design involves an exact problem: designing ER diagrams, converting ER diagrams into relational diagrams, normalization, creating relational database systems. Finally, the report will show the system interface design for the above scenario. II. System requirements
1. Real world scenario: I am employed as a Database Developer for a large IT consultancy company. The company has been approached by BKACAD which is expanding due to the growth of the number of students. BKACAD is currently facing difficulties in dealing with managing the dormitory. The construction of dormitory management software is implemented with the following subjects: Room, student, class, dormitory management, room rental contract with the following requirements:
Entity Description of Entity Attribute Description of Attribute Room All of rooms in the dorm RoomID It is a unique identifier for each room in the dorm RoomName Name of the room RoomArea Area of the room NumberOfBeds Number of beds in the room RoomRates Room rent Class All of classes in the school ClassID It is a unique identifier for each class ClassName Name of the class Student All of students in the school StudentID It is a unique identifier for each student in the class StudentName Name of student Age Age of student Gender Gender of student Address Address of student PhoneNumber PhoneNumber of student DormitoryManager All of managers in dormitory ManagerID It is a unique identifier for each dormitory manager ManagerName Name of manager RetalContract All of rental contracts in dormitory ContractID It is a unique identifier for each contract CheckInDay Check in date CheckOutDay Check out date
III. Design relational database system for a substantial problem
1. ER Diagram:
2. Convert ER Diagram to Relation Diagram Table 2. Convert ER Diagram to Relation Diagram: Relation Primary Key Foreign Key Other Attribute Room RoomID RoomName RoomArea NumberOfBeds RoomRates Class ClassID ClassName Student StudentID ClassID StudentName RoomID Age Gender PhoneNumber Address RentalContract ContractID StudentID CheckInDay CheckOutDay DormitoryManager ManagerID ManagerName Room_Manager RoomID RoomID ManagerID ManagerID Contract_Manager ManagerID ManagerID ManagerID ManagerID
Already in 3NF format because: Does not contain repetition, does not depend on partial functions, does not contain transitive dependencies. DormitoryManager (ManagerID, ManagerName) ManagerID ManagerName Already in 3NF format because: Does not contain repetition, does not depend on partial functions, does not contain transitive dependencies. Room_Manager (RoomID,ManagerID) Already in 3NF format because: Does not contain repetition, does not depend on partial functions, does not contain transitive dependencies. Contract_Manager (ContractID, ManagerID) Already in 3NF format because: Does not contain repetition, does not depend on partial functions, does not contain transitive dependencies.
4. Relational database system + Create the database: - Open SQL Server Management, select "New Query" and write the command to create the database, then press F5.
The newly created database is displayed in "Object Explorer":
Document shared on www.docsity.com Downloaded by: nhat-do-long ([email protected])
IV. Conclusion This report gave a scenario about dormitory management of BKACAD. Later, the newspaper began to describe the analysis of entities, properties and relationships between entities. Next, the report came up with ER diagram designs, converted to relational diagrams, normalized data, and created relational database in SQL Server Management. Finally, the report has designed the system interface for entities as well as related issues.
