Anime LIst

Topics: SQL, Foreign key, Null Pages: 31 (11441 words) Published: October 27, 2014

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?

a record
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):
Arrow
Which of the following is not an E-R model relationship?
some-to-many
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?
unnormalized data
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?
1NF
The unique identifier for a record is called the:
primary key
Which of the following fields also serves as a primary key in another table when two tables are joined together on that value?
primary key
A unique identifier for a data row that consists of more than one field is commonly called a:
foreign key
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?
one-to-many relationship
Which of the following represents a field in a table?
a column
Which of the following defines a relationship in which data can have multiple occurrences in each entity?
one-to-many
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:
transitive dependency
Which of the following is used to join data contained in two or more tables? common field
Hands-on Assignment
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...

References: ORDER
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?
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Anime Essay
  • Growth of Anime Essay
  • The Development of Japanese Manga and Anime Essay
  • Essay about Anime and Theri Hidden Meaning
  • Essay about Anime Evolution and Influence in America
  • Why Anime Should Be a Part of Education Essay
  • Essay on Anime: Parent of All Industry
  • Behind the Scenes: How Anime Is Produced Essay

Become a StudyMode Member

Sign Up - It's Free