System Analysis and Design - Phase IV. Part 1

Which type of testing focuses on individual functions?

• User acceptance testing
• Integration testing
• Unit testing
• System testing

Which statement is NOT true about the implementation of logical data model?

• Entities on the ERD are transformed into physical tables
• Attributes of entities are transformed to table columns
• Attributes of entities are transformed to table rows
• Entity instances are inserted into table rows

Which SQL statement is responsible for creating the database schema

• CREATE TABLE
• INSERT INTO
• SELECT
• UPDATE TABLE

Which SQL statement is responsible for inserting data instances into table rows?

• INSERT INTO
• CREATE TABLE
• SELECT
• UPDATE TABLE

Which would be the most appropriate data type for the 'number of children' attribute of a 'Family' entity, if we later need to find families with more than one children?

• fixed length string using CHAR
• variable string using VARCHAR
• whole number using SMALLINT
• decimal number using NUMERIC

What does 'CREATE TABLE' NOT do

• Define table name
• Define column data types
• Define entity and referential constraints
• Populate data in the table

Given the statement shown in the picture below, which statement is NOT true

• The table has two attributes/columns
• The table has a composite primary key (x, y)
• The primary key constraint can also be defined as a column integrity rule
• The primary key constraint is an example of a 'table integrity rule'

Given the table, its primary key, and existing data shown on the picture, the statement [ INSERT INTO DEPTS ('3', 'HR'); ] will cause an error because

• 'DEPTS' in the INSERT statement does not match the table name (case sensitive)
• The INSERT statement and the table does not have the same number of columns
• '3' is already a primary key in the table, this causes a violation of entity integrity

With SQL, how do you select a column named "Address" from a table named "Persons"?

• SELECT address FROM Persons
• SELECT Persons.Address
• EXTRACT address FROM Persons

How would the relational algebra shown in this picture translate to SQL?

• select * from persons
• select * from persons where fname='Bob' or Lname='Allen'
• select fname, lname from Persons
• select * from persons where fname='BOB' or lname='ALLEN'