ACC 409 exam 2 correctly answered to
pass[verified]
entity-integrity rule - correct answer ✔✔helps reduce data duplications
1. all tables must have a primary key
2. all primary keys must have unique values
3. primary keys cannot be black (null)
how are database organized? - correct answer ✔✔relational database
Relational database - correct answer ✔✔collection of inter-related files that stores info in an efficient
manner
-every file in the collection shares at least one field in common directly or indirectly with every other file
relational databases are usually organized with.... - correct answer ✔✔entity, attributes, occurrences
entity - correct answer ✔✔item of interest about which an org would like to collect info, entities an be
physical, like inventories and vendors (table)
attributes - correct answer ✔✔data elements that define an entity, such as a customer ID code, name
and address
Occurrences - correct answer ✔✔used to describe the number of instances or records that pertain to
the particular entity of interest
Referential integrity rule - correct answer ✔✔focused on the relationship between two tables to
maintain the integrity of the data. Thus the use of primary key from table would be considered foreign
key in the related table
1. maintain consistency in data
pass[verified]
entity-integrity rule - correct answer ✔✔helps reduce data duplications
1. all tables must have a primary key
2. all primary keys must have unique values
3. primary keys cannot be black (null)
how are database organized? - correct answer ✔✔relational database
Relational database - correct answer ✔✔collection of inter-related files that stores info in an efficient
manner
-every file in the collection shares at least one field in common directly or indirectly with every other file
relational databases are usually organized with.... - correct answer ✔✔entity, attributes, occurrences
entity - correct answer ✔✔item of interest about which an org would like to collect info, entities an be
physical, like inventories and vendors (table)
attributes - correct answer ✔✔data elements that define an entity, such as a customer ID code, name
and address
Occurrences - correct answer ✔✔used to describe the number of instances or records that pertain to
the particular entity of interest
Referential integrity rule - correct answer ✔✔focused on the relationship between two tables to
maintain the integrity of the data. Thus the use of primary key from table would be considered foreign
key in the related table
1. maintain consistency in data
