MIS 140 Chapter 6 & Appendix C

How do we eliminate Many to Many relationships?

1. Create new Relation/ Table/ Entity 2. Create the new 1:M Relationships

Data Manipulation Tools: 1. __________ lets you to see the contents of a database file, make changes, perform simple sorting, and queries. 2. ____________ formats reports.

1. VIEW 2. REPORT GENERATOR Data Manipulation Tools: 1. *VIEW* lets you to see the contents of a database file, make changes, perform simple sorting, and queries. 2. *REPORT GENERATOR* formats reports.

Logical Ties Among the Information in a Database: 1. A Primary Key field in a database file that uniquely describes each record. 2. ______________

2. FOREIGN KEY Logical Ties Among the Information in a Database: 1. A Primary Key field in a database file that uniquely describes each record. 2. FOREIGN KEY is a primary key of one file that also appears in another file.

Data Manipulation Tools: 3. Query-By-Example (QBE) Tool - helps you graphically design the answer to a question. 4. _______________ is performed by creating a statement.

4. Structured Query Language (SQL) Data Manipulation Tools: 3. *Query-By-Example (QBE) Tool* - helps you graphically design the answer to a question. 4. *STRUCTURED QUERY LANGUAGE* is performed by creating a statement.

A Database has Two Parts: 1. _____________ 2. ______________

A Database has Two Parts: 1. the information 2. the logical structure of the information

A ___________ is the smallest piece of Information.

Answer: Character A CHARACTER is the smallest piece of information.

A ___________ is information from many databases.

Answer: Data Warehouse A DATA WAREHOUSE is information from many databases.

A _________ is a group of logically associated files.

Answer: Database A DATABASE is a group of logically associated files.

A ____________ is a group of related characters.

Answer: Field A FIELD is a group of related characters.

A ___________ is a group of related records.

Answer: File A FILE is a group of related records.

When building databases, the order of operations you would follow is: ____________ -> ____________ -> __________

Answer: Model, Implement, Use

The Structure of Information can be divided into the two categories: ___________ Information and ___________ Information.

Answer: Physical [Information] and Logical [Information] The Structure of Information can be divided into the two categories: PHYSICAL Information and LOGICAL Information.

A ____________ is a group of related fields.

Answer: Record A RECORD is a group of related fields.

1. Backup and recovery 2. Security management 3. Query optimization 4. Concurrency control ALL FALL UNDER WHICH Subsystem?

DATA ADMINISTRATION SUBSYSTEM 1. Backup and recovery 2. Security management 3. Query optimization 4. Concurrency control

Data Definition Subsystem helps you create and maintain the _________________. - Defines the logical structure. - Update new fields, delete fields, or change field properties.

DATA DICTIONARY Data Definition Subsystem helps you create and maintain the *DATA DICTIONARY*. - Defines the logical structure. - Update new fields, delete fields, or change field properties.

Information organized and accessed according to a logical structure is a ___________.

DATABASE Information organized and accessed according to a logical structure is a DATABASE.

The _______________ Subsystem allows you to add, change, and delete information in a database and mine it. -The primary user interface.

Data Manipulation The DATA MANIPULATION SUBSYSTEM allows you to add, change, and delete information in a database and mine it. -The primary user interface.

We want to __________ Many to Many Relationships.

ELIMINATE We want to __________ Many to Many Relationships.

Structured query language (SQL) is a standardized 4G query language.

Example: SELECT Part.[Part Number], Part.Cost, Part.[Facility Number] , Employee.[Employee Name], Employee.[Employee Number] FROM Part, Employee WHERE (((Part.Cost)>10));

How to Test Data Relationships: 1. Look at one instance of one entity's relationship with one instance of the other entity. 2. Look at it in the other direction 3. Combine the two relationships 4. Use an E-R Diagram

How to Test Data Relationships: 1. Look at one instance of one entity's relationship with one instance of the other entity. 2. Look at it in the other direction 3. Combine the two relationships 4. Use an E-R Diagram

A Record -which is a group of related fields- has contains a Row and __________.

Instance A Record -which is a group of related fields- has contains a Row and INSTANCE.

DBMS DBMS Subsystems: *Data definition* *Data manipulation* *Application generation* *Data administration* Allow the above go into the DBMS ENGINE which EXCHANGES with the Database (Information and & Data Dictionary)

LEARN

The Application Generation Subsystem 1. Tools for creating data entry screens. 2. Programming languages specific to a particular DBMS.

LEARN: The Application Generation Subsystem 1. Tools for creating data entry screens. 2. Programming languages specific to a particular DBMS.

______________ Is the process of assuring that a relational database structure can be implemented as a series of two dimensional tables.

NORMALIZATION *NORMALIZATION* Is the process of assuring that a relational database structure can be implemented as a series of two dimensional tables.

_____________ 1.Uniquely identifies each row in the table 2. Can be made up of more than one field 3. Can be arbitrary

PRIMARY KEY 1.Uniquely identifies each row in the table 2. Can be made up of more than one field 3. Can be arbitrary

A File -which is a group of related records-contains a Table, _________, and Entity Class.

Relation A File -which is a group of related records-contains a Table, Relation, and Entity Class.

The ___________________ 1. Accepts logical request from the DBMS subsystems. 2. Converts them to their physical equivalent. 3. Accesses the database and data dictionary.

The DBMS ENGINE 1. Accepts logical request from the DBMS subsystems. 2. Converts them to their physical equivalent. 3. Accesses the database and data dictionary.

The most popular database model, which uses a series of two-dimensional tables or files to store information is called __________. Within this model, each table is called a RELATION. and A relation contains information about a particular __________________.

The Relational Database Model The most popular database model, which uses a series of two-dimensional tables or files to store information is called *THE RELATIONAL DATABASE MODEL*. Within this model, each table is called a *RELATION*. A relation contains information about a particular *ENTITY CLASS*.

The three possible Data Relationships are: 1. _____ to _____ 2. _____ to _____ 3. _____ to _____

The three possible Data Relationships are: 1. *One* to *One* 2. *One* to *Many* 3. *Many* to *Many*