HYPERLINK "https://dcccd.blackboard.com/webapps/blackboard/content/listContent.jsp?course_id=_29945_1&content_id=_1989014_1" Chapter 1 Assignments Which of the following represents a row in a table?
Which of the following defines a relationship in which each occurrence of data in one entity is represented by multiple occurrences of the data in the other entity? one-to-many
An entity is represented in an E-R model as a(n):
Which of the following is not an E-R model relationship?
Which of the following symbols represents a many-to-many relationship in an E-R model? A straight line with a crow’s foot
Which of the following can contain repeating groups?
Which of the following defines a relationship in which each occurrence of data in one entity is represented by only one occurrence of data in the other entity? one-to-one
Which of the following has no partial or transitive dependencies? 3NF
Which of the following symbols represents a one-to-many relationship in an E-R model? straight line with a crow’s foot at the “many” end
Which of the following has no partial dependencies but can contain transitive dependencies? 2NF
Which of the following has no repeating groups but can contain partial or transitive dependencies?
The unique identifier for a record is called the:
Which of the following fields also serves as a primary key in another table when two tables are joined together on that value?
A unique identifier for a data row that consists of more than one field is commonly called a:
Which of the following symbols represents an optional relationship in an E-R model?a dashed line
Which of the following, when used in an E-R model, indicates the need for an additional table?
Which of the following represents a field in a table?
Which of the following defines a relationship in which data can have multiple occurrences in each entity?
When part of the data in a table depends on a field in the table that isn’t the table’s primary key, it’s known as:
Which of the following is used to join data contained in two or more tables? common field
Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped?
ANS : Fields : BOOKS.TITLE, BOOKS.ISBN, ORDERITEMS.ISBN, ORDERITEM.ORDER, ORDERS.ORDER,ORDERS.CUSTOMER,CUSTOMERS.CUTOMER How would you determine which orders have not yet been shipped to the customer? ANS : orders contain shipdate which will be null or future data we can compare with current date each filter rows contain customer_id, filter Customer row according to customer id. If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this information? ANS : Simply TABLE BOOKS contain category and TABLE ORDERS contain order-date,order_item_id, Compare month and year of orders table with 4 and 2009 respectively and get all order_items, Order item contain book id and book table contain category.
Just count no of order_items from order_item table group by category of books table. Explain how you would determine how much profit was generated from orders placed in April 2009. Ans : Order_item contain quantity and paideach and orderdate is available in orders table. Just compare orderdate year with 2009 and filter order_item according to result and sum(quantity*paideach). If a customer inquired about a book written in 2003 by an author named Thompson, which access path (tables and fields) would you need to follow to find the list of books meeting the customer’s request?
In assignments 6 to 10, create a simple E-R model depicting entities and relationship lines for each data scenario.
Ans : Books table contain publish date, author table contain Author name both...
Which of the following SQL statements returns all books published after March 20, 2005?
SELECT * FROM books WHERE pubdate 4 '03–20–2005 ';
Which of the following lists all books published before June 2, 2004 and all books published
AND pubdate 5 '06–02–2004 ';
Which of the following finds all orders placed before April 5, 2009 that haven’t yet shipped?
Please join StudyMode to read the full document