Database systems analysis & design - Assignment Example

Comments (0) 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 paperFile format: .doc, available for editing
GRAB THE BEST PAPER96.5% of users find it useful
Database systems analysis & design
Read TextPreview

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 pagesRead 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
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Database systems analysis & design

Systems Analysis and Design

...?Running Head: Systems Analysis and Design Systems Analysis and Design Systems Analysis and Design Introduction to Systems Analysis and Design The creation of a computer-based information system (CBIS) involves a phase of systems analysis. Systems analysis produces or improves the organisation specific data models that help to create and/or enhance the organisation’s database. (Shelly, Cashman and Rosenblatt, 2008)...
6 Pages(1500 words)Essay

Database Design

...Database Design The database design is presented in three stages as identified by Gavin Powell (2005)i. These include Conceptual Design, Logical Design and the Physical Design as described below. Conceptual Design The conceptual design of a database being the element part of the overall development of the design forms a critical segment of the design process. The conceptual design stage of the database predominantly includes the description of the various entities and their relationship with regards to...
14 Pages(3500 words)Essay

Database Design Proposal: Analysis

...Health Care Data Management: Database Design Proposal Analysis and User Needs Identification of database users There will be 3 groups of users of the proposed database: 1. Management of the facility 2. Workers at the health centre 3. Patients who are treated at the health care centre Individual needs of database users Top management: to administer the database including altering its structure and layout Workers at the health care centre: data retrieval related to their respective departments Patients: Read-only access to log in and view their own medical record Specific examples of possible uses by the management: The top management would like to know how many patients there are. The management would like to know which patients... ...
3 Pages(750 words)Essay

Database design

...Database design: The database design is a very critical unit for any individual who has interest in the computer technology field. A database system is a worthy asset of any business organization. As such its administration should be effective. For one to ensure effective database management and administration, one need to fully understand the database design. The unit has enabled me gain substantial knowledge on design and management of database. The course gives a detailed introduction of database design. The introduction to database design gave me in-depth understanding of how the idea of database originated from. From the introduction, I learned that the idea of database management system arose as a result of the unending... to...
2 Pages(500 words)Essay

Systems Analysis and Design

...Systems Analysis and Design Question Computer software form part of technological developments that act as an interface through which users can be able to use computer hardware equipment. One of the most popular software brands is Microsoft’s Office package, which consists of Microsoft Project; a project management or scheduling tool that aims at assisting project implementers organize and run projects with enhanced efficiency. Despite its costly nature, MS project has distinctive features that justify its relatively higher cost when compared to other project management software. Among the key benefits of MS Project lies in its complimentary nature with other Office package software as...
1 Pages(250 words)Essay

Systems Analysis and Design

...System Design and Analysis The logical model is the interaction between the resources, processes, their input and output which is used by people to automate, modulate, manage and optimize the information systems. While developing a logical model for registration ­­­­­system at school/college level top-down approach is preferred. Resources are easily organized for individual managed application by distributing work load in different steps. First step is having a main control, which resides with the admin department having clear view of demands and statements. Each phase implements a deeper, more mature implementation of the management solution that is...
1 Pages(250 words)Essay

Systems And Analysis and Design

.... Models used for systems analysis. i) Activity diagrams ii) Class diagrams ii) State machine diagrams iv) System sequence diagrams v) Use case descriptions vi) Use case diagrams Q5. Systems design models. i) Design class diagrams ii) Package diagrams iii) Database schema iv) Diagram Sequence diagrams v) Nodes and locations vi) System security and controls vii) User-interface screens and reports viii) Communication diagram Q8. Architectural design v/s detail design? Architectural design is an extensive design of the overall...
3 Pages(750 words)Case Study

Systems Analysis and Design

...ID # Candi Keys “A candi key is a column or multiple columns, which can describe the database record in unique form. A single relation can have multiple candidate keys” (Janssen). In this project the candidate that can be used to uniquely identify the records of the database are stock number, vehicle number and model. With these candidate keys, a user can uniquely identify the records of the database: Serial Number Candidate Keys 01 Stock Number 02 Vehicle Number 03 Model Primary Keys “A primary key is the key through which users can uniquely identify the each record of the relation. In one relation there is only one primary key” (Chapple). In this project the primary key that can be...
1 Pages(250 words)Essay

Systems Analysis and Design

...Systems Analysis and Design If I were a systems analyst building a detailed test plan, I would use the Software Testing Approach as my main testing strategy. The Software Testing Approach is acquired largely from the Business Requirement Specification record (Shelly and Rosenblatt 502). This strategy is a static record implying that systems do not update it frequently. I would use simulated data in my test plan because it is suitable for testing limited situations within the plan or organization. The data values I use can simulate live information and additionally test limited situations. The most crucial security issues facing organizations today are...
1 Pages(250 words)Essay

Systems Analysis and Design

...System analysis and design: Contemplative media case study Case 13 Q1. Investigate data migration from Microsoft Access to SQL Server. What tools are available to assist in or perform the migration? The Jet database engine that is employed as the Access database engine is an easy-to-use, flexible solution for management of data. Nonetheless, as databases get larger and extra mission critical, most users find that they need security, greater performance or availability. For the applications that need a robust data platform, move the fundamental databases to SQL Server. The Access SQL Server Migration Assistant (SSMA) can...
2 Pages(500 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.

Let us find you another Assignment on topic Database systems analysis & design for FREE!

Contact Us