StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Database systems analysis & design - Assignment Example

Cite this document
Summary
This document would provide brief overview of the system, highlighting the stakeholders of the system, the required features that the database model should…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER94.5% of users find it useful
Database systems analysis & design
Read Text Preview

Extract of sample "Database systems analysis & design"

Download file to see previous pages

It keeps a record of the students in the university. Each student record includes personal details, the departments that they are majoring in, any minors they might have chosen, the courses a department offers that they might be enrolled in, the particular section of a course they might be in and the instructor teaching them in that particular section. The system helps issues a grade report for a student indicating the marks obtained in a section and the grade awarded. The University System has two stakeholders; the Administrators and the Students.

This section highlights the role of each stakeholder in the system. The proposed data model has to consider these roles in its design. The administrators are users who perform the managerial tasks of the system. They have the privilege of adding, reading, updating and deleting details and records of students, courses, sections, grades and departments. They can perform advanced level statistical queries on the data stored in the system. An administrator could even be the Dean of the university.

The Students are the users that only have the privilege to reading their grade report for each course. Students do not have any privilege of adding, updating or deleting any type of information to the database. Top-down modelling approach was used in formulating the data model for the University System database. Therefore, a series of sub-diagrams were designed first to lay the ground for the final Entity Relationship Attribute (ERA) diagram. The entity relationship (ER) model was formulated first once the entities and their relationships were identified.

The Entity Attribute (EA) Model was designed next once the attributes for each entity were identified. Thereafter, relationship sets and identifiers were selected from the ER Model forming the final ERA diagram. Robinson notation was used in designing the database model. The first phase was to

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database systems analysis & design Assignment Example | Topics and Well Written Essays - 3000 words”, n.d.)
Database systems analysis & design Assignment Example | Topics and Well Written Essays - 3000 words. Retrieved from https://studentshare.org/systems-science/1602843-database-systems-analysis-design
(Database Systems Analysis & Design Assignment Example | Topics and Well Written Essays - 3000 Words)
Database Systems Analysis & Design Assignment Example | Topics and Well Written Essays - 3000 Words. https://studentshare.org/systems-science/1602843-database-systems-analysis-design.
“Database Systems Analysis & Design Assignment Example | Topics and Well Written Essays - 3000 Words”, n.d. https://studentshare.org/systems-science/1602843-database-systems-analysis-design.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database systems analysis & design

Research Report outlining the general database techniques

Database performance increases through normalization, database partitioning, using federated database systems and certain hardware considerations such as RAID.... There are some performances issues that arise due to the structure and the design of the database.... Through this process, data can be broken up by organization, business unit, region, date and others which help in the desired analysis of data (Connolly and Begg, 2008, p.... And these subsets can be managed and accessed with efficiency and are useful for analysis....
5 Pages (1250 words) Essay

Data Management Layer Design

References Alan Dennis, Barbara Wixom, and David Tegarden, (2005), systems analysis and Design With UML 2.... of Crete, Information systems analysis and Design, Persistent Data Management Layer Design (III) chapter 10, Fall, retrieved from, http://www.... Data management layer design The key definitions are object persistence which is the selection of storage format and to ensure that optimum performance is attain.... Data management layer design The key definitions are object persistence which is the selection of storage format and to ensure that optimum performance is attain....
3 Pages (750 words) Coursework

Database System Specifications in Mayo Clinic Medical Center

hellip; In this analysis report, I have outlined an innovative database technology implementation at Mayo Clinic Medical Center business.... This paper presents a detailed analysis of basic areas of the new technology.... This paper throws light on the development and analysis of a database system for “Mayo Clinic Medical Center” that is health care business with a variety of off-site campuses interacting within its health system....
8 Pages (2000 words) Case Study

An Electronic Database

he database systems should also allow for reuse in that part of it can be used to design new systems.... Business database systems (2008).... Readings In database systems(2010).... A specific user requirement needs to be well elicited before the design and development takes place.... A specific user requirement needs to be well elicited before the design and development takes place.... duCourses Table Course_NumberCourse_NameTrainer_Emp_NoTrain_Location10001Database Administration201201Lecture 110002Computer Application201202Lecture Hall 510003Information System201202Computer Lab10004Object Oriented Programming201203Computer Lab10005System analysis And Design201204Lecture Hall 7Work cited1....
4 Pages (1000 words) Essay

The Term Relational Database

It can contribute towards a competitive edge by facilitating business analysis that can help to determine methods of improving products and services (Pathak, 2008).... For most DBMSs (databases management systems) users are able to specify that duplicate rows are not permitted, and when that is done the DBMS will block the addition of any rows that are identical to an existing one.... Data in a table can be related in terms of… In the case of a relational database, an RDBMS (relational database management system executes data storage, maintenance, and Relational databases use specific integrity rules to facilitate accurate collection of data and to make that data accessible....
4 Pages (1000 words) Coursework

Information Systems in Business - Wal-Mart

This allows real time analysis of the data and facilitates decision making that is appropriate for each store based on the data available (Paul, 2001).... Items in this model can connect to any item in the database creating a network.... Most databases that are used on the Mini and Micro computers are normally based on either hierarchical or network database model.... Relational database model has data organized in two dimensional tables with rows and columns populated with related data....
5 Pages (1250 words) Coursework

Analysis and Design of the UniRec Gym System

The paper "Analysis and design of the UniRec Gym System " highlights that the interface designed has an automated process for documenting transaction reports and this feature is represented via the printing of a receipt within the system interface.... The Net Present Value (NPV) for this particular proposed system design and implementation project gives a -$27,998.... nbsp; When looking into the economic feasibility study of the proposed system one has to first develop and outline the cost-benefit analysis of implementing this system....
6 Pages (1500 words) Case Study

Contemplative Media System

rchitectural design is an extensive design of the overall system structure.... It is also known as conceptual design or general design.... On the other hand, Detail design is a low-level design that entails the design of the explicit program details (Satzinger, Jackson & Burd, 2012).... The domain representation is as well used in designing the database....
3 Pages (750 words) Case Study
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us