What course are the presentation slides adapted from?
Click to see answer
CSCI235 – Database Systems.
Click to see question
What course are the presentation slides adapted from?
CSCI235 – Database Systems.
What is the primary key in the CUSTOMER table?
cNumber.
What is a key problem associated with using one big table?
It can lead to difficulties in managing and querying data efficiently.
What concept helps in understanding the relationships between data in a database?
Functional dependency.
Why is it not advisable to use one big table in database design?
To avoid redundancy and maintain data integrity.
What does the foreign key cNumber in the ORDERS table signify?
It establishes a relationship with the CUSTOMER table.
What is the function representation for the relationship between cNumber and lName?
f: domain(cNumber) → domain(lName).
What does it mean if a value in column A is x and a value in column B is always y?
It means every value x in column A is associated with only one value y in column B.
What is the primary key of the ORDERS table?
oNumber.
What are update anomalies?
Problems that arise when data is modified in a database, leading to inconsistencies.
Which functional dependency indicates that cNumber determines lName?
cNumber → lName
What does it mean if every value in column oNumber is associated with only one value in column oDate?
It indicates a functional dependency between oNumber and oDate.
What is the function representation for the relationship between oNumber and oDate?
f: domain(oNumber) → domain(oDate).
What is the focus of the lecture slides mentioned?
Database Design Quality.
What foreign key is present in the ORDERS table?
cNumber, which references CUSTOMER(cNumber).
If every value in column cNumber is associated with only one value in column fName, what does this represent?
It represents a function f : domain(cNumber) → domain(fName).
What is the definition of functional dependency in the context of databases?
It is a relationship where one attribute uniquely determines another attribute.
What does the CUSTOMER table represent?
It represents customer orders and their details.
What are the domains referred to in the functional dependency A → B?
Domain(A) and Domain(B).
What does it mean if every value in column cNumber is associated with only one value in column lName?
It indicates a functional dependency between cNumber and lName.
What is the purpose of normalization in database design?
To reduce data redundancy and improve data integrity.
What is the foreign key in the ORDERS table?
cNumber, which references CUSTOMER(cNumber).
What is the main issue with using one big table for customer orders?
Redundant data, as customer information is repeated for each item in the orders.
What is a data dependency example involving COLUMN_1 and COLUMN_2?
If COLUMN_1 is green, then COLUMN_2 is red.
What does an order consist of?
Lines that contain information about ordered items.
What is the main issue with using one big table for customer orders?
Order number and date are repeated for each item, leading to redundancy.
Why might one consider not using a single table for this database?
To avoid redundancy and maintain data integrity by separating different entities.
What is the total number of different items purchased by James Bond?
Seven items across two orders.
What is a better design approach than using one big table for orders?
Using multiple tables to separate customers, orders, and order items.
What is the significance of 'oDate' in the order data?
It indicates the date the order was placed.
What does 'lNum' represent in the order details?
Line number of the item in the order.
What is the main reason for not using one big table in database design?
To avoid issues related to data redundancy and maintainability.
What is the primary key in the ORDERS table?
oNumber.
What is the primary key of the CUSTOMER table?
cNumber.
Can a customer number in column cNumber be associated with multiple first names in column fName?
No, every customer number is associated with only one first name.
What is the advantage of a multi-table design?
It avoids problems associated with data redundancy and inconsistency.
Why is it suggested not to use ONE BIG TABLE in database design?
To avoid data redundancy and improve data integrity.
What is the notation used to represent the function mapping from column A to column B?
f : domain(A) → domain(B)
What can be said about the relationship between order number and item name?
An order number can be associated with only one item name.
What does the notation A → B represent in a relational table?
It denotes a functional dependency where A functionally determines B.
What is the relationship between cNumber and fName/lName?
If cNumber = 7, then fName = James and lName = Bond.
What is the significance of having multiple entries for the same customer in the CUSTOMER table?
It allows tracking of multiple orders and items for each customer.
What items were ordered with oNumber 7?
Bolt, Screw, Nut.
What is the total number of items ordered with oNumber 7?
10 (5 + 3 + 2).
What is functional dependency?
A special kind of data dependency reflecting real-world consistency constraints.
What can be removed from the original table when representing data dependencies?
COLUMN_2.
Which university is associated with the lecture slides?
University of Wollongong, Australia.
What is the relationship between order number (oNumber) and order date (oDate)?
Every order number is associated with only one order date.
In what year were the lecture slides presented?
Spring, 2018.
What does cNumber represent in the data?
It represents the customer number.
What is the primary key of the LINE table?
(oNumber, lNumber).
What is a functional dependency in the context of a relational table?
It is a relationship where the value of one column (A) determines the value of another column (B).
Why is it beneficial to use multiple tables instead of one big table?
To reduce data redundancy and improve data integrity.
When is a functional dependency considered valid in a relational table?
When A functionally determines B in that table.
What is the price of the Nut ordered with oNumber 7?
4.55.
How can data dependencies be represented?
As a separate relational table.
What does the functional dependency oNumber → oDate signify?
oNumber determines oDate.
What causes redundancies in an incorrectly designed relational table?
Improper handling of data dependencies.
What information is included in an order?
A unique order number and order date.
What does the example illustrate about customer orders?
Each order consists of several lines, leading to data duplication.
What information is contained in a line of an order?
Name of ordered item, price per single item, and total number of ordered items.
What can be inferred for any color x in COLUMN_1?
If COLUMN_1 is x, then COLUMN_2 is y.
What does 'oNum' signify in the context of the orders?
Order number.
Why is it not advisable to use ONE BIG TABLE in database design?
To avoid data redundancy and improve data integrity.
What is a valid functional dependency in the CUSTOMER table?
cNumber → fName
Who is the author of the lecture slides?
Dr. Janusz R. Getta.
How does normalization support database design?
By organizing data to minimize redundancy and dependency.
How can functional dependencies assist in database design?
They can be used to design a database.
What does it mean if every value in column A is associated with only one value in column B?
It means that columns A and B represent a function that maps values in column A to values in column B.
Why is a multi-table design preferred over a single big table?
To prevent data redundancy and maintain data integrity.
What is the main problem with using one big table for customer orders?
It leads to data redundancy and inconsistency.
What is the relationship between COLUMN_1 being orange and COLUMN_2?
If COLUMN_1 is orange, then COLUMN_2 is red.
How many orders did the customer James Bond submit in the example?
Two orders.
What is the significance of having a customer number in the data?
It allows for identifying unique customers and their associated information.
What items were ordered with oNumber 8?
Bolt, Screw, Nut, Lock.
What are the attributes of the LINE table?
oNumber, lNumber, item, price, total
How many items are listed under order number 7?
3 items (bolt, screw, nut).
How can functional dependencies be used in relation to data?
To describe the semantics (meaning) of data.
What role do functional dependencies play in relational schema construction?
They help determine whether a relational schema is constructed correctly.
What are data redundancies?
Unnecessary duplication of data within a database.
What information is repeated for each item in the orders?
Customer number, first name, and last name.
What happens if COLUMN_1 is blue?
COLUMN_2 will be yellow.
What is the order date for oNumber 7?
2019-01-03.
What is the consequence of having repeated customer information in a database?
Increased storage requirements and potential for inconsistencies.
What information is repeated in the one big table approach?
Order number and order date.
What is the relationship between oNumber and oDate?
If oNumber = x, then oDate = y.
What is the foreign key in the LINE table?
oNumber REFERENCES ORDERS(oNumber)
What are the attributes of the CUSTOMER table?
cNumber, firstName, lastName.
What unique identifier describes a customer in the database?
A unique customer number.
What is an example of functional dependency in a database?
Every customer number in column cNumber is associated with only one last name in column lName.
What does functional dependency imply about the relationship between two columns?
It implies a one-to-one relationship where one value in the first column determines a unique value in the second column.
What are the first and last names associated with cNumber 7?
First name: James, Last name: Bond.
What is the order date for oNumber 8?
2019-04-05.
What does the 'cNum' represent in the data?
Customer number.
Why is it inefficient to store customer and order information in one table?
It leads to unnecessary duplication of data for each item in an order.
What is the total number of items purchased by James Bond on 2019-04-05?
4 items.
What is the primary key for the CUSTOMER table?
(cNumber, oNumber, lNumber)
Can an item name in the item column be associated with multiple order numbers?
Yes, an item name can be associated with many order numbers.
What information is repeated for each order line in the provided data?
Customer number, first name, last name, and order number.
What is the primary key of the LINE table?
(oNumber, lNumber)
Why might a single large table not be ideal for this data?
Data dependencies can lead to redundancy and inconsistency.
Why is it inefficient to store multiple order lines in a single table?
It can lead to increased storage requirements and complex queries.
What is the price of the Nut item purchased on 2019-01-03?
4.55.
Why is it not advisable to use one big table for the CUSTOMER data?
It can lead to data redundancy and difficulties in managing relationships.
What are the key attributes in the CUSTOMER table?
cNumber, firstName, lastName, oNumber, oDate, lNumber, item, price, totalQty.
What foreign key is present in the LINE table?
oNumber, which references ORDERS(oNumber).
What does the example of James Bond's orders illustrate?
The problem of data redundancy in a single-table design.
What type of data does the CUSTOMER table store?
Customer information, order details, and item specifics.
What does the LINE table represent?
Details of items in an order including item, price, and total.
What is the purpose of having separate lines for each item in an order?
To accurately represent the quantity and details of each item ordered.
Why might a single large table not be ideal for data organization?
It can lead to data redundancy and complicate data management.
What items were purchased by James Bond on 2019-01-03?
Bolt, Screw, and Nut.
What is the total price for the item 'Nut' in order number 7?
9.10 (4.55 * 2).
