Assignment 3: Understanding The Basics Of Databases

945 words - 4 pages

Assignment 3: Understanding the Basics of Databases
School University
CIS 106 – Introduction to Information Technology
Professor
Date

Understanding the Basics of Databases
Databases are used to organize a collection of data, allowing for easy access, retrieval, and use of information. The first databases were slow at processing information and inconsistent when applications would require the same information, but kept in different files. Relational databases, normalization, and Structured Query Language have improved the efficiency of databases. To be a proficient database programmer, one should have a basic understanding of rational databases, normalization, Structured Query ...view middle of the document...

By reducing redundancy, the data is simplified and uses less disc space. When a database is normalized, it is broken into smaller tables, making it easier to modify. It takes less effort to make changes to a small table with little data than it does to change a massive table with all of the database data. Even the largest databases had to start from a basic concept before developed into a physical database.
Database Models
When creating a database, there are three data models produced while progressing from basic requirements to the actual database. These database models are the conceptual, logical, and physical (West, 2011). The conceptual data model is an abstract and basically a map of concepts and their relationships used for databases. The conceptual model focuses on what data is required and how it should be organized - what tables should exist, and the connections between them. In this phase entities are recognized, and the relationships between them. The conceptual model is then translated into a logical data model.
The logical database model is when the table columns in each table are explicitly defined. “Logical database design develops a conceptual model of the database from a set of user requirements and refines that model into normalized SQL tables” (Lightstone, Teorey & Nadeau, 2007). Normalization occurs at this level in order to reduce redundancy and improve performance. In as much detail as possible, a logical data model describes the data without any concern of how it will be physical implemented.
The physical data model is the last step in data modeling and is the physical structure of the database, how the model will be built. It is the lowest level of abstraction. The physical model organizes data into tables, access to accounts, performance and storage details (West, 2011). The purpose of the physical design is to maximize the performance of the database. To access and manage databases, a standard language was developed, called Structured Query Language (SQL) (Agarwal & Huddleston, 2008).
Structured Query Language
Structured...

Other Papers Like Assignment 3: Understanding the Basics of Databases

The 3 Es Of Om Essay

5180 words - 21 pages improvements) as it is about changing the culture of the organization to focus on opportunities for improvement rather than problems. At the other extreme, there is the Business Process Reengineering which advocates starting from a clean slate with a quantum leaps. Whatever techniques/methods is used it relative the pulse of an organisation. Your objectives In this chapter you will learn about the following: * Understand the 3 Es of

The 3 Es Of Om Essay

5235 words - 21 pages improvements) as it is about changing the culture of the organization to focus on opportunities for improvement rather than problems. At the other extreme, there is the Business Process Reengineering which advocates starting from a clean slate with a quantum leaps. Whatever techniques/methods is used it relative the pulse of an organisation. Your objectives In this chapter you will learn about the following: * Understand the 3 Es of

Explore Priestley's Dramatic Methods in Act 3 Pages 50 – 56 Demonstrating How an Understanding of the Historical and Social Context of the Play Might Help Shape the Audience Response to This Scene and...

1054 words - 5 pages Explore Priestley’s dramatic methods in Act 3 pages 50 – 56 demonstrating how an understanding of the historical and social context of the play might help shape the audience response to this scene and the play as a whole. Throughout An Inspector Calls, Priestley uses the Inspector as a way of warning the audience to address many problems that are occurring, or have occurred in society. The fact that the play is set in 1912, and written in

Understanding the Principles and Practice of Assessment

4641 words - 19 pages 1. Understanding the Principles and Practices of Assessment 2.1. Explain the functions of assessment in learning and development Assessment is a judgement on a learner’s performance and knowledge against criteria set by the awarding body. It is used to measure and record a learner’s level of knowledge and skills and gives feedback on their performance. It also allows the employer to determine whether the learner is able to meet the

Understanding the Organisational Purposes of Businesses

2118 words - 9 pages ). Explain the responsibilities of an organisation and strategies employed to meet them Stakeholders analysis is used to factor in the interest of the main stakeholders in the matter concerned. To successfully implement new strategies or projects, the organisation needs to have the support and understanding of the involved parties. In order to minimise as much as possible resistance, the stakeholders need to feel the ownership of the project and

