Which of the following is not true about a relation?
A) A relation is a two-dimensional table.
B) The cells of a relation must hold a single value.
C) A relation may have duplicate column names.
D) A relation may not have duplicate rows.
E) The order of t
Why is the study of database technology important?
Databases are used everywhere: They are key
components of e-commerce and other Web-based
applications. They lay at the heart of organization-wide
operational and decision support applications.
qualities of good decision making
accurate, relevant, timely information
end user data
raw facts, of interest to the end user
description of data characteristics and set of
relationships that link the data in a database
Write an SQL CREATE TABLE statement to create the PET_OWNER table, with
OwnerID as a surrogate key. Justify your choices of column properties. Write SQL
Statements to insert the data in Figure 3-15 into the PET_OWNER table.
CREATE TABLE Pet_Owner (
Describe in your own words the purpose of the two business rules listed on page 102.
The purpose of these two business rules are if the employee has any relation to any
project, then then that employee data cannot be deleted until that project is deleted
Time Allocated: 120 minutes
This is an OPEN book examination. Personal copies of textbook, supplementary book, and class notes can be used but
There are questions each with 6 parts. Use a blue book to answer these questions. Start answer to
Algorithm for base^exp:
Step 1: initialize base,exp,I,result=1
Step 2: input values of base and exp
Step 3: if exp=1 do
Step 4: if exp<0 do
Step 5: for i=1 toi<=exp do
Result = resu
Write an SQL statement to display the OwnerLastName, OwnerFirstName, and
OwnerEmail of any owners of cats with the name Teddy. Use a subquery.
SELECT OwnerLastName, OwnerFirstName, OwnerEmail
WHERE PetType IN