INFS 346 FINAL – JUKIC EXAM QUESTIONS WITH VERIFIED SOLUTIONS GRADED A+
DBMS (database management system) - Answers creates, reads, updates, and deletes data in a
database while controlling access and security
Database system - Answers enables efficient interaction between end-users and the
information captured in a database
conceptual database model - Answers ER modeling - visual modeling of database structure
logical database model - Answers Relational schema - includes cardinality constraints,
relationships, and entities
Database use - Answers insertion, modification, deletion, and retrieval of data
What are the steps to implementing a database? - Answers requirements, modeling,
implementation, & deployment
database analyst - Answers a person who is responsible for defining and visualizing data
database designer - Answers database modelers or architects
database developers - Answers responsible for implementing the database and making it
functional with DBMS
front-end application analysts - Answers in charge of collecting and defining requirements for
front-end applications
front end applications developers - Answers in charge of creating the front-end applications
ER Modeling - Answers conceptual database modeling technique
ERD - Answers the result of ER modeling
relationship instances - Answers occurrences of a relationship
relationship attributes - Answers attributes of a relationship and not an entity (M:N)
composite attribute - Answers attribute thats comprised of multiple parts (address)
How is a composite attribute represented? - Answers it is in parentheses
How is a composite unique attribute represented? - Answers it is underlined and in parentheses
multivalued attribute - Answers attribute that can have more than one value (phone number)
How is a multivalued attribute represented? - Answers it has double circles
What is a derived attribute? - Answers attribute whose values are calculated and not
, permanently stored in a database
How are derived attributes represented? - Answers They are in a dashed circle
How do you represent an optional attribute? - Answers (o)
How are exact minimum and maximum cardinalities represented? - Answers they are written in
parentheses underneath the cardinality
binary relationship - Answers relationship with two entities
unary relationship - Answers relationship with one entity
weak entity - Answers does not have a unique attribute of its own
owner entity - Answers entity whose unique attribute helps identify a weak entity (no primary key)
How do you represent an identifying relationship? - Answers double circle the relationship and
the entity with the partial key
partial keys are represented in what way? - Answers dashed underline
What are associative entities? - Answers An alternate way of depicting M:N relationships
How are associative entities represented? - Answers a box around the diamond
what is a ternary relationship? - Answers three entities
What is required in a relational table? - Answers Each column must have a name (within one
table, each column name must be unique)
Within one table, each row must be unique
How do you map composite attributes? - Answers Each component is mapped as a separate
column
How do you represent a composite primary key in a relational schema? - Answers Both
components are underlined
Entity Integrity Constraint - Answers Primary keys can't be optional.
In a relational schema, lines point from _____key to ___key - Answers foreign key to primary key
When mapping relationships that have a many. . . - Answers the primary key from the 1 side
becomes the foreign key is placed on the many side
when mapping many to many relationships . . . - Answers a new table is formed where each
primary key forms a new composite foreign key
DBMS (database management system) - Answers creates, reads, updates, and deletes data in a
database while controlling access and security
Database system - Answers enables efficient interaction between end-users and the
information captured in a database
conceptual database model - Answers ER modeling - visual modeling of database structure
logical database model - Answers Relational schema - includes cardinality constraints,
relationships, and entities
Database use - Answers insertion, modification, deletion, and retrieval of data
What are the steps to implementing a database? - Answers requirements, modeling,
implementation, & deployment
database analyst - Answers a person who is responsible for defining and visualizing data
database designer - Answers database modelers or architects
database developers - Answers responsible for implementing the database and making it
functional with DBMS
front-end application analysts - Answers in charge of collecting and defining requirements for
front-end applications
front end applications developers - Answers in charge of creating the front-end applications
ER Modeling - Answers conceptual database modeling technique
ERD - Answers the result of ER modeling
relationship instances - Answers occurrences of a relationship
relationship attributes - Answers attributes of a relationship and not an entity (M:N)
composite attribute - Answers attribute thats comprised of multiple parts (address)
How is a composite attribute represented? - Answers it is in parentheses
How is a composite unique attribute represented? - Answers it is underlined and in parentheses
multivalued attribute - Answers attribute that can have more than one value (phone number)
How is a multivalued attribute represented? - Answers it has double circles
What is a derived attribute? - Answers attribute whose values are calculated and not
, permanently stored in a database
How are derived attributes represented? - Answers They are in a dashed circle
How do you represent an optional attribute? - Answers (o)
How are exact minimum and maximum cardinalities represented? - Answers they are written in
parentheses underneath the cardinality
binary relationship - Answers relationship with two entities
unary relationship - Answers relationship with one entity
weak entity - Answers does not have a unique attribute of its own
owner entity - Answers entity whose unique attribute helps identify a weak entity (no primary key)
How do you represent an identifying relationship? - Answers double circle the relationship and
the entity with the partial key
partial keys are represented in what way? - Answers dashed underline
What are associative entities? - Answers An alternate way of depicting M:N relationships
How are associative entities represented? - Answers a box around the diamond
what is a ternary relationship? - Answers three entities
What is required in a relational table? - Answers Each column must have a name (within one
table, each column name must be unique)
Within one table, each row must be unique
How do you map composite attributes? - Answers Each component is mapped as a separate
column
How do you represent a composite primary key in a relational schema? - Answers Both
components are underlined
Entity Integrity Constraint - Answers Primary keys can't be optional.
In a relational schema, lines point from _____key to ___key - Answers foreign key to primary key
When mapping relationships that have a many. . . - Answers the primary key from the 1 side
becomes the foreign key is placed on the many side
when mapping many to many relationships . . . - Answers a new table is formed where each
primary key forms a new composite foreign key
