IT 214
A database organized in terms of the relational model is a ____________ database
A relational database
What is a database?
An organized collection of data
Which of the following terms is used for the properties of entities
Attributes
The abbreviation for database is _________
DB
What is the abbreviation for database?
DB
Database is an organized collection of
Data
__________ consists of raw facts, qualitative or quantitative characteristics if an entity
Data
A ____ is an organized collection of data
Database
A _________ attribute is an attribute that may have the same value for two entity instances
Duplicated value
Given the following entity: EMPLOYEE(ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME, SSN,PHONE,DOB,ADDRESS), What is the possible primary key?
ID
________ revolves uncertainty and represents processed data
Information
An ________ attribute is an attribute that have no value for at least one entity instance already defined
Optional
_______ is the notation for relational database
RDB
__________ is the notation for relational database
RDB
What is the notation for relational database management system
RDBMS
A realtional database management system is a database management system for ____________ databases.
Relational
A relational database management system in a database management system for ___________ databases.
Relational databases
A "sample" primary key is not composed of two or more attributes
Right
A "simple" primary key is composed of a single attribute
Right
A primary key containing tow or more attributes is named composite primary key
Right
A primary key containing two or more attributes is named composite primary key
Right
A simple attribute in an attribute that cannot be divided in simpler parts that have a different semantic meaning in the real world
Right
A unique (value) attribute is an attribute that have a unique (different) value or no value at all for all entity instances (already defined or to be defined in the future)
Right
An attribute that can be divided in simpler parts that have a different semantic meaning in the real world is known as a composite attribute
Right
Attributes are named with nouns or noun phrases
Right
Attributes can be defined as properties of entities
Right
Data consists of raw facts, qualitative and quantitative characteristics of an entity
Right
Data consists of raw facts, qualitative characteristics of an entity
Right
Data consists of raw facts, qualitative or quantitative characteristics of an entity
Right
Entities are named as singular nouns
Right
Entities in ER model must be named using a consistent case notation
Right
For the entity CITY the attribute name is an example of a simple attribute
Right
For the entity PERSON the attribute MIDDLE_NAME is an example of an optional attribute
Right
For the entity PERSON the attribute SSN is not an example of a duplicated values attribute
Right
For the entity PERSON the attribute address is an example of a composite attribute
Right
For the entity PERSON the attribute address is an example of composite attribute
Right
For the entity PERSON the attribute first_name is non an example of an optional attribute
Right
For the entity PERSON the attribute fullname is not an example of a unique values attributes
Right
For the entity PERSON the attribute middle_name is an example of an optional attribute
Right
In a database keeping the history of sold cars in a country, for the entity CAR the attribute PRICE is an example of a required attribute
Right
In a database keeping the history of sold cars in a county, for the entity CAR the attribute price is an example of a required attribute
Right
Information revolves uncertainty and represents processed data
Right
Knowledge is the awareness and understanding of something (e.g. entity) based on the information acquired about it.
Right
RDB is the notation for a relational database
Right
The notation for relational database management system is RDBMS
Right
The phone numbers of a person is an example of multi-value attribute
Right
The primary key is used to uniquely identify each entity instance (row)
Right
The relational model represents data in tuples grouped in relations
Right
The title of a course is an example of single-value attribute
Right
While naming entities if the name uses multiple words, seperate them by _
Right
Which of the following attributes is defined as having at most a single value for any given entity instance?
Single-valued attributes
An entity is a:
Thing in the real or conceptual world
The relational model represents data in _____________ grouped in relations
Tuples
A "simple" primary key is composed of one or more simple attributes
Wrong
A composite primary key must contain exactly two attribute
Wrong
A database is defined as any data stored and accessed on a computer system
Wrong
A database organized in terms of objects, their properties and the relations between them is a relational database
Wrong
A database organized in terms of objects, their properties and the relations between them is a relational database.
Wrong
A duplicated value attribute is an attribute that must have a the same value for two entity instances already defined
Wrong
A duplicated value attribute is an attribute that must have the same value for two entity instances already defined
Wrong
A multi-value attribute has two or more values for all entity instances
Wrong
A multi-value attribute has values for several entity instance
Wrong
A relational database management system organizes the relations between several databases
Wrong
A required attribute is an attribute that must have a value only for all entity instances already defined
Wrong
A simple attribute is an attribute that can be divided in simpler parts that have a different semantic meaning in the real world.
Wrong
A single-value attribute has at least a value for any given entity instance
Wrong
A unique (value) attribute is an attribute that have a unique (different) value only for the entity instances that are already defined for the entity
Wrong
Attributes are named with verb phrases describing an entity
Wrong
For the PERSON the attribute first_name is not an example of a required attribute
Wrong
For the entity CAR the attributes cost is an example of a composite attribute
Wrong
For the entity CITY the attribute NAME is an example of a composite attribute
Wrong
For the entity PERSON the attribute FULLNAME is an example of a unique value attribute
Wrong
For the entity PERSON the attribute fullname is an example of a unique values attribute
Wrong
For the entity PERSON the attribute fullname is not an example of a duplicated value attribute
Wrong
For the entity PERSON the attribute name is an example of a simple attribute
Wrong
Information consists of raw facts, qualitative characteristics of an entity
Wrong
Knowledge resolves uncertaintiy and represents processed data
Wrong
RD is the notation for relational database
Wrong
The acronym for database is DBA
Wrong
The acronym of database is DBA
Wrong
The emails of a person are an example of a single-value attributes
Wrong
The gender of a person is an example of multi-value attribute
Wrong
The notation for relational database managment system is RDMS
Wrong
The phone numbers of a person is an example of a single-valued attribute
Wrong
The primary key is used to uniquely identify each attribute (column)
Wrong
The relational model represents any data organized in rows and grouped in tables
Wrong
While naming entities if the name uses multiple words, separate them by hashtags(#)
Wrong
While naming entities if the name uses multiple words, seperate them by hashtag(#)
Wrong
Which of the following terms is used for properties of entities
attribute
An ______ attribute is an attribute that can be divided in simpler parts that have a different semantic meaning in the real world
composite
An attribute that can be divide in simpler parts that have a different semantic meaning in the real world, is known as:
composite attribute
Database is an organized collection of __________
data
A _____ is an organized collection of data
database
A _______ is an organized collection of data
databse
_____________ revolves uncertainty and represents processed data
information
resolves uncertainty and represents processed data
information
___________ is the awareness and understadning of something (e.g. entity) based on the information acquired about it.
knowledge
is the awareness and understanding of something (e.g. entity) based on the information acquired about it
knowledge
An _____________ attribute is an attribute that have no value for at least one entity instances already defined
optional
An ________________ attribute is an attribute that have no value for at least one entity instances already defined
optional
An ____________ attribute is an attribute that must have a value for all entity instances (already defined or to be defined in the future)
required
An attribute that cannot be divided in simpler parts that have a different semantic meaning in the real world, is know as:
simple attribute
Which of the following attributes is defined as having at most a single value for any given entity instance?
single-valued attribute
An entity is a:
thing in real or conceptual world
An entity is a:
things in the real or conceptual world
The relational model represents data in _________ grouped in relations
tuples
The relational model represents data in __________ grouped in relations
tuples
The relational model represents data in ____________ grouped in relations
tuples
An _________ attribute is an attribute that have a unique value or no value at all for all entity instances
unique