Exam 6: Relational Databases and SQL

Customers of Hanson Company, a home furnishings wholesaler, place orders by contacting a sales representative via a toll-free number. Which is the appropriate relationship type for this relationship?

Which of the following is a composite attribute?

The INSERT command is used to add a single tuple to an existing relation.

Based on the following abbreviated description of Avery University's course scheduling and student advising procedures, prepare an Entity-Relationship (E-R) diagram that reflects the key entities and relationships. Course Scheduling: In consultation with the vice-president of Academic Affairs and the Registrar's Office, each academic department chair decides which courses will be offered each semester and how many sections of each course will be scheduled. Courses are scheduled in sections meeting at different times over the course of the week. Some courses are scheduled in multiple sections. The department chair also assigns a faculty member who teaches for his/her department to teach each course-section. Students enroll in courses-sections by submitting their schedule selections to the Registrar's Office. In assigning students to sections, the Registrar gives preference to students based on their class standing (i.e., Senior, Junior, Sophomore, and Freshman). Student Advising: Student academic advising is done according to each student's major. Each student chooses a faculty advisor from his/her major department. While each student has only one "official" academic advisor, each faculty person advises several students, up to a maximum of 15 advisees.

Which of the following is not a proper SQL command for creating database relations?

Which of the following is an attribute but least likely to be the key attribute?

A(n) ______________________________ of an entity is one specific thing of the type defined by the entity.

A recursive relationship is created when there is an employee being supervised, and another employee is the supervisor.

A recursive relationship occurs between two different instances of an entity.

A situation in which a particular supplier provides more than one type of inventory item to a firm and a particular type of inventory item is acquired from more than a single supplier is called a(n):

Which relationship type does (1:N) mean?

REA stands for ______________________________, ______________________________ and ______________________________.

A collection of data representing multiple occurrences of a resource, event, or agent is known as a(n) ______________________________.

Which of the following statements about the participation constraint is false?

A(n) ____ is an item of data that characterizes an entity or relationship.

Students at Macom University use a Web-based course registration system. Identify the participation constraint of the following data model relationship. The university maintains student records until they graduate or do not enroll in a course for a 3-year period.

The UPDATE command demonstrates one of the weaknesses in most forms of SQL.

______________________________ map and define the way in which data can be extracted from a database.

Relationships map and define the way in which data can be extracted from a database.

Which is not an SQL command in which data can be changed in the database?