Intro to Relat Dbase Mgt Syst week1 - Essay Example

Comments (0) Cite this document
In this paper, this design principle in used to describe a database project for a local college using 3 key entities (Churcher, 2012). Attached to this paper is the…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER92% of users find it useful
Intro to Relat Dbase Mgt Syst week1
Read TextPreview

Extract of sample "Intro to Relat Dbase Mgt Syst week1"

Relational Database Design for Local College Relational Database Design for Local College Rational Database Design enables entities in the database to be linked to each other through relationships. In this paper, this design principle in used to describe a database project for a local college using 3 key entities (Churcher, 2012). Attached to this paper is the database design drawn using Microsoft Visio. This paper aims to show that the diagram reflects the true nature of how the database will be implemented.
For an educational institution such as a college, we must first identify the key entities within the institution and translate them to tables. These include entities such as students, lecturers, courses, lecture halls, faculties and perhaps dormitories. For this project the key entities under consideration are the students, instructors, and courses. Therefore, it is logical that 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 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 Students Allocation table and Instructor Allocation tables. Their attributes 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.
Churcher, C. (2012). Beginning database design: From novice to professional. New York: Apress. Read More
Cite this document
  • APA
  • MLA
(“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
(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.
“Intro to Relat Dbase Mgt Syst Week1 Essay Example | Topics and Well Written Essays - 250 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Intro to Relat Dbase Mgt Syst week1

Histroy week1

..., the letter “P” stands for people, individuals or group; in this case, this element focuses on exploring issues regarding people such as presidents or ant-war protesters. The other element is “I” that represents institution, either private or public; in this case, this refers to government, churches or families. “E” as an element represents events, which occurred once or continuous; for instance, this could refer to events such as war or protest movements. The letter “R” represents the element that focuses on studying relationships among people and institutions, thereby seeking understanding of the way they behave or interact. Lastly, the element “V” focuses on exploring public or personal values; this case, this relates...
5 Pages(1250 words)Assignment


...Week1 Can you think of any decisions that had undesirable outcomes due to incorrect, incomplete, or insufficient research? The decision based on the per-household sharing of money from the government’s side seems to fall way below the expected results of a regime that is geared towards equal sharing of wealth. The reason for this is that the government does not know the exact number of people which reside within a country or a city for that matter and this raises problems for the government functionaries at all the levels possible. The best step that could be taken by the government machinery is to have an in-depth research into how the sharing needs to be done, which could only be possible if the government knows what...
3 Pages(750 words)Essay

Intro MGT Informat Systems

... Introduction to Management Information Systems Project management focuses on long term objectives of the company with several phases existing in the process of implementation. The implementation of project management process involves the use of several phases. Chapter two addresses the issues of project management by highlighting the various phases of management exist in project implementation. The project initiation stage involves the identification of the ideas and projects to be evaluated and the methodology. Identification of ideas and scope of the project is vital in the initiation process. The clients need in the project must be evaluated to avoid mismatch of wants and need of the clients. Despite proper planning... Introduction to...
2 Pages(500 words)Essay

Week1 be described as strong, ambitious, smart and just. Jason belongs to aristocratic class of his society. He is not depicted as a worker. He is a young warrior and a monarch who deserve respect of his community. Jason and The Argonauts film is based on the Greek myth about the Jason, his team and the quest to get the Golden Fleece. Obviously, the film does not offer a clear representation of the myth. It is altered by scenarists and producer to keep it engaging for modern audience. The story takes place in Greece and involves famous Greek mythic characters such as Medea. However, Greek gods are represented as ordinary people who have developed skills related to their professions. Epic qualities in the film are placed on...
2 Pages(500 words)Essay

Question Week1

...Question Week1 What I find most useful about the labels is the actuality that the labels will include scientific information that clearly explains the link between the diet and the involved chronic infections (U.S. Food and Drug Administration 1). This will help the consumers select the foods and servings that are most appropriate for them as opposed to before. Just as the News indicates, consumers will make better food choices (U.S. Food and Drug Administration 1). 2. What I find confusing is the amount of portions that are required in the foods. As Wilson & Christensen indicate specific portions of vitamins, calories and minerals will be indicated in the product labels (1). In the occasion that one is not certain of...
1 Pages(250 words)Admission/Application Essay

Intro to Rel Dbase Mgts Syst

...Yours Teacher’s 29th October, Introduction to Relational Database Management System Normalization and Redundancy" Please respond to the following Question number 1: Response 1: Data inconsistency is one the main problem that exists in different versions of the same data, which appears in different places. For example, a sales company’s sales department stores the name of a salesman as Bill Brown while same name in personnel department is saved as William G brown, the probability of data inconsistency increases in similar cases. Price of the product is shown as $45.50 in the sales office while product of the same product is displayed as $43.90 in another department. Response 2: Normalization provides faster way to search...
2 Pages(500 words)Assignment

Intro to Relat Dbase

...INTRODUCTION TO RELATIONAL DATABASE Introduction to Relational Database Affiliation Normalization “Basically, the normalization is the process of decomposing large, inefficiently structured tables into smaller, more efficiently structured tables without losing any data in this process” (Hernandez, 2003) Step for converting database tables into First Normal From 1st normal Form A relation is believed to be in 1st normal form if it does not contain any repeating group, the value in each attribute should be atomic, and every tuple should be unique (SQA, 2014): Steps performed in 1st Normal Form Eliminate the repeating groups. Form a new entity Example Dept_no Dept_name student_no student_name 10 IT S01 James 20 SE S02 S03 Bill David... This...
2 Pages(500 words)Assignment

Intro to Mgt Syst

...Ethical Issues in Information Systems YourFirst YourLast Information or data privacy is an ethical issue in information systems that refer to the aspect of protecting an individual’s personal information. Lucey (2005) notes that there is need to protect personal information such as financial data, medical records, political record, criminal records, website data, and business related information from access by unauthorized persons who may be ill-motivated. I believe that it is important to protect personal information of a person because vulnerabilities of personal information have significantly increased with the advancement of the digital age. By instituting privacy policies in information systems, organizations can...
2 Pages(500 words)Assignment

Week 7 assignment: Intro to Mgnt If syst

.... Cost The cost of the system is a key factor in making building or renting a system. The choice taken must be cost effective for the firm. For instance, the firm will consider the costs of building a system and the costs of buying a system and make a decision based on the cheaper option in the long run. During the analysis of the cost, the company should consider the aggregate spending needed for the system’s lifetime and also other factors that may vary from time to time. Rationale: The above factors are critical since they are directly related to the business. A business needs a cost effective system that will provide cutting edge technology to differentiate it from its competitors. 2. Supply chain management a....
2 Pages(500 words)Assignment


...Psychology Introduction Ethics can be defined as the accepted of conduct with relation to a particular profession. Ethics can also be defined as the laws of morality relating to a particular job. The American psychological association has set down its ethical code of conduct while drawing relevance to psychologists who involve animals in their research. These ethical are in relation to proper acquisition, care, use and disposal in a professional and ethical way while observing the different legal laws set down (American Psychological Organisation (2003).  The main advantages of using animals as specimen in research include: the similarity between animals and humans makes them easy to get...
1 Pages(250 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 Essay on topic Intro to Relat Dbase Mgt Syst week1 for FREE!

Contact Us