Case Study: Dcit Resources Access
Kelny Tan
Bachelor of Information technology (Fulltime) | 3175493
Kelny Tan
Bachelor of Information technology (Fulltime) | 3175493
Case Study: “DCIT Resource Access” Case Study: “DCIT Resource Access” INFT2040 Database management system
Assignment 1
INFT2040 Database management system
Assignment 1
Table of Content Background 2 Data Requirements 2 Resources 2 Category 2 Location 2 Members 2 Course 2 Privileges 2 Loan 3 Acquisition 3 Administrator 3 Reservation 3 Transaction Requirements 3 Data Manipulation 3 Query Transaction 3 Business Rule 3 EER Model 5 EER Model Documentation 6 Entity 6 Relationship 7
The Case Study of “DCIT Resource Access”
Background
The School of Design, Communication and IT (DCIT) of The University of Newcastle, Australia, has requested you, a student of the school, to develop a database system project to record the students and staffs that borrow resources for assignments and projects, such as cameras, speakers, software, CDs, etc. This project is named “DCIT Resource Access”.
Data Requirements
Resources
Resources are classified into 2 types: moveable (e.g. cameras, microphones, etc.) and immoveable (e.g. lab, classrooms, etc.). Every resources is identified by the system by their unique id, description and present status (e.g. ‘Damaged’). For moveable resources, they are identified by their name, make, manufacturer, model, year and asset value. Immoveable resources are identified by their capacities.
Category
Each resources is categorized to a category. The category has a unique code, name, description and max time allowed to borrow/book.
Location
Each resources is located within several locations. The locations have a unique id, a room, building and campus.
Members
Members (Staffs and students whom are enrolled to courses offered by the School of DCIT) have a unique id, name, address, phone, status and a comment field.
Course
Course information about
Bachelor of Information technology (Fulltime) | 3175493
Kelny Tan
Bachelor of Information technology (Fulltime) | 3175493
Case Study: “DCIT Resource Access” Case Study: “DCIT Resource Access” INFT2040 Database management system
Assignment 1
INFT2040 Database management system
Assignment 1
Table of Content Background 2 Data Requirements 2 Resources 2 Category 2 Location 2 Members 2 Course 2 Privileges 2 Loan 3 Acquisition 3 Administrator 3 Reservation 3 Transaction Requirements 3 Data Manipulation 3 Query Transaction 3 Business Rule 3 EER Model 5 EER Model Documentation 6 Entity 6 Relationship 7
The Case Study of “DCIT Resource Access”
Background
The School of Design, Communication and IT (DCIT) of The University of Newcastle, Australia, has requested you, a student of the school, to develop a database system project to record the students and staffs that borrow resources for assignments and projects, such as cameras, speakers, software, CDs, etc. This project is named “DCIT Resource Access”.
Data Requirements
Resources
Resources are classified into 2 types: moveable (e.g. cameras, microphones, etc.) and immoveable (e.g. lab, classrooms, etc.). Every resources is identified by the system by their unique id, description and present status (e.g. ‘Damaged’). For moveable resources, they are identified by their name, make, manufacturer, model, year and asset value. Immoveable resources are identified by their capacities.
Category
Each resources is categorized to a category. The category has a unique code, name, description and max time allowed to borrow/book.
Location
Each resources is located within several locations. The locations have a unique id, a room, building and campus.
Members
Members (Staffs and students whom are enrolled to courses offered by the School of DCIT) have a unique id, name, address, phone, status and a comment field.
Course
Course information about