A table named Employee in a database contains information about Employees Each

A table named employee in a database contains

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

18. A table named “Employee” in a database contains information about Employees. Each employee works for one department. Each department has multiple employees. Thefield/column named “DeptNum” in the Employee table links each employee to another table called “Department” that contains the information about departments. Which of these is most likely to be true?A. The values of DeptNum in the Employee table must not repeat B. The values of Employee ID in the Department table must not repeat C. The values of DeptNum in the Department table must not repeat D. The values of DeptNum in the Employee table may repeat19. In a relational database, the link between two tables by a primary key and a foreign key is known as: 20. A table with details of students from different universities has two attributes, University ID and University Name, as its composite primary key. Hence:21. When a many-to-many relationship is found between two tables in a relational database it is necessary to create a _______ to link the two tables together to eliminate the many-to-many relationship.22. Airbnb is a marketplace that connects owners of an unused space (e.g., a house) withthe people who are looking for such space. It is an example of what is called_________.A. Social media B. Big data C. Search cost
Background image
D. Collaborative consumption23. While looking for a new smartphone you browse through the website of a smartphonemanufacturer to gain information about the pros and cons of their smartphones. You maybe concerned about the ____ of information on such a site.24. According to the talk by Erik Brynjolfsson titled “The key to growth? Race with the machine”, the current winner of the freestyle chess championship is:25. According to the talk by Erik Brynjolfsson titled “The key to growth? Race with the machine” the new machine age is more about _____ than physical production.
Background image
Image of page 6

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture