Preview

CIS Database Notes

Powerful Essays
Open Document
Open Document
7764 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
CIS Database Notes
Introduction to Databases
BDS: Connolly, Begg, Holowczak
Pratt/Adamski
Elmasri/Navathe (3rded.)
Kroenke Book (7thed.)
McFadden (5thed.)
Mata-Toledo / Cushman
Ch. 1 and 2
Ch. 1
Ch. 1 and 2
Chap. 1 and 2
Chap. 1
Schaum's Outlines Ch. 1
Q: What is a Database ?
Answer from BDS: A shared collection of logically related data and descriptions of that data, designed to meet the needs of na organization.
Answer from Elmasri/Navathe:
A Database (DB) is collection of related data - with the following properties:
1. A DB is logically coherent and has some relevant meaning
2. A DB is designed, built and populated with data for a specific purpose
3. A DB represents some aspect of the real world.
We can also say that the database is a model of what the users perceive.
Three main categories of models:
User or Conceptual Models: How users perceive the world and/or the business.
Logical Models: Represent the logic of how a a business operates. For example, the relationship between different entities and the flow of data through the organization. Based on the User's model.
Physical Models: Represent how the database is actually implemented on a computer system. This is based on the logical model.
Database Management System (DBMS)
A Software system that enables users to define, create and maintain the database and provides controlled access to the database.
 Database System (DBS) contains:
The Database +
The DBMS +
Application Programs (what users interact with)

Note: We will explore how the application, DBMS and database are distributed in the Database System Architecutres module later in the semester.
File Systems
File System: A collection of individual files accessed by applications programs
Limitations of a File System:
Separated and Isolated Data - Makes coordinating, assimilating and representing data difficult
Data Duplication - Wastes space and can lead to data integrity (inconsistency) problems
Application Program Dependencies

You May Also Find These Documents Helpful

  • Satisfactory Essays

    A database is a computer mechanism for storing and retrieving data. It gives one true command of their data, enabling one to retrieve it, sort it, analyze it, summarize it, and report results in changes.…

    • 598 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    4. Building the physical database: The database model will be constructed into the actual database program.…

    • 358 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Better Essays

    Database Design

    • 1196 Words
    • 5 Pages

    The database architecture a set of specific rules, processes, and specifications that dictate how data is accessed by components of the system and how this data is stored in the database.” (wingenious.com)…

    • 1196 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database consists of one or more tables; each containing data stored as individual records. Different database architectures determine how the tables and records are organized or related…

    • 885 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Models are conceptual constructs that aspire to represent real things or processes that to a large extent are hidden for the senses and to the ordinary experience. Models have a role to describe, represent, explain, and ‘translate’ the world.…

    • 440 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    Answer: A database is a model of how the users view their business world. This means that the users are the final judges as to what data the database should contain and how the records in that database should be related to one another. The easiest time to change the database structure is during the data modeling stage. So the user should be actively involved in the modeling process. The user review of a data model is crucial. When a database is developed, the user must carefully review the data model.…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Good Essays

    2. The database engine: the software that makes it possible to access and modify the contents of the database.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays
  • Good Essays

    Logic Models

    • 1480 Words
    • 6 Pages

    Logic models are typically diagrams, flow sheets, or some other type of visual schematic that conveys relationships between contextual factors and programmatic inputs, processes, and outcomes. Logic models can come in all shapes and sizes: boxes with connecting lines that are read from left to right (or top to bottom); circular loops with arrows going in or out; or other visual metaphors and devices. What these schemata have in common are they attempt to show the links in a chain of reasoning about "what causes what," in relationship to the desired outcome or goal. The desired outcome or goal is usually shown as the last link in the model.…

    • 1480 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Database Design Paper

    • 429 Words
    • 2 Pages

    A database system is a computer term for a structured set of data that can be saved, retrieved, added to or deleted from relatively easy. There are a variety of different databases and the type of database will determine how the data is arranged when it is stored and how that data will be located when it is called upon.…

    • 429 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Week 3

    • 754 Words
    • 4 Pages

    6. The type of logical database model that treats data as if they were stored in two-dimensional tables is the (Points : 1)…

    • 754 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Concept of Dbms

    • 1140 Words
    • 5 Pages

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships among the entities.…

    • 1140 Words
    • 5 Pages
    Powerful Essays
  • Better Essays

    Relational Databases

    • 4830 Words
    • 20 Pages

    Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in the system and the application programs that use the data. As shown in Figure 4.4, this allows users to separate the way they view the data (called the logical view) from the way the data is actually stored (the physical view). The DBMS interprets the users ' requests and retrieves, manipulates, or stores the data as needed. The two distinct views separate the applications from the physical information, providing increased flexibility in applications, improved data security, and ease of use.…

    • 4830 Words
    • 20 Pages
    Better Essays
  • Satisfactory Essays

    What is a database: A database is a group of data that has been organised in a table or group. This makes it easy to find data, but also allows you to not have any duplicates in a group. A database is used in a school or college to store students date of births. This allows the school to be able to see how old the students are. The database can also be password protected to keep the data safe.…

    • 557 Words
    • 3 Pages
    Satisfactory Essays