o All of the value is inappropriate the value is appropriate but unknown or the

O all of the value is inappropriate the value is

This preview shows page 52 - 55 out of 73 pages.

o All of the value is inappropriate, the value is appropriate but unknown or the value is appropriate and known, but not entered into the database are correct Question 58 - Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated o True
Image of page 52
Question 59 - An inconsistent values problem is created when different users have coded the same data entries differently o True Question 60 - Null values are a problem because they are ambiguous o True MIDTERM REVIEW Chapter 1 Introduction Characteristics of Databases - Help people track things of interest in databases - Data stored in tables with reach row and column like a spread sheet - Each row in a table is an occurrence or “instance” - Database stores data and relationships Naming Conventions - Table Names are all written in capital letters (ex. STUDENT) - Column names are written normally without space (ex. StudentName) Databases Create Information - Data records facts and figures - Information is knowledge from data Components of a Database System - User Database Application SQL DBMS Database o Applications are the computer programs you use to work with o DBMS creates, processes, and administers databases Create database Create tables Create supporting structures (indexes) Modify (insert, update, delete) database data Enforce rules o SQL is the standard that is used in DBMS Microsoft Access - Low-end product that attempts to hide much of the technology from the user - BDMS plus application generator Three Types of Database Design. - From existing data o Analyze spreadsheets and extra data and design it using normalization - New systems development o Create data model from application requirements transform data into database design
Image of page 53
- Database redesign o Migrate databases to newer databases. Reverse engineer and design new using normalization The Relational Database Model - All current major DBMS products are based on it - E.F. Codd (in case this is a bonus question like last year) - Based on mathematics called relational algebra CHAP 1 SUM Microsoft Access - How Do I Crate a New Microsoft Access Database o Open Access 2013 Blank desktop database template - How Do I Open an Existing Microsoft Access Database o Access 2013 Recent [name].accdb - How Do I Create Microsoft Access Database Tables o CREATE Table Design Table Tools Design Have at ‘er - Setting the Primary Key o Row selector column click Primary Key button - How Do I Create Relationships Between Tables o Database Tools Relationships Choose which tables you want drag column name into the other table - How Do I Create and Run Microsoft Access 2013 Queries o Create Query Design ! Chapter 2. Introduction to SQL SQL DDL, DML, and SQL/PSM - Data Definition Language (DDR) o Used for creating tables, relationships, and other structures. Defines things - Data manipulation language (DML) o Used for queries and data modification. It manipulates data - SQL/Persistent Stored Modules (SQL/PSM) o
Image of page 54
Image of page 55

You've reached the end of your free preview.

Want to read all 73 pages?

  • Fall '16

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture