Test: Mid Term Exam Semester 1

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Mid Term Exam Semester 1

-

Part 1

1. Variables can be used in the following ways in a P

L/SQL block.

(Choose two.) Mark for Review

(1) Points

(Choose all correct answers)

To store data values. (*)

To rename tables and columns.

To refer to a single data value several times. (*)

To co

mment code.

Correct

2. Is the following variable declaration correct or not ?

DECLARE

display_qty CONSTANT NUMBER;

Mark for Review

(1) Points

Correct.

Not correct. (*)

Correct

3. Assignment statements can continue over several lines in PL/SQL.

True or False? Mark for Review

(1) Points

True (*)

False

Correct

4. When a variable is defined

using the NOT NULL keywords, the

variable must contain a value. True or False? Mark for Review

(1) Points

True (*)

False

Correct

5. Identify which of the following assignment statements are

valid.

(Choose three.) Mark for Review

(1) Points

(Choose all correct answers)

v_last_name := Chandra;

v_blackout_date := '31

-

DEC

-

2006'; (*)

v_population := 333444; (*)

v_music_type := 'ROCK'; (*

)

Correct

Page 1 of 10

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Mid Term Exam Semes

ter 1

-

Part 1

6. When nested blocks are used, which blocks can or must be labeled?

Mark for Review

(1) Points

The inner block must be labeled, the outer block can be labeled.

Both blocks must be labeled

Ne

sted blocks cannot be labeled

The outer block must be labeled if it is to be referred to in the

inner block. (*)

Correct

7. What will be displayed when the following code is executed?

DECLARE

varA NUM

BER := 12;

BEGIN

DECLARE

varB NUMBER := 8;

BEGIN

varA := varA + varB;

END;

DBMS_OUTPUT.PUT_LINE(varB);

END;

Mark for Review

(1) Points

8

12

Nothing, the block will fail

with an error (*)

20

VarB

Correct

8. In the following code, Line A causes an exception. What value will

be displayed when the code is executed?

DECLARE

outer_var VARCHAR2(50) := 'My';

BEGI

N

outer_var := outer_var || ' name';

DECLARE

inner_var NUMBER;

BEGIN

inner_var := 'Mehmet';

--

Line A

outer_var := outer_var || ' is';

END;

outer_var := outer_var || ' Zeynep';

EXCEPTION

WHEN

OTHERS THEN

DBMS_OUTPUT.PUT_LINE(outer_var);

END;

Mark for Review

(1) Points

My

My name (*)

My name is

My name is Zeynep

Correct

9. An exception occurs withi

n the inner block of two nested blocks.

The inner block does not have an EXCEPTION section. What always happens?

Mark for Review

(1) Points

Both blocks fail and an error message is displayed by the calling

environment

The excepti

on is propagated to the outer block (*)

Oracle automatically tries to re

-

execute the inner block

The user's database session is automatically disconnected

Correct

10. When an exception occurs within

a PL/SQL block, the remaining

statements in the executable section of the block are skipped. True or

False? Mark for Review

(1) Points

True (*)

False

Correct

Page 2 of 10

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Mid Term Exam Semester 1

-

Part 1

11. Which of these are PL/SQL data types? (Choose t

hree.) Mark for

Review

(1) Points

(Choose all correct answers)

Scalar (*)

Identifier

Delimiter

Composite (*)

LOB (*)

Correct

12. A collection is a

composite data type. True or False? Mark for

Review

(1) Points

True (*)

False

Correct

13. A movie is an example of which category of data type? Mark for

Review

(1) Points

Sca

lar

Composite

Reference

LOB (*)

Correct

14. A variable is declared as:

DECLARE

v_holdit employees.last_name%TYPE;

BEGIN ...

Which of the following is a correct use of the INT

O clause?

Mark for Review

(1) Points

SELECT *

INTO v_holdit

FROM employees;

SELECT last_name

INTO v_holdit

(1) Points

DELETE FROM employees

WHERE department_id=60;

(*)

SELECT salary FROM employees

WHERE department_id=60;

CREATE TABLE new_emps (last_name V

ARCHAR2(10), first_name

VARCHAR2(10));

DROP TABLE locations;

Correct

19. Assume there are 5 employees in Department 10. What happens when

the following statement is executed?

UPDATE employees

SET salar

y=salary*1.1;

Mark for Review

(1) Points

All employees get a 10% salary increase. (*)

No rows are modified because you did not specify "WHERE

department_id=10"

A TOO_MANY_ROWS exception is raised.

An error

message is displayed because you must use the INTO clause to

hold the new salary.

Correct

20. A PL/SQL block includes the following statement:

SELECT last_name INTO v_last_name

FROM employees

WHERE employee_id=1

00;

What is the value of SQL%ISOPEN immediately after the SELECT statement is

executed?

Mark for Review

(1) Points

True

False (*)

Null

Error. That attribute does not apply for implicit cursors.

Correct

Page 4 of 10

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Mid Term Exam Semester 1

-

Pa

rt 1

21. Which SQL statement can NOT use an implicit cursor? Mark for

Review

(1) Points

A DELETE statement

An UPDATE statement

A SELECT statement that returns multiple rows (*)

A SELECT statement

that returns one row

Incorrect. Refer to Section 3.

22. Which statements are optional in a PL/SQL block? (Choose two.)

Mark for Review

(1) Points

(Choose all correct answers)

DECLARE (*)

BEGIN

EXCEPTION (*)

END;

Correct

23. Every PL/SQL anonymous block must start with the keyword DECLARE.

True or False? Mark for Review

(1) Points

True

False (*)

Correct

24. What kind of block is defined by the following PL/SQL code?

BEGIN

DBMS_OUTPUT.PUT_LINE('My first quiz');

END;

Mark for Review

(1) Points

procedure

subroutine

function

anonymous (*)

Correct

25. Errors are handled in the Exception part of the PL/SQL block. True

or False? Mark for Review

(1) Points

True (*)

False

Correct

Page 5 of 10

Test: Mid Term Exam Semester 1

-

Part I

Review your answers, feedback, and question scores below. An asterisk (*)

indicates a correct answer.

Semester 1 Mid Term Exam answers Sections 1-10 of Database Design.

 

1.	Software cannot operate without Hardware. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		2.	Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users, as you are perfectly capable of delivering the systems the business needs and wants.		Mark for Review (1) Points
			True. All that perfect systems need are correct programs.
			False. Business requirements can and will change. For instance new legal requirements may arise. (*)
			True. All users do is delay systems delivery with their forever changing minds and new requirements.
			True. Users never know what they want anyway, so building systems are best left to the professionals.
				Correct
		3.	The first step in system development is to document the requirements. Why?		Mark for Review (1) Points
			Wrong. A blueprint for the database design is not needed. We can just start coding straight away.
			It clarifies what a business wants to accomplish, and provides measures for deciding if the system delivers all that is required. (*)
			It allows application development to be conducted without having to consider database design.
			It keeps businesses honest.
				Correct
		4.	What is the difference between „information” and „data”?		Mark for Review (1) Points
			Data is held and understood only by users
			Information is held and understood only by users
			Information and data have no differences – they are two words for the same thing
			Data turns into information when it is stored in a database and accessed by systems and users (*)
				Correct
	Section 2
		5.	Entity Relationship modeling is dependent on the hardware or software used for implementation, so you will need to change your ERD if you decide to change Hardware Vendor. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		6.	Data models are drawn to show users the actual Data their new system will contain. Only Data on the Diagram can be entered into the Database. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		7.	A/an _________ is a picture of all the information that will form the basis for the finished system.		Mark for Review (1) Points
			ERD (*)
			Process
			Table
			Attribute
				Correct
		8.	All of the following could be attributes of an ENTITY called PERSON except one. Select the incorrect one:		Mark for Review (1) Points
			Haircolor
			Weight
			Gender
			Natacha Hansen (*)
				Correct
		9.	The entity/relationship model is created before the physical database design model? True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		10.	Which of the following entities most likely contains valid attributes? (Choose two)		Mark for Review (1) Points
			(Choose all correct answers)
			Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*)
			Entity: Pet. Attributes: Name, Birthdate, Owner (*)
			Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
			Entity: Mother. Attributes: Name, Birthdate, Occupation, Salary
				Incorrect. Refer to Section 2 Lesson 2.

Section 2
		11.	All of the following would be instances of the entity ANIMAL SPECIES except which?		Mark for Review (1) Points
			Dog
			Bird
			Elephant
			Leaf (*)
				Correct
	Section 3
		12.	Relationship Degree/Cardinality is important. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		13.	Relationships represents something of significance to the business. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		14.	Matrix Diagrams show Optionality and Degrees of the ERDs they document. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		15.	When reading an ERD including Relationships you are said to be speaking:		Mark for Review (1) Points
			Relationship-ish
			Gibberish
			ERDish (*)
			Entity-ish
				Correct
		16.	The many end of a Relationship is called:		Mark for Review (1) Points
			Gulls Foot
			Pigs Ear
			Crows Ear
			Crows Foot (*)
				Correct
	Section 4
		17.	Business rules are important to data modelers. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		18.	Which of the following are suitable Entity names? (Choose Two)		Mark for Review (1) Points
			(Choose all correct answers)
			DOGS
			ANIMAL (*)
			ANIMALS
			DOG (*)
				Correct
		19.	A Supertype can have only one subtype. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		20.	A supertype can only have two subtypes and no more. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct

1.	All ER diagrams must have one of each of the following: (Choose two)		Mark for Review (1) Points
			(Choose all correct answers)
			One or more Entities (*)
			Relationships between entities (*)
			Arcs
			At least one supertype and subtype
				Correct
		22.	Which of the following is true about subtypes?		Mark for Review (1) Points
			One instance may belong to two subtypes of the same supertype.
			Subtypes must be mutually exclusive. (*)
			Subtypes must not be mutually exclusive.
			Subtype entities may not have relationships to the other subtype entities, only the supertype itself.
				Correct
	Section 5
		23.	A relationship from an entity back to itself is called a ___________ relationship.		Mark for Review (1) Points
			Mandatory
			Recursive (*)
			Many to Many Optional
			Transferrable
				Correct
		24.	Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		25.	Which of the following pairs of entities is most likely to be modeled as a M:M relationship?		Mark for Review (1) Points
			CAR and WHEEL
			TREE and BRANCH
			PERSON and FINGERPRINT
			TEACHER and SUBJECT AREA (*)
				Correct
		26.	If two entities have two relationships between them, these relationships can be either _____________ or _____________ ?		Mark for Review (1) Points
			Redundant or Required (*)
			Replicated or Required
			Resourced and Really Good
			Redundant and Replicated
				Correct
		27.	When you resolve a M-M you simply re-draw the relationships between the two original entities, no new entities are created. True or False?		Mark for Review (1) Points
			True
			False (*)
				Incorrect. Refer to Section 5 Lesson 3.
		28.	Intersection Entities are at the Master end in the relationships between it and the original entities. So the original entities are details or children of the newly created intersection entity. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		29.	What do you call the entity created when you resolve a M:M relationship?		Mark for Review (1) Points
			Intersection entity (*)
			Inclusion entity
			Recursive entity
			M:M entity
				Incorrect. Refer to Section 5 Lesson 3.
		30.	Transferable relationships can only be mandatory, not optional. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
	Section 6 31.  The Rule of 3rd Normal Form states that No Non-UID attribute can be dependant on another non-UID attribute. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 6 Lesson 4. 32.  Normalizing an Entity to 1st Normal Form is done by removing repeated or redundant attributes. True or False? Mark for Review (1) Points True (*) False Correct 33.  Would it be a good idea to model age as an attribute of STUDENT? Mark for Review (1) Points Yes Maybe it could stop us having to calculate someone’s age every time we need it Sometimes No – it breaks the Normalization rules (*) Incorrect. Refer to Section 6 Lesson 3. 34.  All entities must be given a new artificial UID. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 6 Lesson 1. 35.  People are not born with „numbers”, but a lot of systems assign student numbers, customer IDs, etc. A shoe has a color, a size, a style, but may not have a descriptive „number”. So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created. Mark for Review (1) Points Artificial (*) Unrealistic Structured Identification Correct Section 7 36.  All relationships participating in an arc must be mandatory. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 7 Lesson 1. 37.  No parts of an UID are mandatory. True or False? Mark for Review (1) Points True False (*) Correct 38.  Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review (1) Points Sameness Differences Exclusivity (*) Inheritance Correct 39.  Which of the following is NOT a relationship type? Mark for Review (1) Points Some to None (*) One to One One to Many Many to Many Correct 40.  Arcs are Mandatory in Data modeling. All ERD’s must have at least one Arc. True or False? Mark for Review (1) Points True False (*) Correct

