Database systems analysis & design - Assignment Example

Comments (0) Cite this document
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 PAPER95.4% 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
(“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
Web Exercise: Understanding Job Analysis. The ONET Occupational Database
Web Exercise: Understanding Job Analysis How easy was it to find the specific occupation you were looking for, and how comprehensive was the information provided about that occupation? Answer #1: O*Net is the leading website on occupations that provides access to the most reliable and accurate information which has been gathered from reliable sources.
4 Pages(1000 words)Assignment
Database Systems
In these distributed databases systems, requests and transactions can further categorised as remote and distributed. Requests can be categorise as remote requests and distributed requests. A remote request accesses data located in a single remote data processor site and queries can accesses that locations data only.
1 Pages(250 words)Assignment
Database Design Proposal: Analysis
However, a number of possible redundancy and coherency issues and other challenges should be acknowledged and dealt with, which are detailed below. In addition, an issue of data coherency could arise if care is not taken to different data pertaining to the same entity
3 Pages(750 words)Essay
Database application, Planning, Design, and Implementation
The most apparent instance of a non computerized database is a telephone directory. On the other hand, telephone companies at the present time make use of an electronic database program to turn out their
1 Pages(250 words)Assignment
Database Management System Assignment
A randomly generated test script is utilized to provide variation among test cases and consistency between different runs of the benchmark. The benchmark is platform independent and can be extended to support any database vendor providing a Java data source for connectivity.
19 Pages(4750 words)Assignment
The Design and Implementation of a Database Managed Website
Several programming languages, databases and other techniques are available to develop websites and publish data on the internet in a quick, effective and efficient way to foster maximum productivity and use. This project "The Design and Implementation of a Database Managed Website" was initiated to develop a customised content management system for a case organisation's website which could provide timely, accurate and standardised information quickly on the website with proper database support at the back end to ensure that no information can be lost even if the web site is unavailable.
20 Pages(5000 words)Assignment
Relational Database Design
The Relational Database specification required nine table in the following relationships. A table Textbook with a many-to-many relationship through a junction table (outside join) to the table Module through the Module_Detail table. A many-to-many relationship is required between Module and Field through a join table (outer join or junction table) Field_Detail.
6 Pages(1500 words)Assignment
Oracle Database 11g
The database constitutes both logical and physical structures. Since the logical and physical structures are separate, the data physical storage can be managed without necessarily affecting logical storage structure access. Every database instance is
16 Pages(4000 words)Assignment
IT425-1403A-01 : Systems Analysis, Design and Integration
To evade these wars heightening the three amigos got together (over a period) and created a documentation, which enveloped the best of their individual, documentations and which worked with most OO systems. The documentation was
4 Pages(1000 words)Assignment
Systems Analysis and Design
However, these sub-divisions of human factors are not essentially equally limited (Nelson & Associates, 2010). In addition, in order to assess the influence of human factors on design of the input systems, it is believed that these factors are really significant.
4 Pages(1000 words)Assignment
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!
logo footer
Contact us:
Contact Us Now
FREE Mobile Apps:
  • StudentShare App Store
  • StudentShare Google play
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • Miscellaneous
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us