Preview

Case Study: Dcit Resources Access

Powerful Essays
Open Document
Open Document
1707 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
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

You May Also Find These Documents Helpful

  • Good Essays

    A database is an integrated computer structure that stores end-user data and metadata (Coronel, Morris, & Rob, pg. 7). Data are the raw format of information, which when properly formatted can produce accurate, relevant, and timely information that is the key to making good decisions (Coronel, Morris, & Rob, pg. 5-6). The purpose of a database is to provide computer-based systems a way in which to store, manage, and retrieve data quickly (Coronel, Morris, & Rob, pg. 5). As for a local college database, the purpose of the database will be to house the data of enrolled students, the courses offered and times available, and the information of the faculty. The database can provide possible course matches for each student based off of previous courses taken and pre-requisites obtained, as well as keep track of the professors teaching each course. The database will provide the data a student needs to insure they are taking the correct courses and provide the college and the faculty general student information, such as contact information.…

    • 906 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    MIS 563 COURSE PROJECT

    • 2795 Words
    • 12 Pages

    This finding has ABC University seeking a streamlined way to manage their data and for users to access the data that is clean. With this, the University has proposed the creation and implementation of a data warehouse to house all the data from each one of these operational databases into one central location where all students, staff and faculty can access the data using a self service tool such as a report or a data connection to Microsoft Excel to pull data into pivot tables.…

    • 2795 Words
    • 12 Pages
    Powerful Essays
  • Satisfactory Essays

    Unit 1 Lab 1

    • 432 Words
    • 2 Pages

    This project will develop and deliver a new way of knowing the status of software owned by Grandfield College for machines used by faculty and staff. The database that will be created will track the location of the software that Grandfield College owns. The new database will display a number of software which the school owns, where they are located, who uses the software, and what are the versions of the software owned by the school. Also, despite the version or the software, all versions and software will have (need to have) a “site” license. This database will be developed to enable additional products to be added to it over a period of time and be easy to maintain.…

    • 432 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Using a database management system (DBMS) is a wise decision for any business that plans to implement the use of a database as part of their IT infrastructure. A database management system, also referred to as a database manager (Rouse, 2005), allows one or many computers to create, query, and manipulate data in the database (Rouse, 2005). The database management system also manages request from users and applications, making the database much more user friendly, since the users nor the applications have to know where the data is physically located for the database (Rouse, 2005). Where multi-user systems are being utilized the database management system does not allow the current user to see who else is accessing the information. The database contains data that needs to be protected from intentional or accidental misuse (Ricardo, 2012). The database management system is instrumental to securing the database; and that system allows the database administrator to setup security restrictions and enforce them on multiple levels, making sure only those with the proper credential have access to the data (Ricardo, 2012). The DBMS also adds to the overall security by having the functionality to encrypt the data before it is stored in the database (Ricardo, 2012). The database management system also helps to ensure database integrity, making sure data is readily accessible and is organized as intended by the database administrator (Rouse, 2005). The DBMS also allows the database administrator to define integrity constraints, which are consistency rules that the database must obey (Ricardo, 2012).…

    • 821 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    CIS 2321 Week 6 Teamwork

    • 227 Words
    • 3 Pages

    Situation: Pleasant Creek Community College has a typical school registration process. Student support services include faculty advisors and tutors. The administration has asked you, as IT manager, to develop an object-oriented model for a new registration system.…

    • 227 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Ddi Case Study

    • 418 Words
    • 2 Pages

    Development Dimensions International (ODI), a consulting firm, is where Jennifer Reingold had her training for strategic decision-making on day to day challenges faced by a manager.…

    • 418 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Introduction to Databases

    • 2372 Words
    • 10 Pages

    A database management system provides a number of facilities that will vary from system to system. Describe the type of facilities you might expect, especially those that aid the initial implementation of a database and its subsequent administration.…

    • 2372 Words
    • 10 Pages
    Good Essays
  • Powerful Essays

    Most colleges and universities nowadays rely on effective use of information technology for instruction, research, and administration. With high request for technology professionals, it is crucial that we continue to recruit competent staff. Recruiting challenges include reduced numbers of graduates in computer-related fields, lack of competitive salaries in the higher education environment, and increasing market demand for information technology skills. As the demand for information technology professionals continues to exceed the supply, our institutions will face even greater staffing challenges. Key issues that pertain with these matters are:…

    • 1944 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Miss

    • 510 Words
    • 3 Pages

    * 10:07 am-In the meeting Accudemia was discussed and the major problem of the Accudemia was that the students were not able to log in for a certain subject and also the students that don’t go to MDC have no way to log in. The resolve for that problem would be to keep a hand-written tally of people who come in that are not current students of MDC.…

    • 510 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Develop an ER diagram to sketch a design that meets these requirements “Translate” ER diagram into detailed DB schema…

    • 735 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    | Design and improveappropriate systems for the collection, storage anddissemination of and access to the information andknowledge gathered…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Relational Calculus

    • 1192 Words
    • 5 Pages

    student (rollNo, name, degree, year, sex, deptNo, advisor ) department (deptId, name, hod, phone )…

    • 1192 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    "Every object present on the Earth can be geo-referenced", is the fundamental key of associating any database to GIS. Here, term 'database ' is a collection of information about things and their relationship to each other, and 'geo-referencing ' refers to the location of a layer or coverage in space defined by the co-ordinate referencing system.…

    • 4947 Words
    • 20 Pages
    Powerful Essays
  • Satisfactory Essays

    something descriptive

    • 904 Words
    • 4 Pages

    Are you looking for college management system project documentation pdf ? Get details of college management system project documentation pdf.We collected ...…

    • 904 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    digital library

    • 1344 Words
    • 6 Pages

    Digital libraries are an important and active research area. Conceptually, a digital library is an analog of a traditional library-a large collection of information sources in various media-coupled with the advantages of traditional technologies. However, digital libraries differ from their traditional counter-parts in significant ways: storage is digital, remote access is quick and easy, and materials are copied from a master version. Furthermore, keeping extra copies on hand is easy and is not hampered by budget and storage restrictions, which are major problems in traditional libraries. Thus, digital technologies overcome many of the physical and economic limitations of traditional libraries.…

    • 1344 Words
    • 6 Pages
    Powerful Essays