[SOLVED] MSDS7330- Assignment 1

Description

This is a homework assignment for MSDS7330, File Organization and Database Management. This quiz is due at the end of the synchronous class period in which the unit is discussed or whenever the instructor turns you to hand it in; whichever comes first. Enter your answer to each question in the MSDS 7330 Homework Answer Sheet Word document. Be sure to place your name and due date in the Homework Answer Sheet, and place your last name and the homework number at the beginning of the file name. For example, the filename for the homework answer sheet for homework 2 for Sohail Rafiqi should be Rafiqi2MSDS7330HomeWorkAnswerSheet.docx.

For each question, in the Homework Answer Sheet state the letter of your chosen answer and write out the explanation why the answer is correct. Note that the explanation involves also explaining why the other answers are not correct.

Your answer Word document should be submitted on the 2DS system for the quiz number equal to the homework number. For example, the homework 2 should be submitted for homework

assignment 2.

• The DBMS acts as an interface between what two components of an enterprise-class database system?
  1. Database application and the database
  2. Data and the database
  3. The user and the database application
  4. Database application and SQL
• The following are components of a database except which of the following?
  1. user data
  2. metadata
  3. reports
  4. indexes
• Table is synonymous with the term
  1. record
  2. relation
  3. column
  4. row
• Row is synonymous with the term
  1. column
  2. relation
  3. field
  4. record
• Attribute is synonymous with the term
  1. record
  2. relation
  3. column
  4. row
• For some relations, changing the data can have undesirable consequences called:
  1. referential integrity constraints.
  2. modification anomalies.
  3. normal forms.
  4. transitive dependencies.
• The different classes of relations created by the technique for preventing modification anomalies are called:
  1. normal forms.
  2. referential integrity constraints.
  3. functional dependencies.
  4. relation instance.
• A database schema is
  1. A plan created by the database.
  2. The logical design of the database.
  3. A particular instance of a database.
  4. The snapshot of the data in the database at a giventime.
• The primary key is selected from the
  1. composite keys.
  3. candidate keys.
  4. foreign keys.
• Which of the following is a group of one or more attributes that uniquely identifies a row?
  1. Key
  2. Determinant

1. Tuple

• A relation is considered a
  2. one-dimensional table.
  3. two-dimensional table.
  4. three-dimensional table.
• In the relational model, relationships between relations or tables are created by using:
  1. composite keys.
  3. candidate keys.
  4. foreign keys.
• You have run an SQL statement that asked the DBMS to display data in a table named UserTables. The results include columns of data labeled ‘TableName,’ ‘NumberOfColumns’ and ‘PrimaryKey.’ What are these labels?

2

1. user data
2. metadata
3. a report
4. indexes

• An Enterprise Resource Planning application is an example of a(n) ?
  1. single-user database application
  2. multiuser database application
  3. e-commerce database application
  4. data mining database application
• The following are functions of a DBMS except ?
  1. creating and processing forms
  2. creating databases
  3. processing data
  4. administrating databases