MIS Exam 1

What Is a NoSQL DBMS? -NOSQL DBMS (NotRelational DBMS): Supports very high transaction rates Relatively simple data structures Replicated on many servers in the cloud

(slide 53)

The five components of an Information System are:

Hardware, Software, Data, Procedures, People

steps in creating relational database: 1. have a purpose 2. what objects are needed to carry out purpose (tables) 3. what details about the objects are necessary (fields) 4. the field that will be primary key 5. Data type and size of field 6. requirements and restrictions for fields (leads to data integrity) 7. relate different tables with foreign key

pg.5 inputmask

A Query finds data in your database by implying asking 1 question. Use them to find and analyze data.

true

A primary key is a field that contains a unique value for each record.

true

A query is used to find data in a database.

true

Access is a relational database, which means that the data are organized into a colection of related tables.

true

And conditions only uses one row, the criteria row. The row below the criteria is the Or row. multiple field compound or see pg. 1 Queries and...or

true

Datasheet view is used to enter data records into a table.

true

Field size is a property that determines the max number of characters allowed in a short text field or number field. (ex: long integer, double, integer)

true

In Access, the primary object of a database is called a table.

true

Lookup field (pg. 9 design_valid chp. 2) are a list of data values from which the user can choose. these are also a way to use range integrity rules.

true

Relational databases is organized into a collection of related tables. ( pg. 4 InputMask) The tables are connected or related through common fields. Create these and view them in relationship windows.

true

Run button must be pressed in order to see query results. Then change from design to datasheet view in order see the records (new rows of specific data).

true

The format property controls the way the fields display in the datasheet view. (ex: 9/27/16 or September 27, 2016)

true

Use design view to change data table properties. Datasheet view and design view are used to create tables.

true

foreign key is the primary key that is dragged into the related table (pg. 4 right side) ; foreign key creates the relationship between tables (entities)

true

* represents any number of characters, ? reps 1 single character, and # represents any single number

true ( pg. 1 parameters)

Default Value is a property that controls the format of short text and long text data.

true (pg. 5 design_valid..)

The process of verifying accuracy or integrity is called data validation. format, range, consistency, completeness

true (pg. 6 design_valid) chp. 2

Relational Data: Collection of related files containing records: people, places, or things; shows relationships between entities An Entity is a Table! Attributes are the fields

true (slide 15, 16 4.0_Database ppt)