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)