Question 14 14 tco 2 a means that a nonprime

  • ITT Tech
  • CIS 336
  • Test Prep
  • jonholik
  • 18
  • 98% (89) 87 out of 89 people found this document helpful

This preview shows page 6 - 9 out of 18 pages.

Question 14.14.(TCO 2) A _____ means that a nonprime attribute isfunctionally dependent on only part of a table’s primary key but not theentire primary key. (Points : 4)partial dependencytransitive dependencyrepeating groupprimary key
Question 15.15.(TCO 4) In a typical online store scenario, which of thefollowing diagrams best represents the relationship between customers andorders placed by customers? (Points : 4)
Question 16.16.(TCO 4) A(n) _____ provides a graphical description of a datamodel. (Points : 4)
Question 17.17.(TCO 3) Which statement is false regarding the creation of aforeign key constraint at table level or with an ALTER statement? (Points : 4)
Question 18.18.(TCO 3) You are creating a table called Department with fieldsfor the primary key DeptID (Integer) and department name (VARCHAR). What (ifanything) is wrong with the following code?CREATE TABLE Department(deptID INTEGER Primary Key,deptName VARCHAR(10) NOT NULL
); (Points : 4)
Question 19.19.(TCO 6) Given a table orders with fields for orderid, orderdate,and shipdate, which query will display the orderid for only those orders that haveshipped? (Points : 4)
Question 20.20.(TCO 6) Which WHERE clause will return data on all employeeswhose last name starts with ‘Smith’? (Points : 4)

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 18 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
NoProfessor
Tags
Entity relationship model, Foreign key, primary key

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture