ISDS 7301 QUESTIONS AND VERIFIED ANSWERS
What does a relational database do? - Answers - Organizes data and tables , these are
also called relations
What are the different components of a database system? - Answers - Database
application programs , client components , database serves(s), and databases
What is the task of a database server - Answers - To manage data stored in a database
What are the features of a database ? - Answers - Variety of user interfaces, physical
data independence, logical data independence, query optimization, data integrity,
concurrency control, backup and recovery, database security
Physical data independence means ? - Answers - the database applications does not
depend on physical structure,
Most databases contain a subcomponent called an? - Answers - optimizer
What is authentication? - Answers - The process of validating user credentials to
prevent unauthorized users
What are relational database systems based upon? - Answers - The relational data
model
What is a data model? - Answers - a collection of concepts, their relationships, and their
constraints that are used to represent data of a real-world problem
What are the attributes of department? - Answers - dept_no , dept_name , location
Attributes of employee? - Answers - emp_no, emp_fname, emp_lname
Attributes of project? - Answers - Project_no, project_name, budget
works_on specifies what? and attributes ? - Answers - The relationship between
employee and projects / ( emp_no, project_no, job, enter_date)
What is the database language of the SQL server? - Answers - Transact- SQL
What are the sublanguages of SQL? - Answers - Data definition language (DDL) and
Data manipulation language (DML)
What does DDL do? - Answers - Used to describe the schema of a database table
, DDL contains what three generic statements? - Answers - Create, alter and drop
DML ? - Answers - Emcompasses all operations that manipulate the data
Four generic operations for manipulating data> - Answers - retrieval, insertions,
deletions, and modification
Normalization of data is the process of ? - Answers - testing existing tables of
databases to find dependencies between columns of a table.
Normalization is the process of ? - Answers - organizing the columns and tables of a
relational databse for the purpse of reduccing data redundancy and improving data
intergrity
Functional dependency? - Answers - is the process of eliminating data redundancy in a
table
The first normal forms means> - Answers - The table has no multivalued attributes or
composite attributes
A composite attribute contains? - Answers - other attributes that can be divided into
smaller parts
All relational tables are by definition in, and why? - Answers - 1NF ( first normal form) ,
this is because the value of any column in a row must be atomic
Atomic means? - Answers - single valued
How to eliminate repeating groups? - Answers - Make a seperate table for each set of
related attributes , and give each table a primary key
A table is in (2NF) if ? - Answers - It is in (1NF) and these is no nonkey column
dependent on a partial primary key of that table
A table is in (3NF) if ? - Answers - it is in 2nf and there are no functional dependencies
between nonkey columns
What is the entity- relationship (ER) model is used for? - Answers - to design relational
databases by removing all existing redundancy in the data
What is the basic object of the ER model - Answers - An entity
What is an entity? - Answers - a real world ojbect
Each entity has ? - Answers - Attributes
What does a relational database do? - Answers - Organizes data and tables , these are
also called relations
What are the different components of a database system? - Answers - Database
application programs , client components , database serves(s), and databases
What is the task of a database server - Answers - To manage data stored in a database
What are the features of a database ? - Answers - Variety of user interfaces, physical
data independence, logical data independence, query optimization, data integrity,
concurrency control, backup and recovery, database security
Physical data independence means ? - Answers - the database applications does not
depend on physical structure,
Most databases contain a subcomponent called an? - Answers - optimizer
What is authentication? - Answers - The process of validating user credentials to
prevent unauthorized users
What are relational database systems based upon? - Answers - The relational data
model
What is a data model? - Answers - a collection of concepts, their relationships, and their
constraints that are used to represent data of a real-world problem
What are the attributes of department? - Answers - dept_no , dept_name , location
Attributes of employee? - Answers - emp_no, emp_fname, emp_lname
Attributes of project? - Answers - Project_no, project_name, budget
works_on specifies what? and attributes ? - Answers - The relationship between
employee and projects / ( emp_no, project_no, job, enter_date)
What is the database language of the SQL server? - Answers - Transact- SQL
What are the sublanguages of SQL? - Answers - Data definition language (DDL) and
Data manipulation language (DML)
What does DDL do? - Answers - Used to describe the schema of a database table
, DDL contains what three generic statements? - Answers - Create, alter and drop
DML ? - Answers - Emcompasses all operations that manipulate the data
Four generic operations for manipulating data> - Answers - retrieval, insertions,
deletions, and modification
Normalization of data is the process of ? - Answers - testing existing tables of
databases to find dependencies between columns of a table.
Normalization is the process of ? - Answers - organizing the columns and tables of a
relational databse for the purpse of reduccing data redundancy and improving data
intergrity
Functional dependency? - Answers - is the process of eliminating data redundancy in a
table
The first normal forms means> - Answers - The table has no multivalued attributes or
composite attributes
A composite attribute contains? - Answers - other attributes that can be divided into
smaller parts
All relational tables are by definition in, and why? - Answers - 1NF ( first normal form) ,
this is because the value of any column in a row must be atomic
Atomic means? - Answers - single valued
How to eliminate repeating groups? - Answers - Make a seperate table for each set of
related attributes , and give each table a primary key
A table is in (2NF) if ? - Answers - It is in (1NF) and these is no nonkey column
dependent on a partial primary key of that table
A table is in (3NF) if ? - Answers - it is in 2nf and there are no functional dependencies
between nonkey columns
What is the entity- relationship (ER) model is used for? - Answers - to design relational
databases by removing all existing redundancy in the data
What is the basic object of the ER model - Answers - An entity
What is an entity? - Answers - a real world ojbect
Each entity has ? - Answers - Attributes