Section 7
		41.	Historical data must never be kept. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		42.	A recursive relationship must Mandatory at both ends. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
	Section 9
		43.	Which of the following would be a logical constraint when modeling time for a City entity?		Mark for Review (1) Points
			People are born in the city and people die in the city.
			Cites may change their name and/or which country they are placed in, if the borders of a country change. (*)
			If you are doing a system for any French City, you would need security clearance
			You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor
				Correct
		44.	If a system includes the concept of time and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		45.	Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?		Mark for Review (1) Points
			An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
			EMPLOYEE periods can overlap causing the database to crash.
			End Date must be before the Start Date.
			Dates must be stored with Time.
				Correct
		46.	All systems must include functionality to provide logging or journaling in conceptual data models. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
	Section 10
		47.	Generic models are generally far more complex than a specific model. True or False?		Mark for Review (1) Points
			True
			False (*)
				Incorrect. Refer to Section 10 Lesson 2.
		48.	All datamodels must be transformed from specific to generic. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		49.	There is no point in trying to group your entities together on your diagram according to volume. Making a diagram pretty is a waste of time. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		50.	There are formal rules for how to draw ERD’s, even though they are only guidelines, you should always try to follow them. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
				Section 1 1.  Oracle Database Software provides which of the following functionality? (Choose two) Mark for Review (1) Points (Choose all correct answers) Graphical User Interface (*) Internet Browser Server (*) Operating System Incorrect. Refer to Section 1 Lesson 4. 2.  Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users, as you are perfectly capable of delivering the systems the business needs and wants. Mark for Review (1) Points True. All that perfect systems need are correct programs. False. Business requirements can and will change. For instance new legal requirements may arise. (*) True. All users do is delay systems delivery with their forever changing minds and new requirements. True. Users never know what they want anyway, so building systems are best left to the professionals. Correct 3.  Entities are transformed into Tables during the Database Design process. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 1 Lesson 3. 4.  Consider your school library. It will have a database with transaction details of which student borrows which books. Is details of the total number of books out on loan in one given month Data or Information? Mark for Review (1) Points Data Information (*) Both Neither Correct Section 2 5.  An ERD is an example of a Physical Model. True or False? Mark for Review (1) Points True False (*) Correct 6.  The entity/relationship model is created before the physical database design model? True or False? Mark for Review (1) Points True (*) False Correct 7.  Which of the following entities most likely contains valid attributes? (Choose two) Mark for Review (1) Points (Choose all correct answers) Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*) Entity: Pet. Attributes: Name, Birthdate, Owner (*) Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed Entity: Mother. Attributes: Name, Birthdate, Occupation, Salary Correct 8.  Volatile entities have special requirements and need special attention when you are doing data modelling. True or False? Mark for Review (1) Points True (*) False Correct 9.  Which of the following are examples of ENTITY: Instance. (Choose Two) Mark for Review (1) Points (Choose all correct answers) TRANSPORTATION METHOD: Car (*) ANIMAL: Dog (*) MEAT PRODUCT: Lettuce BODY PART: Larry Ellison Correct 10.  An entity can have many Unique Identifiers. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 2 Lesson 2. Section 2 11.  Entity and Attribute names are always interchangable, so you need not worry about choosing the right type. True or False? Mark for Review (1) Points True False (*) Correct Section 3 12.  One Relationship can be both mandatory and optional at different ends. True or False? Mark for Review (1) Points True (*) False Correct 13.  Relationships represents something of significance to the business. True or False? Mark for Review (1) Points True (*) False Correct 14.  Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? Mark for Review (1) Points True False (*) Correct 15.  Matrix Diagrams are mandatory when doing data modelling. True or False? Mark for Review (1) Points True False (*) Correct 16.  Matrix Diagrams are developed BEFORE the ERD. True or False? Mark for Review (1) Points True False (*) Correct Section 4 17.  Why is it important to identify and document structural rules? Mark for Review (1) Points Ensures we know what data to store and how that data works together. (*) Ensures nothing. There are no benefits to be gained from documenting your Structural Business Rules. We need to concentrate on the Procedural Business Rules only. Ensures we know what Information to store and how that Information works together. All of the Above. Correct 18.  All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review (1) Points True (*) False Correct 19.  All instances of a subtype may be an instance of the supertype but does not have to. True or False? Mark for Review (1) Points True False (*) Correct 20.  The „Other” subtype is mandatory. True or False? Mark for Review (1) Points True False (*) Correct Section 4 21.  A Supertype can have only one subtype. True or False? Mark for Review (1) Points True False (*) Correct 22.  When creating entities you must follow these rules: (Choose Two) Mark for Review (1) Points (Choose all correct answers) Name them in Plural Name them in Singular (*) Exclude Attributes Include Attributes (*) Correct Section 5 23.  Transferable relationships can only be mandatory, not optional. True or False? Mark for Review (1) Points True False (*) Correct 24.  If two entities have two relationships between them, these relationships can be either _____________ or _____________ ? Mark for Review (1) Points Redundant or Required (*) Replicated or Required Resourced and Really Good Redundant and Replicated Correct 25.  What uncommon relationship is described by the statements: „Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE” Mark for Review (1) Points One to Many Optional One to Many Mandatory One to One Optional (*) Many to Many Mandatory Correct 26.  A relationship from an entity back to itself is called a ___________ relationship. Mark for Review (1) Points Mandatory Recursive (*) Many to Many Optional Transferrable Correct 27.  Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review (1) Points CAR and WHEEL TREE and BRANCH PERSON and FINGERPRINT TEACHER and SUBJECT AREA (*) Correct 28.  Intersection Entities are at the Master end in the relationships between it and the original entities. So the original entities are details or children of the newly created intersection entity. True or False? Mark for Review (1) Points True False (*) Correct 29.  Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review (1) Points True (*) False Correct 30.  What do you call the entity created when you resolve a M:M relationship? Mark for Review (1) Points Intersection entity (*) Inclusion entity Recursive entity M:M entity Correct Section 6 31.  As a database designer you do not need to worry about where in the datamodel you store a particular attribute, as long as you get it onto the ERD your job is done. True or False? Mark for Review (1) Points True False (*) Correct 32.  When is an entity in 2nd Normal Form? Mark for Review (1) Points When all non-UID attributes are dependent upon the entire UID. (*) When no attritibutes are mutually independant and fully independent on the primary key. When no attritibutes are mutually independent and all are fully dependent on the primary key. None of the Above. Correct 33.  When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review (1) Points Normality Reduction Normalization (*) Multiplication Incorrect. Refer to Section 6 Lesson 2. 34.  The first UID for an entity is called the Primary UID, the second is called Secondary UID and so on. Mark for Review (1) Points Yes, this is the way UID’s are named. (*) No, it is not possible to have more than one UID for an Entity. Yes, but then it stops. No entities can have more than two UID’s. No, each Entity can only have one UID, the secondary one. Correct 35.  People are not born with „numbers”, but a lot of systems assign student numbers, customer IDs, etc. A shoe has a color, a size, a style, but may not have a descriptive „number”. So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created. Mark for Review (1) Points Artificial (*) Unrealistic Structured Identification Correct Section 7 36.  A particular problem may be solved using either a Recursive Relationship or a Hierarchy, though not at the same time. True or False? Mark for Review (1) Points True (*) False Correct 37.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review (1) Points (Choose all correct answers) BABY and AGE CUSTOMER and PAYMENTS (*) TEACHER and AGE CUSTOMER and ORDERS (*) Correct 38.  No parts of an UID are mandatory. True or False? Mark for Review (1) Points True False (*) Correct 39.  All relationships participating in an arc must be mandatory. True or False? Mark for Review (1) Points True False (*) Correct 40.  Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review (1) Points Sameness Differences Exclusivity (*) Inheritance Correct Section 7 41.  Which of the following would best be represented by an arc? Mark for Review (1) Points TEACHER (Female, Bob) DELIVERY ADDRESS (Home, Office) (*) PARENT (Girl, Bob) STUDENT (Grade A student, Average Student) Correct 42.  An arc can also be modeled as Supertype and Subtypes. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 7 Lesson 1. Section 9 43.  All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*) Correct 44.  Which of the following is a logical constraint that could result from considering how time impacts an example of data storage? Mark for Review (1) Points An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*) EMPLOYEE periods can overlap causing the database to crash. End Date must be before the Start Date. Dates must be stored with Time. Correct 45.  If a system includes the concept of time and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Correct 46.  Modeling historical data is Optional. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 9 Lesson 1. Section 10 47.  Generic models are generally far more complex than a specific model. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 10 Lesson 2. 48.  All datamodels must be transformed from specific to generic. True or False? Mark for Review (1) Points True False (*) Correct 49.  There is no point in trying to group your entities together on your diagram according to volume. Making a diagram pretty is a waste of time. True or False? Mark for Review (1) Points True False (*) Correct 50.  Which of the following statements are true for ERD’s to enhance their readability. (Choose Two) Mark for Review (1) Points (Choose all correct answers) Is is OK to break a big ERD down into subsets of the overall picture. This way you end up with more than one ERD, that together documents the entire system. (*) Try to avoid crossing lines (*) The crows feet (many ends) can point whichever way is the easiest to draw You must ensure you have all the entities on one single, big diagram, even if you have hundreds Incorrect. Refer to Section 11 Lesson 1. Section 1 Lesson 1 (Answer all questions in this section) 1. Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users, as you are perfectly capable of delivering the systems the business needs and wants. Mark for Review (1) Points True. All that perfect systems need are correct programs. False. Business requirements can and will change. For instance new legal requirements may arise. (*) True. All users do is delay systems delivery with their forever changing minds and new requirements. True. Users never know what they want anyway, so building systems are best left to the professionals. Section 1 Lesson 2 (Answer all questions in this section) 2. Consider your school library. It will have a database with transaction details of which student borrows which books. Is details of the total number of books out on loan in one given month Data or Information? Mark for Review (1) Points Data Information (*) Both Neither Incorrect. Refer to Section 1. 3. What is the difference between “information” and “data”? Mark for Review (1) Points Data is held and understood only by Users Information is held and understood only by users Information and data have no differences – they are two words for the same thing Data turns into information when it is stored in a database and accessed by systems and users (*) Incorrect. Refer to Section 1 Section 1 Lesson 3 (Answer all questions in this section) 4. Entities are transformed into Tables during the Database Design process? True or False? Mark for Review (1) Points True (*) False Correct Section 1 Lesson 4 (Answer all questions in this section) 5. Businesses involved in any of the following typically use databases to handle their data: Finance, Logistics, Commerce, Procurement and Distribution? True or False? Mark for Review (1) Points True (*) False Correct 6. Software cannot operate without Hardware. True or False? Mark for Review (1) Points True (*) False Correct Section 2 Lesson 2 (Answer all questions in this section) 7. An entity is instantiated as a ? Mark for Review (1) Points experience instance table (*) none of the above Incorrect. Refer to Section 2 8. A/an _________ is a picture of all the information that will form the basis for the finished system. Mark for Review (1) Points ERD (*) Process Table Attribute Incorrect. Refer to Section 2 9. The entity/relationship model is created before the physical database design model. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 2 10. All of the following would be instances of the entity ANIMAL SPECIES except which? Mark for Review (1) Points Dog Bird Elephant Leaf (*) Correct Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) 11. An entity can have many Unique Identifiers. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 7 12. Volatile entities have special requirements and need special attention when you are doing data modelling. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 2 13. All of the following are examples of ENTITY: Instance except two. Select the answers that are ENTITY: Instance. (Choose Two) Mark for Review (1) Points (Choose all correct answers) TRANSPORTATION METHOD: Car (*) ANIMAL: Dog (*) MEAT PRODUCT: Lettuce BODY PART: Larry Ellison Incorrect. Refer to Section 2 Section 3 Lesson 1 (Answer all questions in this section) 14. Relationship Degree/Cardinality is important. True or False? Mark for Review (1) Points True (*) False Correct 15. In a business that sells pet food choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse or cat). (Choose Two) Mark for Review (1) Points (Choose all correct answers) Each FOOD TYPE must be suitable for one or more ANIMALs. (*) Each ANIMAL must be the seller of one or more FOOD TYPES. Each FOOD TYPE may be made from one or more ANIMALs. Each FOOD TYPE may be given to one or more ANIMALs. (*) Incorrect. Refer to Section 3 Section 3 Lesson 2 (Answer all questions in this section) 16. To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False? Mark for Review (1) Points True (*) False Correct 17. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? Mark for Review (1) Points True False (*) Correct Section 3 Lesson 3 (Answer all questions in this section) Section 4 Lesson 1 (Answer all questions in this section) 19. The “Other” subtype is mandatory. True or False? Mark for Review (1) Points True False (*) Correct 20. All ER diagrams must have one of each of the following: (Choose two) Mark for Review (1) Points (Choose all correct answers) One or more Entities (*) Relationships between entities (*) Arcs At least one supertype and subtype Correct Page 2 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) 21. Which of the following are suitable Entity names? (Choose Two) Mark for Review (1) Points (Choose all correct answers) DOGS ANIMAL (*) ANIMALS DOG (*) Correct 22. Which of the following is true about subtypes? Mark for Review (1) Points One instance may belong to two subtypes of the same supertype. Subtypes must be mutually exclusive. (*) Subtypes must not be mutually exclusive. Subtype entities may not have relationships to the other subtype entities, only the supertype itself. Correct 23. When creating entities you must follow these rules: (Choose Two) Mark for Review (1) Points (Choose all correct answers) Name them in Plural Name them in Singular (*) Exclude Attributes Include Attributes (*) Incorrect. Refer to Section 4 Section 4 Lesson 2 (Answer all questions in this section) 24. Can all constraints be modeled on an ER diagram? Mark for Review (1) Points No, in which case you should let the database administrator handle them No, but you just explain them to the users so they can enforce them Yes, all constraints must be modeled and shown on the ER diagram No, so you should list them on a separate document to be handled programmatically (*) Incorrect. Refer to Section 4 25. “Only teachers may supervise exams” is an example of which of the following? Mark for Review (1) Points A procedural business rule (*) An attribute that should be stored on the PERSON entity A structural business rule An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype Incorrect. Refer to Section 4 26. A business rule such as “We only ship goods after customers have completely paid any outstanding balances on their account” is best enforced by: Mark for Review (1) Points Making the payment attribute null. Making the payment attribute optional. We need to trust our customers, and we know they will pay some day. Hiring a programmer to create additional programming code to verify no goods are shipped until the account has been settled in full. (*) Correct 27. Why is it important to identify and document structural rules? Mark for Review (1) Points Ensures we know what data to store and how that data works together. (*) Ensures nothing. There is no benefits to be gained from documenting your Structural Business Rules. We need to concentrate on the Procedural Business Rules only. Ensures we know what Information to store and how that Information works together. All of the Above. Incorrect. Refer to Section 4 Section 5 Lesson 1 (Answer all questions in this section) 28. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review (1) Points Mandatory Optional Transferrable Non-Transferable (*) Correct Section 5 Lesson 2 (Answer all questions in this section) 29. How do you include a relationship as part of the UID for an entity? Mark for Review (1) Points By barring the relationship in question (*) By reporting it in an external document By including the UID from the parent entity as an attribute in the entity You cannot model that. Correct 30. What uncommon relationship is described by the statements: “Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE” Mark for Review (1) Points One to Many Optional One to Many Mandatory One to One Optional (*) Many to Many Mandatory Correct Page 3 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) 31. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 5. 32. Relationships can be Redundant. True or False? Mark for Review (1) Points True (*) False Correct Section 6 Lesson 1 (Answer all questions in this section) 33. The first UID for an entity is called the Primary UID, the second is called Secondary UID and so on. Mark for Review (1) Points Yes, this is the way UID’s are named. (*) No, it is not possible to have more than one UID for an Entity. Yes, but then it stops. No entities can have more than two UID’s. No, each Entity can only have one UID, the secondary one. Incorrect. Refer to Section 6. Section 6 Lesson 2 (Answer all questions in this section) 34. Normalizing an Entity to 1st Normal Form is done by removing repeated or redundant attributes. True or False? Mark for Review (1) Points True (*) False Correct Section 6 Lesson 3 (Answer all questions in this section) 35. Would it be a good idea to model age as an attribute of STUDENT Mark for Review (1) Points Yes Maybe it could stop us having to calculate someones age every time we need it Sometimes No – it breaks the Normalization rules (*) Correct Section 7 Lesson 1 (Answer all questions in this section) 36. An arc can be modelled as Supertype and Subtypes. True or False? Mark for Review (1) Points True (*) False Correct 37. Which of the following would best be represented by an arc? Mark for Review (1) Points TEACHER (Female, Bob) DELIVERY ADDRESS ( Home, Office) (*) PARENT (Girl, Bob) STUDENT (Grade A student, Average Student) Correct 38. Consider the entity ADDRESS with the attributes: ADDRESS: # House Number * Street * Town * City * Year of Build o City Population This entity is NOT in 3rd Normal Form (“no non-UID attribute can be dependent on another non-UID attribute). True or False? Mark for Review (1) Points True (*) False Correct 39. Primary UIDs are: Mark for Review (1) Points Something that each Entity should have, but is not mandatory (*) Useful as an alternative means identifying instances of an entity, independent of their datatype Mandatory in data modeling Always comprised of numbers Incorrect. Refer to Section 7 40. No parts of a UID are mandatory. True or False? Mark for Review (1) Points True False (*) Correct Page 4 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 7 Lesson 2 (Answer all questions in this section) 41. A recursive relationship must Mandatory at both ends. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 7 Section 7 Lesson 3 (Answer all questions in this section) 42. If Audit trail attributes are added to an entity they must be in the entities they are auditing. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 1 (Answer all questions in this section) 43. Communication Skills, Team-working and Presentations skills are all important for Consultants. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 2 (Answer all questions in this section) 44. Which of the following are NOT valid techniques for effective public speaking? (Choose Two) Mark for Review (1) Points (Choose all correct answers) Whispering (*) Using specialist language and technical abbreviations when communicating technical information (*) Being enthusiastic All of the Above Correct Section 10 Lesson 1 (Answer all questions in this section) 45. If a system includes the concept of time, and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 10 46. Modeling historical data is Optional. True or False? Mark for Review (1) Points True (*) False Correct 47. What do users of a system without the concept of time loose? Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Correct 48. There is only one way to model time in a Data Model. True or False? Mark for Review (1) Points True False (*) Correct Section 10 Lesson 2 (Answer all questions in this section) 49. You are doing a data model for a computer sales company, where the price of postage is dependant on what day of the week goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this? Mark for Review (1) Points Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*) Email current price to all employees whenever the prices change. Update the prices in the system, print out the current prices when they change and pin them on the company noticeboard Allow them to enter whatever delivery charge they want. Correct 50. Why would you want to model a time component when designing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchange to be notified of this information. To allow the sales people to determine when the shared were bought and therefore at what price. (*) You would not want to model this, it is not important. The price of shares fluctuates and for determining price, you need to know the time of purchase (*) Correct Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Lesson 1 (Answer all questions in this section) 1. The market for IT professionals is still increasing and will continue to do so in the future, as the world gets ever more dependent on computer systems. True or False? Mark for Review (1) Points True (*) False Correct Section 1 Lesson 2 (Answer all questions in this section) 3. What is the difference between “information” and “data”? Mark for Review (1) Points Data is held and understood only by Users Information is held and understood only by users Information and data have no differences – they are two words for the same thing Data turns into information when it is stored in a database and accessed by systems and users (*) Correct Section 1 Lesson 3 (Answer all questions in this section) 4. Users with detailed business knowledge can provide input to the Database Development Process. True or False? Mark for Review (1) Points True False (*) Corect Section 1 Lesson 4 (Answer all questions in this section) 5. Businesses involved in any of the following typically use databases to handle their data: Finance, Logistics, Commerce, Procurement and Distribution? True or False? Mark for Review (1) Points True (*) False Correct 6. Databases perform these functions…. Mark for Review (1) Points Running multiple applications on multiple client-servers Providing integrated software on fast processing servers Providing software running on a variety of platforms and configurations allowing companies a structured way to access and manage their data (*) They run purely as client-based software on personal computers Correct Section 2 Lesson 2 (Answer all questions in this section) 7. Which of the following statements about relationships are true? (Choose Two) Mark for Review (1) Points (Choose all correct answers) They become Foreign Keys in the database. (*) They Must be Mandatory to be created in the database. They can be either mandatory or optional. (*) They must exist between two different Entities. Incorrect. Refer to Section 2 8. Primary Unique Identifiers… (Choose Two) Mark for Review (1) Points (Choose all correct answers) Are Required. The data model is not complete until all entities have a Primary UID. (*) Distinguish each instance of an entity from all others (*) Are not required You may create more than one Primary Unique Identifier for an entity Incorrect. Refer to Section 2 9. All of the following could be attributes of an ENTITY called PERSON except one. Select the incorrect one: Mark for Review (1) Points Haircolor Weight Gender Natacha Hansen (*) Correct Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Correct 12. An entity can have many Unique Identifiers. True or False? Mark for Review (1) Points True False (*) Corect Section 3 Lesson 1 (Answer all questions in this section) 14. Relationships represents something of significance to the business? True or False? Mark for Review (1) Points True False (*) Corect 15. Which of the following are valid relationship degrees? (Choose two) Mark for Review (1) Points (Choose all correct answers) 1:1 (*) 1:M (*) 1:O O:O Correct Section 3 Lesson 2 (Answer all questions in this section) 16. Entity names are always singular. True or False? Mark for Review (1) Points True (*) False Correct 17. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? Mark for Review (1) Points True (*) False Corect Section 3 Lesson 3 (Answer all questions in this section) 18. Two entities can ONLY have one relationship between them. True or False? Mark for Review (1) Points True False (*) Correct Section 4 Lesson 1 (Answer all questions in this section) 19. All instances of a subtypes may be an instance of the supertype but does not have to. True or False? Mark for Review (1) Points True False (*) Correct 20. A Supertype can have only one subtype. True or False? Mark for Review (1) Points True (*) False Corect Page 2 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) 21. The “Other” subtype is mandatory. True or False? Mark for Review (1) Points True False (*) Correct 22. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review (1) Points True (*) False Correct 23. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review (1) Points True (*) False corect Section 4 Lesson 2 (Answer all questions in this section) 25. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review (1) Points Use a supertype Use two subtypes with relationships from class to student gender (*) Make the attribute Gender mandatory You cannot model this. You need to document it. Correct 26. A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False? Mark for Review (1) Points True False (*) corect Section 5 Lesson 1 (Answer all questions in this section) 28. A Diamond on a relationship indicates the Relationship as Non-Tranferrable. True or False? Mark for Review (1) Points True (*) False Correct Section 5 Lesson 2 (Answer all questions in this section) 29. If two entities have two relationships between them, these relationships can be either __________ or __________? Mark for Review (1) Points Redundant or Required (*) Replicated or Required Resourced and Really Good Redundant and Replicated Incorrect Correct Page 3 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) Correct 32. What uncommon relationship is described by the statements: “Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE” Mark for Review (1) Points One to Many Optional One to Many Mandatory One to One Optional (*) Many to Many Mandatory Incorrect. Refer to Section 5 Section 6 Lesson 1 (Answer all questions in this section) 33. All entities must be given a new artificial UID. True or False? Mark for Review (1) Points True (*) False corect Section 6 Lesson 2 (Answer all questions in this section) 34. Normalizing an Entity to 1st Normal Form is done by removing repeated or redundant attributes. True or False? Mark for Review (1) Points True (*) False Correct Section 6 Lesson 3 (Answer all questions in this section) 35. Would it be a good idea to model age as an attribute of STUDENT Mark for Review (1) Points Yes Maybe it could stop us having to calculate someones age every time we need it Sometimes No – it breaks the Normalization rules (*) Incorrect. Refer to Section 6 Section 7 Lesson 1 (Answer all questions in this section) 36. All relationships participating in an arc must be mandatory. True or False? Mark for Review (1) Points True (*) False corect corect 38. Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review (1) Points Sameness Differencies Exclusivity (*) An Arc is what Noah sailed on with all the animals. Incorrect. Refer to Section 7 Incorrect. Refer to Section 7 Page 4 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 7 Lesson 2 (Answer all questions in this section) 41. A relationship can be both Recursive and Hierarchal at the same time. True or False? Mark for Review (1) Points True (*) False corect Section 7 Lesson 3 (Answer all questions in this section) 42. Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review (1) Points (Choose all correct answers) BABY and AGE CUSTOMER and PAYMENTS (*) TEACHER and AGE CUSTOMER and ORDERS (*) Incorrect. Refer to Section 7 Section 8 Lesson 1 (Answer all questions in this section) 43. Consultants often use their experience in ensuring projects stay on track and delivers within the timescales set out for the project. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 2 (Answer all questions in this section) 44. Your apperance at a presentation is important. You need to look smart and presentable. True or False? Mark for Review (1) Points True False (*) corect Section 10 Lesson 1 (Answer all questions in this section) 45. What do users of a system without the concept of time loose? Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Incorrect. Refer to Section 10 46. All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? Mark for Review (1) Points True False (*) Correct 47. There is only one way to model time in a Data Model. True or False? Mark for Review (1) Points True (*) False corect 48. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. Cites may change their name and/or which country they are placed in, if the borders of a country change. (*) If you are doing a system for any French City, you would need security clearance You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor Incorrect. Refer to Section 10 Section 10 Lesson 2 (Answer all questions in this section) 49. Why would you want to model a time component when designing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchange to be notified of this information. To allow the sales people to determine when the shared were bought and therefore at what price. (*) You would not want to model this, it is not important. The price of shares fluctuates and for determining price, you need to know the time of purchase (*) Incorrect. Refer to Section 10 50. You are doing a data model for a computer sales company, where the price of postage is dependant on what day of the week goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this? Mark for Review (1) Points Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*) Email current price to all employees whenever the prices change. Update the prices in the system, print out the current prices when they change and pin them on the company noticeboard Allow them to enter whatever delivery charge they want. Incorrect. Refer to Section 10 Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Correct Section 1 Lesson 2 (Answer all questions in this section) Section 1 Lesson 3 (Answer all questions in this section) Section 1 Lesson 4 (Answer all questions in this section) Correct Section 2 Lesson 2 (Answer all questions in this section) Incorrect. Refer to Section 2 Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Section 3 Lesson 1 (Answer all questions in this section) Section 3 Lesson 2 (Answer all questions in this section) Corect Section 3 Lesson 3 (Answer all questions in this section) Section 4 Lesson 1 (Answer all questions in this section) 19. All instances of a subtypes may be an instance of the supertype but does not have to. True or False? Mark for Review (1) Points True False (*) Correct 20. A Supertype can have only one subtype. True or False? Mark for Review (1) Points True (*) False Corect Page 2 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) Correct Section 4 Lesson 2 (Answer all questions in this section) Section 5 Lesson 1 (Answer all questions in this section) Correct Section 5 Lesson 2 (Answer all questions in this section) 29. If two entities have two relationships between them, these relationships can be either __________ or __________? Mark for Review (1) Points Redundant or Required (*) Replicated or Required Resourced and Really Good Redundant and Replicated Incorrect 30. Relationships can be Redundant. True or False? Mark for Review (1) Points True (*) False Correct Page 3 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 5 Section 6 Lesson 1 (Answer all questions in this section) corect Section 6 Lesson 2 (Answer all questions in this section) Section 6 Lesson 3 (Answer all questions in this section) 35. Would it be a good idea to model age as an attribute of STUDENT Mark for Review (1) Points Yes Maybe it could stop us having to calculate someones age every time we need it Sometimes No – it breaks the Normalization rules (*) Incorrect. Refer to Section 6 Section 7 Lesson 1 (Answer all questions in this section) corect Incorrect. Refer to Section 7 Incorrect. Refer to Section 7 Incorrect. Refer to Section 7 Page 4 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 7 Lesson 2 (Answer all questions in this section) 41. A relationship can be both Recursive and Hierarchal at the same time. True or False? Mark for Review (1) Points True (*) False corect Section 7 Lesson 3 (Answer all questions in this section) 42. Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review (1) Points (Choose all correct answers) BABY and AGE CUSTOMER and PAYMENTS (*) TEACHER and AGE CUSTOMER and ORDERS (*) Incorrect. Refer to Section 7 Section 8 Lesson 1 (Answer all questions in this section) 43. Consultants often use their experience in ensuring projects stay on track and delivers within the timescales set out for the project. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 2 (Answer all questions in this section) 44. Your apperance at a presentation is important. You need to look smart and presentable. True or False? Mark for Review (1) Points True False (*) corect Section 10 Lesson 1 (Answer all questions in this section) 45. What do users of a system without the concept of time loose? Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Incorrect. Refer to Section 10 46. All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? Mark for Review (1) Points True False (*) Correct 47. There is only one way to model time in a Data Model. True or False? Mark for Review (1) Points True (*) False corect 48. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. Cites may change their name and/or which country they are placed in, if the borders of a country change. (*) If you are doing a system for any French City, you would need security clearance You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor Incorrect. Refer to Section 10 Section 10 Lesson 2 (Answer all questions in this section) 49. Why would you want to model a time component when designing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchange to be notified of this information. To allow the sales people to determine when the shared were bought and therefore at what price. (*) You would not want to model this, it is not important. The price of shares fluctuates and for determining price, you need to know the time of purchase (*) Incorrect. Refer to Section 10 50. You are doing a data model for a computer sales company, where the price of postage is dependant on what day of the week goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this? Mark for Review (1) Points Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*) Email current price to all employees whenever the prices change. Update the prices in the system, print out the current prices when they change and pin them on the company noticeboard Allow them to enter whatever delivery charge they want. Incorrect. Refer to Section 10 Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Lesson 2 (Answer all questions in this section) 2. Information which was gained from data is the same as: (Choose Two) Mark for Review (1) Points (Choose all correct answers) Knowledge (*) Raw Materials Intelligence (*) There is no difference between data and information. Correct Section 1 Lesson 3 (Answer all questions in this section) 4. Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False? Mark for Review (1) Points True (*) False Correct Section 1 Lesson 4 (Answer all questions in this section) 5. Databases perform these functions…. Mark for Review (1) Points Running multiple applications on multiple client-servers Providing integrated software on fast processing servers Providing software running on a variety of platforms and configurations allowing companies a structured way to access and manage their data (*) They run purely as client-based software on personal computers Incorrect. Refer to Section 1 6. Databases were invented in 1989. True or False? Mark for Review (1) Points True False (*) Correct Section 2 Lesson 2 (Answer all questions in this section) 7. Volatile entities have special requirements and need special attention when you are doing data modelling. True or False? Mark for Review (1) Points True (*) False Correct 8. In a physical data model, a relationship is represented as a? Mark for Review (1) Points Column Row Instance Foreign Key (*) Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Section 3 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 3. Incorrect. Refer to Section 3 Section 3 Lesson 2 (Answer all questions in this section) 16. Which symbol is used to show that a particular attribute is mandatory? Mark for Review (1) Points * (*) o % & Correct 17. The single end of a Relationship is called: Mark for Review (1) Points Single Toe (*) Big Toe Single Foot Crows Foot Correct Section 3 Lesson 3 (Answer all questions in this section) Section 4 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 4 Correct Page 2 of 5 Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) 21. A Supertype can have only one subtype. True or False? Mark for Review (1) Points True False (*) Correct Correct Section 4 Lesson 2 (Answer all questions in this section) 24. A business rule such as “We only ship goods after customers have completely paid any outstanding balances on their account” is best enforced by: Mark for Review (1) Points Making the payment attribute null. Making the payment attribute optional. We need to trust our customers, and we know they will pay some day. Hiring a programmer to create additional programming code to verify no goods are shipped until the account has been settled in full. (*) Incorrect. Refer to Section 4 Correct Incorrect. Refer to Section 4 Section 5 Lesson 1 (Answer all questions in this section) 28. A non-transferable relationship means the detail can be changed to point to a new master. True or False? Mark for Review (1) Points True False (*) Correct Section 5 Lesson 2 (Answer all questions in this section) Incorrect. Refer to Section 5 30. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review (1) Points CAR and WHEEL TREE and BRANCH PERSON and FINGERPRINT TEACHER and SUBJECT AREA (*) Incorrect. Refer to Section 5. Page 3 of 5 Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) 31. A relationship from an entity back to itself is called a ___________ relationship. Mark for Review (1) Points Mandatory Recursive (*) Many to Many Optional Transferrable Correct 32. How do you include a relationship as part of the UID for an entity? Mark for Review (1) Points By barring the relationship in question (*) By reporting it in an external document By including the UID from the parent entity as an attribute in the entity You cannot model that. Incorrect. Refer to Section 5 Section 6 Lesson 1 (Answer all questions in this section) Correct Section 6 Lesson 2 (Answer all questions in this section) 34. An entity without repeated values is said to be on 1st Normal Form. True or False? Mark for Review (1) Points True (*) False Correct Section 6 Lesson 3 (Answer all questions in this section) 35. When is an entity in 2nd Normal Form? Mark for Review (1) Points When all non-UID attributes are dependent upon the entire UID. (*) When no attritibutes are mutually independant and fully independent on the primary key. When no attritibutes are mutually independent and all are fully dependent on the primary key. None of the Above. Incorrect. Refer to Section 6 Section 7 Lesson 1 (Answer all questions in this section) Correct 37. Which of the following is NOT a relationship type? Mark for Review (1) Points Some to None (*) One to One One to Many Many to Many Correct Correct Incorrect. Refer to Section 7 Page 4 of 5 Section 7 Lesson 2 (Answer all questions in this section) 41. A particular problem may be solved using either a Recursive Realtionship or a Hierachy, though not at the same time. True or False? Mark for Review (1) Points True (*) False Correct Section 7 Lesson 3 (Answer all questions in this section) 42. Modeling historical data can produce a unique identifier that always excludes dates. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 7 Section 8 Lesson 1 (Answer all questions in this section) 43. Communication Skills, Team-working and Presentations skills are all important for Consultants. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 8 Section 8 Lesson 2 (Answer all questions in this section) 44. Which of the following are NOT valid techniques for effective public speaking? (Choose Two) Mark for Review (1) Points (Choose all correct answers) Whispering (*) Using specialist language and technical abbreviations when communicating technical information (*) Being enthusiastic All of the Above Incorrect. Refer to Section 8 Section 10 Lesson 1 (Answer all questions in this section) 45. Modeling historical data is Optional. True or False? Mark for Review (1) Points True (*) False Correct 46. All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? Mark for Review (1) Points True False (*) Correct 47. If a system includes the concept of time, and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 10 48. When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 2 (Answer all questions in this section) 49. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 10 50. Which of the following is a logical constraint, that could result from considering how time impacts data storage? Mark for Review (1) Points An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*) EMPLOYEE periods can overlap causing the database to crash. End Date must be before the Start Date. Dates must be stored with Time. Incorrect. Refer to Section 10 Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Lesson 1 (Answer all questions in this section) to the professionals. Section 1 Lesson 2 (Answer all questions in this section) Section 1 Lesson 3 (Answer all questions in this section) Correct Section 1 Lesson 4 (Answer all questions in this section) Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Incorrect. Refer to Section 2 Incorrect. Refer to Section 2 Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Section 3 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 3 Section 3 Lesson 2 (Answer all questions in this section) Correct Correct Section 3 Lesson 3 (Answer all questions in this section) Section 4 Lesson 1 (Answer all questions in this section) 19. All instances of a subtypes may be an instance of the supertype but does not have to. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 4 20. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review (1) Points True False (*) Correct Page 2 of 5 Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) Correct Correct Section 4 Lesson 2 (Answer all questions in this section) Incorrect. Refer to Section 4 Section 5 Lesson 1 (Answer all questions in this section) 28. A non-transferable relationship means the detail can be changed to point to a new master. True or False? Mark for Review (1) Points True False (*) Correct Section 5 Lesson 2 Incorrect. Refer to Section 5 30. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review (1) Points CAR and WHEEL TREE and BRANCH PERSON and FINGERPRINT TEACHER and SUBJECT AREA (*) Incorrect. Refer to Section 5. Page 3 of 5 Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) 31. A relationship from an entity back to itself is called a ___________ relationship. Mark for Review (1) Points Mandatory Recursive (*) Many to Many Optional Transferrable Correct Incorrect. Refer to Section 5 Section 6 Lesson 1 (Answer all questions in this section) Section 6 Lesson 2 (Answer all questions in this section) Section 6 Lesson 3 (Answer all questions in this section) Incorrect. Refer to Section 6 Section 7 Lesson 1 (Answer all questions in this section) Correct Correct Correct Incorrect. Refer to Section 7 Page 4 of 5 Section 7 Lesson 2 (Answer all questions in this section) 41. A particular problem may be solved using either a Recursive Realtionship or a Hierachy, though not at the same time. True or False? Mark for Review (1) Points True (*) False Correct Section 7 Lesson 3 (Answer all questions in this section) 42. Modeling historical data can produce a unique identifier that always excludes dates. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 7 Section 8 Lesson 1 (Answer all questions in this section) 43. Communication Skills, Team-working and Presentations skills are all important for Consultants. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 8 Section 8 Lesson 2 (Answer all questions in this section) 44. Which of the following are NOT valid techniques for effective public speaking? (Choose Two) Mark for Review (1) Points (Choose all correct answers) Whispering (*) Using specialist language and technical abbreviations when communicating technical information (*) Being enthusiastic All of the Above Incorrect. Refer to Section 8 Section 10 Lesson 1 (Answer all questions in this section) 45. Modeling historical data is Optional. True or False? Mark for Review (1) Points True (*) False Correct 46. All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? Mark for Review (1) Points True False (*) Correct 47. If a system includes the concept of time, and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 10 48. When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 2 (Answer all questions in this section) 49. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 10 50. Which of the following is a logical constraint, that could result from considering how time impacts data storage? Mark for Review (1) Points An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*) EMPLOYEE periods can overlap causing the database to crash. End Date must be before the Start Date. Dates must be stored with Time. Incorrect. Refer to Section 10 Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Lesson 1 (Answer all questions in this section) Correct Section 1 Lesson 2 (Answer all questions in this section) Section 1 Lesson 3 (Answer all questions in this section) Section 1 Lesson 4 (Answer all questions in this section) Incorrect. Refer to Section 1. 6. Oracle Database Software provides which of the following functionality? (Choose two) Mark for Review (1) Points (Choose all correct answers) Graphical User Interface (*) Internet Browser Server (*) Operating Systems Correct. Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 9. Relationship names are usually verbs. True or False? Mark for Review (1) Points True (*) False Correct Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 13. All of the following are examples of ENTITY: Instance except two. Select the answers that are ENTITY: Instance. (Choose Two) Mark for Review (1) Points (Choose all correct answers) TRANSPORTATION METHOD: Car (*) ANIMAL: Dog (*) MEAT PRODUCT: Lettuce BODY PART: Larry Ellison Correct Section 3 Lesson 1 (Answer all questions in this section) 14. Relationship Names are optional. True or False? Mark for Review (1) Points True False (*) Correct Incorrect. Refer to Section 3 Section 3 Lesson 2 (Answer all questions in this section) Correct 17. The many end of a Relationship is called: Mark for Review (1) Points Gulls Foot Pigs Ear Crows Ear Crows Foot (*) Correct Section 3 Lesson 3 (Answer all questions in this section) 18. When reading a relationship between 2 entities, the relationship is read both from left to right and right to left. True or False? Mark for Review (1) Points True (*) False Correct Section 4 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 4 Incorrect. Refer to Section 4. Page 2 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) Correct 22. All ER diagrams must have one of each of the following: (Choose two) Mark for Review (1) Points (Choose all correct answers) One or more Entities (*) Relationships between entities (*) Arcs At least one supertype and subtype Incorrect. Refer to Section 4 Correct Section 4 Lesson 2 (Answer all questions in this section) Correct 25. Business rules are important to data modelers. True or False? Mark for Review (1) Points True (*) False Correct Incorrect. Refer to Section 4 Section 5 Lesson 1 (Answer all questions in this section) 28. Transferable relationships can only be mandatory, not optional. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 5. Section 5 Lesson 2 (Answer all questions in this section) 29. If two entities have two relationships between them, these relationships can be either __________ or __________? Mark for Review (1) Points Redundant or Required (*) Replicated or Required Resourced and Really Good Redundant and Replicated Correct 30. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 5. Page 3 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) Correct Correct Section 6 Lesson 1 (Answer all questions in this section) 33. People are not born with “numbers,” but a lot of systems assign student numbers, customer IDs, etc. A shoe has a color, a size, a style, but may not have a descriptive “number”. So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created. Mark for Review (1) Points artificial (*) unrealistic structured identification Incorrect. Refer to Section 6. Section 6 Lesson 2 (Answer all questions in this section) Correct Section 6 Lesson 3 (Answer all questions in this section) 35. Would it be a good idea to model age as an attribute of STUDENT Mark for Review (1) Points Yes Maybe it could stop us having to calculate someones age every time we need it Sometimes No – it breaks the Normalization rules (*) Incorrect. Refer to Section 6 Section 7 Lesson 1 (Answer all questions in this section) Correct Incorrect. Refer to Section 7 Correct Correct Page 4 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 7 Lesson 2 (Answer all questions in this section) 41. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review (1) Points (Choose all correct answers) Personal Identification number for Person (*) Vehicle Registration Number for Car (*) ISBN Number for Book (*) Date of birth for Baby Incorrect. Refer to Section 7 Section 7 Lesson 3 (Answer all questions in this section) 42. If Audit trail attributes are added to an entity they must be in the entities they are auditing. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 1 (Answer all questions in this section) 43. Database Design projects must use Consultants or they will fail. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 8 Section 8 Lesson 2 (Answer all questions in this section) 44. Your apperance at a presentation is important. You need to look smart and presentable. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 1 (Answer all questions in this section) 45. If a system includes the concept of time, and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Correct 46. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. Cites may change their name and/or which country they are placed in, if the borders of a country change. (*) If you are doing a system for any French City, you would need security clearance You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor Correct 47. What do users of a system without the concept of time loose? Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Correct 48. When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 2 (Answer all questions in this section) 49. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*) Correct 50. Why would you want to model a time component when designing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchange to be notified of this information. To allow the sales people to determine when the shared were bought and therefore at what price. (*) You would not want to model this, it is not important. The price of shares fluctuates and for determining price, you need to know the time of purchase (*) Correct Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Lesson 1 (Answer all questions in this section) Correct Section 1 Lesson 2 (Answer all questions in this section) Incorrect. Refer to Section 1. Section 1 Lesson 3 (Answer all questions in this section) Correct Section 1 Lesson 4 (Answer all questions in this section) Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Correct Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Section 3 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 3 Section 3 Lesson 2 (Answer all questions in this section) Section 3 Lesson 3 (Answer all questions in this section) Section 4 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 4 Incorrect. Refer to Section 4. Page 2 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) Correct Correct Section 4 Lesson 2 (Answer all questions in this section) Incorrect. Refer to Section 4 Section 5 Lesson 1 (Answer all questions in this section) ection 5. Section 5 Lesson 2 Correct Incorrect. Refer to Section 5. Page 3 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) Correct Correct Section 6 Lesson 1 (Answer all questions in this section) Section 6 Lesson 2 (Answer all questions in this section) Correct Section 6 Lesson 3 (Answer all questions in this section) Incorrect. Refer to Section 6 Section 7 Lesson 1 (Answer all questions in this section) Correct Incorrect. Refer to Section 7 Correct Correct Correct Page 4 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 7 Lesson 2 (Answer all questions in this section) 41. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review (1) Points (Choose all correct answers) Personal Identification number for Person (*) Vehicle Registration Number for Car (*) ISBN Number for Book (*) Date of birth for Baby Incorrect. Refer to Section 7 Section 7 Lesson 3 (Answer all questions in this section) 42. If Audit trail attributes are added to an entity they must be in the entities they are auditing. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 1 (Answer all questions in this section) 43. Database Design projects must use Consultants or they will fail. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 8 Section 8 Lesson 2 (Answer all questions in this section) 44. Your apperance at a presentation is important. You need to look smart and presentable. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 1 (Answer all questions in this section) 45. If a system includes the concept of time, and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Correct 46. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. Cites may change their name and/or which country they are placed in, if the borders of a country change. (*) If you are doing a system for any French City, you would need security clearance You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor Correct 47. What do users of a system without the concept of time loose? Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Correct 48. When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 2 (Answer all questions in this section) 49. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*) Correct 50. Why would you want to model a time component when designing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchange to be notified of this information. To allow the sales people to determine when the shared were bought and therefore at what price. (*) You would not want to model this, it is not important. The price of shares fluctuates and for determining price, you need to know the time of purchase (*) Correct Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Lesson 1 (Answer all questions in this section) Section 1 Lesson 2 (Answer all questions in this section) Incorrect. Refer to Section 1. Section 1 Lesson 3 (Answer all questions in this section) Section 1 Lesson 4 (Answer all questions in this section) Incorrect. Refer to Section 1. 6. Oracle Database Software provides which of the following functionality? (Choose two) Mark for Review (1) Points (Choose all correct answers) Graphical User Interface (*) Internet Browser Server (*) Operating Systems Correct. Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Correct Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Section 3 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 3 Section 3 Lesson 2 (Answer all questions in this section) 1 Correct Section 3 Lesson 3 (Answer all questions in this section) Correct Section 4 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 4 Incorrect. Refer to Section 4. Page 2 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) Correct Section 4 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 4 Incorrect. Refer to Section 4 Section 5 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 5. Section 5 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 5. Page 3 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 Correct Correct Section 6 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 6. Section 6 Lesson 2 (Answer all questions in this section) Section 6 Lesson 3 (Answer all questions in this section) Section 7 Lesson 1 (Answer all questions in this section) Correct Correct Correct Page 4 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 7 Lesson 2 (Answer all questions in this section) 41. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review (1) Points (Choose all correct answers) Personal Identification number for Person (*) Vehicle Registration Number for Car (*) ISBN Number for Book (*) Date of birth for Baby Incorrect. Refer to Section 7 Section 7 Lesson 3 (Answer all questions in this section) 42. If Audit trail attributes are added to an entity they must be in the entities they are auditing. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 1 (Answer all questions in this section) 43. Database Design projects must use Consultants or they will fail. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 8 Section 8 Lesson 2 (Answer all questions in this section) 44. Your apperance at a presentation is important. You need to look smart and presentable. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 1 (Answer all questions in this section) 45. If a system includes the concept of time, and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Correct 46. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. Cites may change their name and/or which country they are placed in, if the borders of a country change. (*) If you are doing a system for any French City, you would need security clearance You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor Correct 47. What do users of a system without the concept of time loose? Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Correct 48. When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 2 (Answer all questions in this section) 49. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*) Correct 50. Why would you want to model a time component when designing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchange to be notified of this information. To allow the sales people to determine when the shared were bought and therefore at what price. (*) You would not want to model this, it is not important. The price of shares fluctuates and for determining price, you need to know the time of purchase (*) Correct Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Lesson 1 (Answer all questions in this section) Section 1 Lesson 2 (Answer all questions in this section) Incorrect. Refer to Section 1. Correct Section 1 Lesson 3 (Answer all questions in this section) Correct Section 1 Lesson 4 (Answer all questions in this section) Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Section 3 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 3 Section 3 Lesson 2 (Answer all questions in this section) Correct Section 3 Lesson 3 (Answer all questions in this section) Correct Section 4 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 4 Incorrect. Refer to Section 4. Page 2 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) Correct Incorrect. Refer to Section 4 Section 4 Lesson 2 (Answer all questions in this section) Incorrect. Refer to Section 4 Section 5 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 5. Section 5 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 5. Page 3 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) Correct Correct Section 6 Lesson 1 (Answer all questions in this section) Section 6 Lesson 2 (Answer all questions in this section) Correct Section 6 Lesson 3 (Answer all questions in this section) Incorrect. Refer to Section 6 Section 7 Lesson 1 (Answer all questions in this section) Correct Incorrect. Refer to Section 7 Correct Correct Page 4 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 7 Lesson 2 (Answer all questions in this section) 41. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review (1) Points (Choose all correct answers) Personal Identification number for Person (*) Vehicle Registration Number for Car (*) ISBN Number for Book (*) Date of birth for Baby Incorrect. Refer to Section 7 Section 7 Lesson 3 (Answer all questions in this section) 42. If Audit trail attributes are added to an entity they must be in the entities they are auditing. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 1 (Answer all questions in this section) 43. Database Design projects must use Consultants or they will fail. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 8 Section 8 Lesson 2 (Answer all questions in this section) 44. Your apperance at a presentation is important. You need to look smart and presentable. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 1 (Answer all questions in this section) 45. If a system includes the concept of time, and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Correct 46. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. Cites may change their name and/or which country they are placed in, if the borders of a country change. (*) If you are doing a system for any French City, you would need security clearance You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor Correct 47. What do users of a system without the concept of time loose? Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Correct 48. When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 2 (Answer all questions in this section) 49. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*) Correct 50. Why would you want to model a time component when designing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchange to be notified of this information. To allow the sales people to determine when the shared were bought and therefore at what price. (*) You would not want to model this, it is not important. The price of shares fluctuates and for determining price, you need to know the time of purchase (*) Correct Page 5 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Lesson 1 (Answer all questions in this section) 1. The main subject areas taught by the Oracle Academy are: Mark for Review (1) Points Section 1 Lesson 2 (Answer all questions in this section) Section 1 Lesson 3 (Answer all questions in this section) Section 1 Lesson 4 (Answer all questions in this section) Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Page 1 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 2 Correct Section 3 Lesson 1 (Answer all questions in this section) Correct Incorrect. Refer to Section 3 Section 3 Lesson 2 (Answer all questions in this section) Correct Section 3 Lesson 3 (Answer all questions in this section) Correct Section 4 Lesson 1 (Answer all questions in this section) 19. Which of the following are suitable Entity names? (Choose Two) Mark for Review (1) Points (Choose all correct answers) DOGS ANIMAL (*) ANIMALS DOG (*) Incorrect. Refer to Section 4 20. The “Other” subtype is mandatory. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 4. Page 2 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 4 Lesson 1 (Answer all questions in this section) Correct Incorrect. Refer to Section 4 Correct Section 4 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 4 Incorrect. Refer to Section 4 Section 5 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 5. Section 5 Lesson 2 (Answer all questions in this section) Correct Incorrect. Refer to Section 5. Page 3 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 5 Lesson 2 (Answer all questions in this section) Correct Section 6 Lesson 1 (Answer all questions in this section) Incorrect. Refer to Section 6. Section 6 Lesson 2 (Answer all questions in this section) Correct Section 6 Lesson 3 (Answer all questions in this section) Incorrect. Refer to Section 6 Section 7 Lesson 1 (Answer all questions in this section) Correct Page 4 of 5 Test: Mid Term Exam – Database Design Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 7 Lesson 2 (Answer all questions in this section) 41. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review (1) Points (Choose all correct answers) Personal Identification number for Person (*) Vehicle Registration Number for Car (*) ISBN Number for Book (*) Date of birth for Baby Incorrect. Refer to Section 7 Section 7 Lesson 3 (Answer all questions in this section) 42. If Audit trail attributes are added to an entity they must be in the entities they are auditing. True or False? Mark for Review (1) Points True (*) False Correct Section 8 Lesson 1 (Answer all questions in this section) 43. Database Design projects must use Consultants or they will fail. True or False? Mark for Review (1) Points True False (*) Incorrect. Refer to Section 8 Section 8 Lesson 2 (Answer all questions in this section) 44. Your apperance at a presentation is important. You need to look smart and presentable. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 1 (Answer all questions in this section) 45. If a system includes the concept of time, and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review (1) Points True False (*) Correct 46. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. Cites may change their name and/or which country they are placed in, if the borders of a country change. (*) If you are doing a system for any French City, you would need security clearance You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor Correct 47. What do users of a system without the concept of time loose? Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Correct 48. When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review (1) Points True (*) False Correct Section 10 Lesson 2 (Answer all questions in this section) 49. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*) Correct 50. Why would you want to model a time component when designing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchange to be notified of this information. To allow the sales people to determine when the shared were bought and therefore at what price. (*) You would not want to model this, it is not important. The price of shares fluctuates and for determining price, you need to know the time of purchase (*) Correct Page 5 of 5 16NOV Ultima ora – Midterm de la 12d Posted by blogulblogurilor in 1. Comments Off Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Semester 1 Mid Term Exam covers Sections 1-10 of Database Design. Section 1 1.  The first step in system development is to document the requirements. Why?  Mark for Review (1) Points Wrong. A blueprint for the database design is not needed. We can just start coding straight away. It clarifies what a business wants to accomplish, and provides measures for deciding if the system delivers all that is required. (*) It allows application development to be conducted without having to consider database design. It keeps businesses honest. Correct 2.  Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users, as you are perfectly capable of delivering the systems the business needs and wants.  Mark for Review (1) Points True. All that perfect systems need are correct programs. False. Business requirements can and will change. For instance new legal requirements may arise. (*) True. All users do is delay systems delivery with their forever changing minds and new requirements. True. Users never know what they want anyway, so building systems are best left to the professionals. Correct 3.  Consider your school library. It will have a database with transaction details of which student borrows which books. Is a record of one student borrowing one book Data or Information?  Mark for Review (1) Points Data (*) Information Both Neither Correct 4.  Databases perform these functions….  Mark for Review (1) Points Running multiple applications on multiple client-servers Providing integrated software on fast processing servers Providing software running on a variety of platforms and configurations allowing companies a structured way to access and manage their data (*) They run purely as client-based software on personal computers Correct Section 2 5.  An entity is instantiated as a ?  Mark for Review (1) Points Experience Instance Table (*) None of the above Correct 6.  In a physical data model, a relationship is represented as a?  Mark for Review (1) Points Column Row Instance Foreign Key (*) Correct 7.  The entity/relationship model is created before the physical database design model? True or False?  Mark for Review (1) Points True (*) False Correct 8.  Primary Unique Identifiers: (Choose Two)  Mark for Review (1) Points (Choose all correct answers) Are required. The data model is not complete until all entities have a Primary UID. (*) Distinguish each instance of an entity from all others. (*) Are not required. Can be created multiple times for an entity. Correct 9.  Which of the following entities most likely contains valid attributes? (Choose two)  Mark for Review (1) Points (Choose all correct answers) Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*) Entity: Pet. Attributes: Name, Birthdate, Owner (*) Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed Entity: Mother. Attributes: Name, Birthdate, Occupation, Salary Correct 10.  The Physical Model is derived from the Conceptual Model. True or False?  Mark for Review (1) Points True (*) False Correct Test: Mid Term Exam Semester 1 Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Semester 1 Mid Term Exam covers Sections 1-10 of Database Design. Section 2 11.  The UID for an Entity is always just whatever attribute you happened to create first in that entity. It does not matter which attribute you choose, as long as you have a UID you are done. True or False?  Mark for Review (1) Points True False (*) Correct Section 3 12.  All the Attributes in a system are just written on the ERD, and they all go in the Top Left Hand Corner of the paper. True or False?  Mark for Review (1) Points True False (*) Correct 13.  Matrix Diagrams are mandatory when doing data modelling. True or False?  Mark for Review (1) Points True False (*) Correct 14.  In a business that sells pet food choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse or cat). (Choose Two)  Mark for Review (1) Points (Choose all correct answers) Each FOOD TYPE must be suitable for one or more ANIMALs. (*) Each ANIMAL must be the seller of one or more FOOD TYPES. Each FOOD TYPE may be made from one or more ANIMALs. Each FOOD TYPE may be given to one or more ANIMALs. (*) Correct 15.  Relationship Degree/Cardinality is important. True or False?  Mark for Review (1) Points True (*) False Correct 16.  Matrix Diagrams are developed BEFORE the ERD. True or False?  Mark for Review (1) Points True False (*) Correct Section 4 17.  Business rules are important to data modelers. True or False?  Mark for Review (1) Points True (*) False Correct 18.  A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False?  Mark for Review (1) Points True (*) False Correct 19.  Can all constraints be modeled on an ER diagram?  Mark for Review (1) Points No, in which case you should let the database administrator handle them No, but you just explain them to the users so they can enforce them Yes, all constraints must be modeled and shown on the ER diagram No, so you should list them on a separate document to be handled programmatically (*) Correct 20.  “Only teachers may supervise exams” is an example of which of the following?  Mark for Review (1) Points A procedural business rule (*) An attribute that should be stored on the PERSON entity A structural business rule An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype Correct Test: Mid Term Exam Semester 1 Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Semester 1 Mid Term Exam covers Sections 1-10 of Database Design. Section 4 21.  Which of the following are suitable Entity names? (Choose Two)  Mark for Review (1) Points (Choose all correct answers) DOGS ANIMAL (*) ANIMALS DOG (*) Correct 22.  All instances of a subtype may be an instance of the supertype but does not have to. True or False?  Mark for Review (1) Points True False (*) Incorrect. Refer to Section 4 23.  A Supertype can have only one subtype. True or False?  Mark for Review (1) Points True False (*) Correct 24.  All ER diagrams must have one of each of the following: (Choose two)  Mark for Review (1) Points (Choose all correct answers) One or more Entities (*) Relationships between entities (*) Arcs At least one supertype and subtype Correct 25.  You can only create relationships to a Supertype, not to a Subtype. True or False?  Mark for Review (1) Points True False (*) Correct Section 5 26.  Transferable relationships can only be mandatory, not optional. True or False?  Mark for Review (1) Points True False (*) Correct 27.  Intersection Entities are at the Master end in the relationships between it and the original entities. So the original entities are details or children of the newly created intersection entity. True or False?  Mark for Review (1) Points True False (*) Correct 28.  Relationships can be Redundant. True or False?  Mark for Review (1) Points True (*) False Correct 29.  Which of the following pairs of entities is most likely to be modeled as a M:M relationship?  Mark for Review (1) Points CAR and WHEEL TREE and BRANCH PERSON and FINGERPRINT TEACHER and SUBJECT AREA (*) Correct 30.  A relationship from an entity back to itself is called a ___________ relationship.  Mark for Review (1) Points Mandatory Recursive (*) Many to Many Optional Transferrable Correct Page 3 of 5 Test: Mid Term Exam Semester 1 Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Semester 1 Mid Term Exam covers Sections 1-10 of Database Design. Section 7 41.  Which of the following would best be represented by an arc?  Mark for Review (1) Points TEACHER (Female, Bob) DELIVERY ADDRESS (Home, Office) (*) PARENT (Girl, Bob) STUDENT (Grade A student, Average Student) Correct 42.  Consider the entity ADDRESS with the attributes: ADDRESS: # House Number * Street * Town * City * Year of Build o City Population This entity is NOT in 3rd Normal Form (“no non-UID attribute can be dependent on another non-UID attribute). True or False?  Mark for Review (1) Points True (*) False Correct Section 8 43.  Which of the following are NOT valid techniques for effective public speaking? (Choose Two)  Mark for Review (1) Points (Choose all correct answers) Whispering (*) Using specialist language and technical abbreviations when communicating technical information (*) Being enthusiastic All of the Above Correct 44.  Database Design projects must use Consultants or they will fail. True or False?  Mark for Review (1) Points True False (*) Correct Section 10 45.  Modeling historical data is Optional. True or False?  Mark for Review (1) Points True (*) False Correct 46.  If a system includes the concept of time and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False?  Mark for Review (1) Points True False (*) Correct 47.  What do users of a system without the concept of time loose?  Mark for Review (1) Points Journalling becomes much easier. Journalling becomes slightly harder. The ability to track data over time. (*) Nothing is lost if a system does not track time. Correct 48.  All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False?  Mark for Review (1) Points True False (*) Correct 49.  You are doing a data model for a computer sales company, where the price of postage is dependent on what day of the week goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?  Mark for Review (1) Points Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*) Email current price to all employees whenever the prices change. Update the prices in the system, print out the current prices when they change and pin them on the company noticeboard Allow them to enter whatever ever delivery charge they want. Correct 50.  Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?  Mark for Review (1) Points An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*) EMPLOYEE periods can overlap causing the database to crash. End Date must be before the Start Date. Dates must be stored with Time. Correct Page 5 of 5