database design

database design

Length: 1114 words (3.2 double-spaced pages)

Rating: Excellent

Open Document

Essay Preview

More ↓
Database Design



Scenario
Currently a school uses a non-computerised database system to store the following information about its students: roll class, surname, first name, guardian's name, address, student's date of birth, gender, sport house, emergency-contact telephone number, mailing name, list of subjects offered, and subjects in which the student is enrolled. The system takes up a large amount of space, has many duplicated entries some of these with mistakes and it is time consuming to search. The school intends to introduce a relational-database management system to overcome these problems.


Current school data storage and retrieval system (the pre-computer database system)

„h School staff, teachers and office staff are the users of the database.
„h Database used to track all details of students in the school.
„h Large amounts of data are stored. An individual record is required for each student.
„h Lots of duplication exists as details of subjects offered by the school are duplicated on individual student records.
„h Data is organised in alphabetical order on student names within years.
„h Data is stored in a number of filing cabinets.


Advantages

„h quick to find details of a student if year and surname are known
„h data is stored in a central secure location
„h original source material is stored in the student file.


Disadvantages

„h slow to find details of students when surname and year are not known
„h data storage takes up a lot of room
„h minimal number of staff can access records at one time
„h data is duplicated.


Stages of development of the computerised relational database system

The new computerised relational database system will be developed in the following stages:

„h analysis
„h design
„h implementation
„h maintenance

Analysis

In this stage the current system is analysed to determine the functions it performs and those that it is unable to perform. Direct and indirect users of the new system are interviewed to determine what they require from the new system. The inputs to the new system, the processes it is to perform and the outputs from the system are clearly defined. A recommendation is made about the type of new system that will be required to meet the identified needs.

During the analysis stage, the following is determined:

„h current storage space of student records needs to decrease
„h an easily update-able backup of student records is required,
„h one staff member is to be responsible for the administration of the system,
„h unnecessary duplication of data is to be avoided,
„h all teaching staff, office staff and the Principal need to have access to the database simultaneously - read access only is required

How to Cite this Page

MLA Citation:
"database design." 123HelpMe.com. 30 Mar 2020
    <https://www.123helpme.com/view.asp?id=61295>.

Need Writing Help?

Get feedback on grammar, clarity, concision and logic instantly.

Check your paper »

Essay on Company Database Design Model

- Introduction As a requirement for our Database Management System I subject, we were assigned to create a database design model for a certain company. Since our instructor allowed us to select any company, we chose _____ ____ _____; further details about this establishment will be explained in the later part of this article. It’s been known that a company with a good business design flow would most likely be much more prone to success since it is the foundation on how a company should develop and progress....   [tags: Database Management System DBMS]

Research Papers
1017 words (2.9 pages)

Database Design and Testing Essay

- Database Design and Testing Assignment: Complete exercises 1-4. Exercises: 1. Recall the AVS scenario from previous assignments. Create an ER Diagram to represent the database design for this system. Include the entities, attributes, relationships, and cardinalities. Name a minimum of three attributes for each entity that you have identified. (20 points) 2. Examine the database entities shown in the figure below and then complete the following problem. (10 points) For each table pictured above, identify the primary key and the foreign key(s)....   [tags: check the input value, foreign key]

Research Papers
658 words (1.9 pages)

database design Essay

- Database Design Scenario Currently a school uses a non-computerised database system to store the following information about its students: roll class, surname, first name, guardian's name, address, student's date of birth, gender, sport house, emergency-contact telephone number, mailing name, list of subjects offered, and subjects in which the student is enrolled. The system takes up a large amount of space, has many duplicated entries some of these with mistakes and it is time consuming to search....   [tags: essays research papers]

Free Essays
1114 words (3.2 pages)

Database design process Essay

- Abstract Database Systems has a practical, hands-on approach that makes it uniquely suited to providing a strong foundation in good database design practice. Database design is more art than science. While it's true that a properly designed database should follow the normal forms and the relational model, you still have to come up with a design that reflects the business you are trying to model. This paper shows describes design process of database project. The importance of Completing the Design Process An important point to keep in mind is that the level of structural integrity and data integrity is in direct proportion to how thoroughly the design process is followed....   [tags: essays research papers]

Research Papers
894 words (2.6 pages)

Essay on Design of a Reconfigurable Hybrid Database System

- ... Placing the reconfigurable platform near the device’s memory further reduces the processing time. Combination of all these three types of database systems described above gives us the “Hybrid Database System (HYBDBS)” that harnesses the power of all three. The design of a Hybrid Database System with Hybrid DB-server as its core component is shown, as provided in the research paper. It differs from standard DB systems in that it has a “Routines Repository” that stores database operators as hardware and software libraries, services and metadata....   [tags: disc resident databases, main memory]

Free Essays
655 words (1.9 pages)

Databases, Forms, and Reports Essay

- Databases, Forms, and Reports This paper will discuss databases, forms and reports. Why has the use of databases increased dramatically. What factors should be considered when designing a database and why. How would you go about designing forms and reports from scratch. In conclusion, a summation will be given along with closing thoughts. Database Usage A database is an organized collection of information or data. It is a collection of organized information in which a computer can easily select and display different fields of data....   [tags: Database Organization Design Essays]

