QUESTION 1 In a Student entity, social security number, student ID and drivers l

Question

QUESTION 1

In a Student entity, social security number, student ID and drivers license are considered to be:

Primary Keys

Candidate Keys

Secondary Keys

Foreign Keys

2 points   

QUESTION 2

A Relational Database is a structured that stored data classified in attributes or columns and recorded in rows.

True

False

2 points   

QUESTION 3

A statement that describes policies, procedures & processes, establish entities relationships and constraints are said to be:

Tables

Standards

Procedures

Business Rules

2 points   

QUESTION 4

The document that describes interfaces between databases and applications is:

database

database management system

structured query language

interface control document

3 points   

QUESTION 5

In a Student entity, once the student ID is selected as the primary identifier, it becomes the:

primary key

secondary key

alternate key

foreign key

2 points   

QUESTION 6

A database is a collection of related data.

True

False

2 points   

QUESTION 7

Image is a representation of an:

attribute diagram

database

SQL

entity relationship diagram

2 points   

QUESTION 8

Match the terms with the correct meaning.

Entity

Attribute

Row

Database

DBMS

Primary Key (PK)

Foreign Key (FK)

Index

SQL

Metadata

Characteristics of an entity - Also known as column or field.

Software designed to create, process and manage databases.

Person, place, thing or event for which data will be saved in a database.

Unique identifier.

Collection of interrelated tables.

Command-based standard.

Improve performance for ease of access.

Establish relations.

Data about the structure of a database.

Instances of data sets. Also known or referenced as record.

Primary Keys

Candidate Keys

Secondary Keys

Foreign Keys

Explanation / Answer

1. PRIMARY KEY, IN A STUDENT ENTITY, SOCIAL SECURITY NUMBER, STUDENT ID AND DRIVER LISENCE ARE CONSIDERD AS A PRIMAR KEYS.

2. true, relational database is a structured that store data classified in a attributes or column and recorded in a row.

3. business rules, business rule is the statement that describe policies, procedures and processes , establish entities, relationship and constraints etc.

4. interface control document , the document that describe interface between data and application is called interface control document.

5. primary key , in a student entity, once the student ID is selected as primary identifier , then it become the primary key.

6. true, yes database is the collection of related data.

7. 1. Entity-------C

2. ATTRIBUTE--------A.

3. ROW-------E

4. DATABASE--------J

5. DBMS-------B

6. PRIMARY KEY-------D

7. FOREIGN KEY--------H

8. INDEX-----F

9.SQL-------G

10 METDATA---I

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.