Database Design - 1119 Words

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†¦show more content†¦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. TheShow MoreRelatedThe Development And Design Of A Database1429 Words   |  6 PagesABSTRACT The use of agile in database development has grown over the years with the goal of improving the quality of the final product. This, however, has not always been the case. The development and design of a database doesn’t follow simple or single approach; it connects multiple processes and individuals who collectively play key roles in the process. In some instances, database development using agile methods engage in rushed deployments, neglecting the importance of testing. There are dailyRead MoreDatabase Analysis : Database Design Essay861 Words   |  4 PagesAdditional Elements Database is defined as â€Å"the collection of information organized in such way that a computer program can quickly select the desired pieces of data.† (Haithcoat, n.d.). In today’s technological world most of the processes is automated where database plays an important role to manage the data across a system. A database can be considered as an electronic filing system. Traditional databases are organized by fields, records, and files. A field is a single element of information;Read MoreDatabase Design Development2919 Words   |  12 PagesMODULE: DATABASE DESIGN DEVELOPMENT ASSIGNMENT TITLE: VETERINARY SURGERY DATABASE DEVELOPMENT Table of Content Task 1 Page 2 Task 2 Page 5 Task 3 Page 14 Task 4 Page 28 Task 5 Page 30 Reference Page 32 Bibliography Page 33 Task 1 Question: AIM: Draw an Entity Relationship Data Model that describes the content and structure of the data held by Petcare. Specify the cardinality ratio and participation constraint of each relationship type. Answer: I have prepared this assignmentRead MoreDatabase Design and Implementation38677 Words   |  155 PagesPhyloInformatics 7: 1-66 - 2005 Relational Database Design and Implementation for Biodiversity Informatics Paul J. Morris The Academy of Natural Sciences 1900 Ben Franklin Parkway, Philadelphia, PA 19103 USA Received: 28 October 2004 - Accepted: 19 January 2005 Abstract The complexity of natural history collection information and similar information within the scope of biodiversity informatics poses significant challenges for effective long term stewardship of that information in electronicRead MoreDatabase Design Concept1054 Words   |  5 PagesApply the database development cycle to a given data set Database development creates enterprise data modeling, which forms the range and wide-ranging contents of organizational databases. There are 5 phases in Database Development Cycle: Planning; Analysis; Design; Implementation and Maintenance. Planning In Planning Stage, the organization needs to know why do they need the database; what do they want the database to do; and how are they going to make the database. This is also where theRead MoreEssay on Database design process906 Words   |  4 PagesAbstract 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 its 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 ProcessRead MoreDatabase And Internet Application Design3116 Words   |  13 Pages Robert McMenemy - 1204628 CE0931G Database and Internet Application Design 1. Table Of Contents 1. Table Of Contents...............................................................2 2. Overview............................................................................3 3. Initial Analysis Of Database and Website Structure...............4 3.1. Overview Of Database Semantics.........................................5 3.2. What Must The New System Achieve........................Read MoreBasic Database Design Concepts2587 Words   |  11 PagesThe Fundamentals of Database Design To end up with a good ‘relational database’ application, you need to ask: Do I actually need one? If so, how far do you want to take it? By this I mean, is this to be a simple database to store information about only one, or very few, related entities (i.e. a list of people who attended a certain event, and how they came to hear about the event) which are not likely to change; or a permanent and well used application with several different entities (i.e.Read MoreIt 650 Principle Of Database Designs5259 Words   |  22 Pages IT 650 Principle of database designs Srikanth Karra Southern New Hampshire University. â€Æ' Introduction: Westlake research hospital is a drug research organization and hospital as well. This hospital cum research organization has its core business of its own test called double blind of a new depression drug. This organization has 420+ users including doctors, researchers, pharmacists and patients. Depending on the test result patient get new or traditional drug and the treatment lasts about 18Read MoreDatabase Design, Implementation, and Management2233 Words   |  9 PagesABSTRACT Database Design, Implementation, and Management — Gymnasium Database System As the world entering into a digital era, most of organizations use different kinds of database environment to achieve efficient management. A suitable database management system provides a set of tools for an organization to efficiently track and manage its data. The development of a database follows a database application lifecycle. It is a rather long process and requires a considerable