Research Papers
843 words (2.4 pages)

The company I have chosen to design database software for is called Essay

- The company I have chosen to design database software for is called Multi-installations. They are a private limited company that specializes in the manufacture and installation of high tech security doors and screens. 1.1 Introduction The company I have chosen to design database software for is called Multi-installations. They are a private limited company that specializes in the manufacture and installation of high tech security doors and screens. They do many mail shots per month and send up to four brochures to any company/client within a specified department....   [tags: Computer Science]

Free Essays
951 words (2.7 pages)

The Design of a Wireless Sensor Network Essay

- The design of WSN includes various disciplines like database, query processing, networking, algorithms and distributed systems. The basic functionality of WSN generally depends on the applications but the following requirements are typical. I) determine the value of a parameter at a given location. II) Detect the occurrence of events of interest and estimate the parameters of the events. III) Classify the object that has been detected. IV) Track an object. Sensing principles include mechanical, chemical, thermal, electrical, chromatographic, magnetic, biological, fluidic, optical, ultrasonic, and mass sensing....   [tags: database, query processing, networking]

Research Papers
723 words (2.1 pages)

Essay on Database Model Of Column Family Database

- • Key-Value Stores Key-value stores are designed for storing data in flexible and schema-less way. In these databases, data is stored as a list of keys with their corresponding values. All keys are unique and data access is achieved by means of key-value association. In addition, all keys are stored in a hash table to provide quick access for them. Values may contain actual information (raw data), or they may contain another set of keys. Key-value stores provide high concurrency, fast lookups and massive storage....   [tags: Database, Relational model, Relational database]

Research Papers
707 words (2 pages)

Essay about Database Concepts

- Database Concepts, what are Databases all about. I am writing this paper to answer a few questions as part of my first assignment in a class designed to provide a better understanding of Database Concepts. There are many different types of databases, different implementations of databases, and different database software applications. So how does all this database stuff work. I have worked with databases for most of my professional career at many different levels. Sometimes as the user, entering data, retrieving information, and compiling reports....   [tags: Database Data]

Free Essays
1204 words (3.4 pages)

Related Searches

„h reports such as roll class lists, subject class lists, lists of sporting houses, student contact details and family mailing lists need to be easily generated.


To meet these requirements, a relational database system has been recommended. A relational database is "a database in which data is organised in a series of relationships, or two-dimensional tables, where the columns (attributes) represent data fields, and the rows (tuples) represent records. Linking of data between records in different files is done by means of a key field."


The relational model was chosen in preference to a flat file system as the requirements of users would not be met with a flat file. A flat file is "a type of database where all of the data is contained in one file". For all of the information to be held in one table, every student record would require data to be unnecessarily duplicated, introducing redundant data. For example, every student record would require information about the subjects the student is enrolled in and these subject details would be duplicated throughout the flat file. This duplicated data increases the space required by the computer system to process and store the data. It also leads to possible problems with the integrity of the data when modifications to this duplicated data is required.

Design

In this stage the relational database system is developed. The system is made up of two parts, the database management system and the database. A database management system (DBMS) is "the software that builds, maintains and provides access to a database. It also provides data dictionary facilities, file protection and security against unauthorised use". Relational database management systems include software packages such as Microsoft Access. These packages provide the frame work to allow the tables to be developed and linked.

A database is defined as "an organised collection of data items which may be accessed by a database management system. The database may consist of several linked files". The school database will consist of a number of tables that hold information on students and related material.

The information to be stored on students; roll class, surname, first name, guardian's name, address, student's date of birth, gender, sport house, emergency-contact telephone number, mailing name, list of subjects offered, and subjects in which the student is enrolled will be held in the following tables:

„h roll class
„h sports house
„h students
„h subjects enrolled
„h subjects offered
„h contact details

The diagram below shows a schema for this database using the tables outlined above.
A schema is defined as "An organised plan of the entire database showing how and where the data is to be found, descriptions of the data, and their logical relationships. The schema is produced by the database designer and is maintained by the database administrator." The schema shows a list of the attributes (column / field headings) for each table.



The schema above has a primary key for each table. The primary key is defined as "a character or group of characters used to identify a unique record in a database¡¨. The key is composed of one or more fields from the record. Also known as primary key. Examples of primary keys could be ID number, part number, payroll number, etc."

The primary key field in each list is one field. The exception is the 'Subjects Enrolled' table.
This table is made up of two keys from other tables. Individual tuples in this table will be unique combinations of Student ID and Subject Code. This table is used as a link between the 'Students' table with the 'Subjects Offered' table because there is no other logical way of linking the data without creating redundant entries.

The large table beginning with Student ID and First Name contains foreign keys from the other tables. These foreign keys are Contact ID, Roll Code and House Code.

(Note ¡V Roll Code and Roll Class Code are the same attribute.
They have been incorrectly typed in the diagrams , but they must be the named same before the relationships can function correctly.)
Return to 123HelpMe.com