Free

Relational Database Design for Local College - Essay Example

Summary

In the "Relational Database Design for Local College" paper, the design principle in used to describe a database project for a local college using 3 key entities. This paper aims to show that the diagram reflects the true nature of how the database will be implemented. …

Download full paper File format: .doc, available for editing

GRAB THE BEST PAPER96.6% of users find it useful

Relational Database Design for Local College

Read Text Preview

Subject: Logic & Programming
Type: Essay
Level: Ph.D.
Pages: 1 (250 words)
Downloads: 2
Author: cbotsford

Extract of sample "Relational Database Design for Local College"

Logically, the first tables to be identified be Students, Instructors, and Courses tables. These are the tables in the 1st Normal Form.

These key tables contain attributes that describe the entities they represent. However, the design follows two more tables that do not represent any key attributes that are initially identified. Relative Database Design makes use of relationships that are implemented using foreign keys that originate from parent tables. This process; therefore, proves challenging to implement while still exercising referential integrity. The two extra tables make the design practical since the separation of the key entities is paramount (Churcher, 2012).

Modification of a key entity does not affect the other key entities. These two tables are the Students Allocation table and the Instructor Allocation table. Their abyrthe ibutes contain foreign keys for Students and Instructor tables, and they represent the action of ‘allocating’, which becomes entities. With these five tables the diagram; therefore becomes a practical database design for a local college within the identified scenario.

Cite this document

APA
MLA
CHICAGO

(“Intro to Relat Dbase Mgt Syst week1 Essay Example | Topics and Well Written Essays - 250 words”, n.d.)
Intro to Relat Dbase Mgt Syst week1 Essay Example | Topics and Well Written Essays - 250 words. Retrieved from https://studentshare.org/logic-programming/1659638-intro-to-relat-dbase-mgt-syst-week1

(Intro to Relat Dbase Mgt Syst Week1 Essay Example | Topics and Well Written Essays - 250 Words)
Intro to Relat Dbase Mgt Syst Week1 Essay Example | Topics and Well Written Essays - 250 Words. https://studentshare.org/logic-programming/1659638-intro-to-relat-dbase-mgt-syst-week1.

“Intro to Relat Dbase Mgt Syst Week1 Essay Example | Topics and Well Written Essays - 250 Words”, n.d. https://studentshare.org/logic-programming/1659638-intro-to-relat-dbase-mgt-syst-week1.

Cited: 0 times

CHECK THESE SAMPLES OF Relational Database Design for Local College

The Education Sector of Tanzania

INTRODUCTION AND DESCRIPTION OF THE FUNCTIONALITY OF THE MIS MODEL UNDER CREATION The education sector at Tanzania has historically faced numerous challenges, including the lack of basic infrastructure like electricity at local schools, and the in-availability of national funding to foster the educational management standards of these schools....

41 Pages (10250 words) Dissertation

Advanced Database Systems

A distributed database system facilitates other programs to access data from local and remote databases.... Additionally, all of these computers are connected with each other and every system has the capability to process the data individually thus helping local systems.... In this scenario, a distributed database system is developed on the basis of a design (normally called schema) that describes together the arrangement of the distributed data, as well as the relations between the data....

8 Pages (2000 words) Essay

Efficiency and Collaboration Proposal

Importance of Converting Data in Microsoft “Excel” Spreadsheets into a relational database Using Microsoft “Access” Spreadsheets in Microsoft Excel are used to collect information and user friendly.... While information is in the SharePoint list, it can be collected offline in a local Access database.... This allows local working with the data and later reconnecting to the SharePoint site.... Its design enables it compatible with other products from MS Office suite like Word or Excel because it uses VBA....

3 Pages (750 words) Essay

Reservation System for the Library

This PPR covers different topics, such as the scope and objectives of the project, database design and information analysis, methodology and approach, software/tools and modeling language.... This project will focus on the local library that does not have a database reservation system for the public to use in the library or which they can have access to at home.... This will be achieved by creating a simple reservation system for the local library by using Microsoft Access to produce a database....

11 Pages (2750 words) Term Paper

A Public Kiosk In Connection With The 2012 Olympics (Report)

Our company receives a stipend for design and development costs.... The kiosk I wish to provide for the 2012 Olympics in London is one that will help Visitors maneuver more efficiently through the grounds and arrive at their events on time.... ... ... ... The specific purpose of the kiosk will be to help visitors find the events the wish to see....

15 Pages (3750 words) Essay

The Software Requirement Document

The departments are connected using a local area network.... A practice Management System (PMS) is integrated with an electronic record management system and an electronic database to organize the data and this completes the loop of customer care within the health care system.... he practice management system (PMS) is composed of three main subcomponents which are a central database, a central server, and departmental interfaces.... The central database holds all the records from all departments....

7 Pages (1750 words) Essay

Database Management Systems

This case study "Database Management Systems" sheds some light on a relational database management system (RDBMS) that refers to a database system that consists of data element files arranged in two-dimensional arrays of columns and rows.... The database management system (DBMS) has the potential of recombining data elements to form various relations that enhance the flexibility of using data (Nichols 2007).... The database stores data physically using data files and logically using tablespaces....

12 Pages (3000 words) Case Study

Relational Database Management System Critique

The paper "relational database Management System Critique" focuses on discussing the alternatives of RDBMS and big data under the subtopics of volumes of data, types of data, data storage, and security.... database management system (DBMS) was introduced in the 1960s.... A decade later in the 1970s, the Rational database management system was introduced which out-shined the old DBMS for various reasons among them is the speed of queries.... An RDBMS database server has two sections: The database itself and the instance....

12 Pages (3000 words) Term Paper