Week 1

Question 1

What is a database

Answer 1

A database is a collection of inter-related records(key word here is records)

Question 2

What is a Relational Database

Answer 2

This is a collection of tables that represents the data as well as the relationship between them.

Question 3

What is a DBMS (Database Management System)?

Answer 3

A DBMS is a collection of inter-related data and the set of programs to access that data

Question 4

What is the purpose of a database?

Answer 4

Database systems are designed to manage large bodies of information.

Question 5

What is the Primary Goal of a DBMS?

Answer 5

The primary goal of a DBMS is to store and retrieve database information in a convenient and efficient way.

It also considered the safety of the information stored

Question 6

What is Strategic Database Planning?

Answer 6

This is the strategic corporate effort to determine the information needs of an organization for an extended period into the future.

Question 7

What is the Importance of Database Planning?

Answer 7

It expresses management’s current understanding of information resources.

It identifies opportunities for better resource management and allocation, including collaborations amongst departments and divisions.

It can give employees a sense of direction, in terms of collecting and retrieving data relevant to whatever projects they’re working.

Question 8

What comes after the strategic database plan?

Answer 8

After the strategic database plan is completed and receives final approval, then plans for designing and implementing the database must be done

Question 9

What is the database developmental cycle

Answer 9

This is referring to the process of creating a strategic database plan and then designing and developing a database

Question 10

What are the 5 stages of the Database Development Life Cycle (P.F.R.C.I)

Answer 10

1.Preliminary Planning
2. Feasibility Study
3. Requirements Definition
4. Conceptual Design
5. Implementation

Question 11

A feasibility study is comprised of: (its three things)

Answer 11

● Technological
● Operational
● Economical

Question 12

What is an Attribute?

Answer 12

Attributes are characteristics of the entity e.g. name, dob, gender, etc represented by an oval

Question 12

What is an Entity?

Answer 12

Anything you wish to store information about. An entity must have attributes. an entity is represented by a rectangle

Question 13

What is a relationship between entities represented by?

Answer 13

A diamond

Question 14

What is an example of a multivalued attribute?

Answer 14

Phone number or Alias attribute(a person can more than one phone numbers or more than one Alias… e.g. bigs and blacks)

Question 15

what attribute is atomic

Answer 15

a single attribute, one value stored in, represented by a regular oval.

Question 16

describe a composite attribute

Answer 16

Holds a single value that can be broken down into smaller subparts, eg, name, name can be treated as one thing but what if you want to search by last name…you can break it down into smaller subparts eg fname, mname, lastname. Address is also a composite attribute.

Question 17

What is a derived attribute?

Answer 17

Derived attributes can be calculated by using other existing attributes. eg. age is derived from DOB represented by a dotted line oval.

Question 18

How are Unique Identify identified

Answer 18

underlined the name e.g. the attribute