Understanding The Role Of Christ In Counseling

1906 words - 8 pages Understanding the role of Christ in Christian Counseling and Some Ways to Implement Him in Your Practice Abstract In this paper it is the student’s desire to discuss a few points regarding the importance of implementing Christ into Christian Counseling including some of the ways that this can be done. He is going to note the difference between mental illness and spiritual bondage/oppression. He is also going to cover habitual sin more

Understanding the Effects of Global Warming

2892 words - 12 pages UNDERSTANDING THE EFFECTS AND PROVIDING A USEFUL SOLUTION REGARDING GLOBAL WARMING IN CONNECTION TO GAS LAWS A Term Paper Regarding Issues and Concerns about Gas Laws Louie Alison Bernal III- Boyle I. Introduction Background of the Study Global warming refers to an unequivocal and continuing rise in the average temperature of Earth's climate system

A New Understanding of the Self

532 words - 3 pages Formal Essay 2:  500 words: “A new understanding of the self influences the child's every thought and emotion from that day forth. Truly she sees the world through different eyes, from a different perspective, with somewhat less of the innocence of her earlier years." - Jay David I remember the exact moment that I knew, the moment that it became clear; although there were no words exchanged, it left no doubt in my five-year old mind

Understanding the Situation of Kudler Fine Foods

522 words - 3 pages Kudler Fine Foods will modify the model to make it profitable and create a management team to operate effectively at optimum efficiency by allowing the team members to develop and enhance skills in their specialty area. Issues In view of the fact that Kathy determined to use the same model for all the 3 stores the following are some opportunities that the organization is facing: Kathy started out without a Strategic Plan, which was

Assignment 3: Leadership Style: How Are Leaders Leading in the 21st

1971 words - 8 pages Assignment 2: Integrating Culture and Diversity in Decision Making: The CEO and Organizational Culture Profile BUS 520 – Leadership and Organization Dr. Danielle Camacho Tomika Williams Provide a brief (one [1] paragraph) description of the organization you chose to research. I chose to research Southwest because living in Atlanta, Georgia I’ve personally waited for the discount airline to land on our doorstep and they did just that with

1.1 Understanding the Principles and Practice of Assessment

5093 words - 21 pages they are being assessed as equal to each other, according to the examining body. • The importance of transparency for the learner To ensure transparency you need to ensure that everyone involved with the assessment process has a clear understanding of what is expected. As a assessor you should always be honest with your learner and ensure that you don’t make the learner feel they have achieved more then they are capable of. 3. Explain the

Related Essays

The Basics Of Computer Hardware Essay

1923 words - 8 pages Basics of computer hardware The Basics of Computer Hardware By: Stephen Lomangino Dr. Fahey ITT-Technical Institute: College of Information Technology Abstract This paper identifies the many different parts a computer needs to operate and perform basic tasks. Among these are the motherboard, central processing unit (CPU), and random access memory (RAM). While these components are somewhat mandatory

Assignment 3 Market Model Patterns Of Change

1559 words - 7 pages Assignment 3 Market Model Patterns of Change Professor Koros Strayer University The Industry and General Pattern of Change Of Market Model The fast paced industry surrounding health insurance in the United States has experienced rapid growth. There are numerous providers representing a competitive marketplace where no single entity rules over prices. However, the industry is undergoing massive transformation processes and slowly evolving

How Does Shakespeare Develop The Audience’s Understanding Of Juliet’s Character And Her Predicament In Act 3 Scene 5?

1118 words - 5 pages How does Shakespeare develop the audience’s understanding of Juliet’s character and her predicament in Act 3 Scene 5? At the start of III v when Juliet is talking to Romeo, Shakespeare shows their relationship with the use of natural imagery. For example he makes references to birds such as “Lark” and “Nightingale”. Shakespeare also uses natural locations such as “pomegranate tree” and “misty mountain tops”. The use of natural images is a

Understanding The Role Of Culture Essay

561 words - 3 pages 7/23/2013 Case Study # 1 Week 2 Understanding the role of culture Culture can be a combination, of rules, beliefs, techniques, artifacts, language, and religion, when these things come together it influence the human mind. With influence of culture in the human mind, it impacts the way business is conducted. We then look into corporate culture, which is what defines how managers and employees conduct themselves in the workplace of