LIS3784 Assignment Questions
The Crow's foot symbol with two parallel lines indicates ____ cardinality.
(1,1)
In the ERD, cardinality is indicated using the ____ notation.
(min, max)
List the first 10 alumni's names, genders, date of births, degree types, areas, and dates.
-- join on select p.per_id, per_fname, per_lname, per_gender, per_dob, deg_type, deg_area, deg_date from person p join alumnus a on p.per_id=a.per_id join degree d on a.per_id=d.per_id limit 0, 10; -- join using select per_id, per_fname, per_lname, per_gender, per_dob, deg_type, deg_area, deg_date from person join alumnus using(per_id) join degree using(per_id) limit 0, 10; Correcte. -- natural join select per_id, per_fname, per_lname, per_gender, per_dob, deg_type, deg_area, deg_date from person natural join alumnus natural join degree limit 10; Correctf. -- old style join select p.per_id, per_fname, per_lname, per_gender, per_dob, deg_type, deg_area, deg_date from person p, alumnus a, degree d where p.per_id=a.per_id and a.per_id=d.per_id limit 10;
List all faculty members' first and last names, full addresses, salaries, and hire dates
-- old style join select p.per_id, per_fname, per_lname, per_street, per_city, per_state, emp_salary, fac_start_date from person p, employee e, faculty f where p.per_id=e.per_id and e.per_id=f.per_id; -- join on select p.per_id, per_fname, per_lname, per_street, per_city, per_state, emp_salary, fac_start_date from person p join employee e on p.per_id=e.per_id join faculty f on e.per_id=f.per_id;
What type of relationship is expressed with the phrase "Employee manages Store"?
1:1
What type of relationship is expressed with the phrase "Painter paints Paintings"?
1:M
____ relational type is the "relational model ideal."
1:M
What is the name for the most current (and most used) notation of the ERD?
Crow's Foot notation
The ________ receives all application requests and translates them into the complex operations required to fulfill requests.
DBMS
Remove part number CB03 from the PART table;
DELETE FROM PART WHERE PART_NUMBER='CB03';
The most widely used conceptual model is the ________ model.
E-R
____ yields only the rows that appear in both tables.
INTERSECT
What is a benefit of using a DBMS?
It helps create an environment for end users to have access to more data
What type of relationship is expressed with the phrase "Student takes Class"?
M:N
Which of the following products do not provide an enterprise database?
MS Access
Why are entity integrity and referential integrity important in a database?
Referential integrity means that, if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
To list all the contents (rows or records) of the ORDERS table, you would use ____.
SELECT * FROM ORDERS;
List the order line number, part number, number ordered, and quoted price from the ORDER_LINE table in ascending order by quoted price.
SELECT ORDER_NUMBER, PART_NUMBER, NUMBER_ORDERED, QUOTED_PRICE FROM ORDER_LINE ORDER BY QUOTED_PRICE;
From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the ________.
SQL engine
________ is the de facto query language and data access standard supported by the majority of DBMS vendors.
Structured Query Language
For most relational database software, the query language is ________.
Structured Query Language (SQL)
____ combines all rows from two tables, excluding duplicate rows
UNION
Modify the city, state, and zip code of sale's rep number 06.
UPDATE sales_rep SET city='Tallahassee', state='FL', zip_code='32304' WHERE slsrep_number='06';
Which data model was developed most recently?
XML
Briefly explain why a data dictionary is necessary, and what should be included in a data dictionary.
a detailed description of all tables in the database created by the user and designer ... contains at least all of the attribute names and characteristics for each table in the system (metadata).
Briefly describe a candidate key:
a superkey without unnecessary attributes--that is, a minimal superkey.
A data ________ develops when all of the required changes in the redundant data are not made successfully.
anomaly
A(n) ____ entity is composed of the primary keys of each of the entities to be connected.
associative
(n) ________ of the overall database design is required to overcome the fact that data are viewed in different ways by different people.
blueprint
A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.
business rule
A(n) ________ model is independent of both hardware and software.
conceptual
The ________ model presents a global view of the entire database.
conceptual
A rule that CANNOT be violated by database users is called a:
constraint
The basic building blocks of all data models are entities, attributes, relationships, and ________.
constraints
John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.
create a new query
Because all data access programs are subject to change when any of the file's data storage characteristics change (that is, changing the data type), the file system is said to exhibit ________.
data dependence
A ____ contains at least all of the attribute names and characteristics for each table in the system.
data dictionary
Where does the DBMS store the definitions of data elements and their relationships?
data dictionary
A ________ focuses primarily on storing data used to generate information required to make tactical or strategic decisions.
data warehouse
The design of a ________ database recognizes the use of historical and aggregated data.
data warehouse
A ________ system is composed of software, hardware, data, procedures and people.
database
________ are considered database architects.
database designers
Remove the first 5 customers (select *all* statements that apply):
delete from customer where customer_number in (124, 256, 311, 315, 405); delete from customer where customer_number between 124 and 405 delete from customer limit 5; delete from customer where customer_number in (124, 256, 311, 315, 405);
A single-user database that runs on a personal computer is called a(n) ________ database.
desktop
One of the advantages of a relational data model is ________.
easier database design
________ are the people who use application programs to run the organization's daily operations
end users
A customer ________ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit.
entitiy
A CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of ____ integrity.
entity
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):
entity
As a general rule, a noun in a business rule will translate into a(n) ________ in the model.
entity
Each row in the relational table is known as an entity ________.
entity instance
Which model represents the end users' view of the data environment?
external
Classes are organized as a class ________.
hierarchy
The ERDM is primarily geared to business applications, while the OODM tends to focus on ________ applications.
implementation
Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.
independence
Accurate, relevant, and timely ________ is the key to good decision making.
information
Processed data, or ________, can be used as the foundation for decision making.
information
Which model is the representation of the database as "seen" by the DBMS?
internal
A relation is a matrix consisting of a series of row and column ________.
intersections
What is the fastest and most direct source of business rules?
interviews with end users
Older systems that often contain data of poor quality are called ____ systems.
legacy
The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.
mandatory
What is the name for data about data?
metadata
In the OO data model, a class ________ represents a real-world action such as finding a selected PERSON's name.
method
Data models were developed to ________.
model real-world objects or events
A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s).
natural
Data that describe the properties of other data are:
none of these
A(n) ________ allows the user to specify what must be done without specifying how it must be done.
nonprocedural language
in an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.
null
In the object-oriented data model (OODM), both data and their relationships are contained in a single structure known as a(n) ________.
object
The hierarchical database model depicts a set of ________ relationships.
one-to-many
The term "____" is used to label any condition in which one or more optional relationships exist.
optionality
A ____ should be a derived attribute.
person's age
Which model operates at the lowest level of abstraction?
physical
Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes—as foreign keys—at least the ____ keys of the tables that are to be linked.
primary
The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________.
query language
What is the name for an answer to a query that the DBMS sends back to the application?
query result set
All fields for a specific entity can be grouped together as a ________.
record
How is an entity represented in an ERD?
rectangle
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.
recursive
Data ________ exists when the same data are stored unnecessarily at different places.
redundency
Within the network model, the ________ is the conceptual organization of the entire database as viewed by the database administrator.
schema
A ____ key is defined as a key that is used strictly for data retrieval purposes.
secondary
A ________ is the equivalent of a file system's record type
segment
A record consists of a ________.
set of one or more fields
An ad hoc query is a ________.
spur of the moment question
Another word for existence-independent is ____.
strong
________ independence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.
structural
In a database context, a(n) ____ indicates the use of different names to describe the same attribute.
synonym
The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents. (BTW, in MySQL that database is named "information_schema.")
system catalog
A relational database is a collection of ________.
tables
Data processing (DP) specialists are in existence because of ________.
the need to track data and produce required reports
Data management is a discipline that focuses on ________
the proper generation, storage, and retrieval of data
Another name for a production database is a ________ database.
transactional
The hierarchical database model is based on a ________.
tree structure
Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.
tuning
When you define a table's primary key, the DBMS automatically creates a(n) ____ index on the primary key column(s) you declared.
unique
XML databases have emerged to address the need to manage ________ data within the native XML format.
unstructured
A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
weak
When the PK of one entity does not contain the PK of a related entity, the relationship is ____.
weak
