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
In order to get specific access instructions for any particular time slot reserved by a student, the following procedure is used:
Future Accessibility Plans. Upon completion of the web integration project, using the simpler Student issues database as a test bed, modifications will be researched to provide bi-directional web access to the databases.
Oracle's relational databases represent a new and exciting database technology and philosophy on campus. As the Oracle development projects continue to impact on University applications, more and more users will realize the power and capabilities of relational database technology.
This system will be based on making choices for the support system. It can be used by manger and senior in a business and they will get information about how the business how it operate and they can see and manage how efficient a company like John Lewis is
...takes to set up information in the system. The level of understanding would improve through partaking or getting involved and henceforth could be adapted easily. All the bits and pieces of the project would rapidly increase or grow as per the workflow process. At the end, the overall CPOE system should be able to compare the manual method with the new electronic system and tell which is best and accurate to use and also tell how much time and money will be saved when using either system. At the end of the project the team should be able to come together and discuss whether or not the project met all of the company’s needs such as if it is reliable, efficient, safe and secure and also does it save time and money. Then, if the system has more advantages than disadvantages and it is worth all of the team’s time and effort it would be best to continue with the project.
Looking at the different data storage models, this is the most simple to implement. This is a way to have a schema-less design for storing data. In essence, the store will act as a large hash table that is separated into keys and values (Data Access ref). To the DBMS, the values are opaque – a random assortment of 1’s and 0’s – and the application sitting on top of the database will then translate the binary to useful information. Hash functions are then used to determine where the values will be physically stored.
A student who wants to be successful in this course needs to remember to come prepared every day to class, to be organized,
The first database systems were based on the network and hierarchical models. A database can be defined as a collection of non-redundant data which can be shared by different application systems. A database implies separation of physical storage from use of the data by an application program to achieve program/data independence. Using a database system, the user or programmer or application specialist need not know the details of how the data are stored and such details are usually "transparent" to the user. .
The subject data which is being used by the faculty and enrolled students should be available any time for use and the faculty and the students are educated to access the updated subject data at any point of the time.
Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.
The database application design can be improved in a number of ways as described below:
In order to access information from a database, it is required to have a database management system (DBMS). These systems are computer software applications that, in order to analyze the data, interact with the user and the database itself. The best known are [6]:
The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources.
There are three types of Database Management System which are the relational Database Management System, the non-relational Database Management System and Object Oriented Database Management System. The relational DBMS is the most widely accepted Database Management System nowadays. The non-relational DBMS that are in large scale are still in use while the Object Oriented DBMSs are in development. Besides, more and more DBMSs are supporting basic multimedia storage and retrieval facilities.
In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.