1Computer Science_10_Revision_Information Systems

Task1. Normalise this flat file database!

Task2. Create tables for the online-shop. Client needs to give his information to make an order.

Determine the entities and attributes

Which will be the relationship between the tables?

Define the key fields for each table

Explain the purpose of foreign keys

Task3.  Test

1.      A real-world object, observation, transaction, or person about which data are to be stored in a database.

A.    Entity

B.     Record

C.     Attribute

D.    Table

2.      Describes the value found in each field in a table. (Another word to define the term “field”)

A.    Record

B.     Attribute

C.     Table

D.    Entity

3.      Collection of all the facts related to one physical or conceptual entity; often referring to a single object or person, usually represented as a row of data in a table [1]

A.    Record

B.     Entity

C.     Primary key

D.    ERD

4.      What DBMS stands for?

A.    Database management system

B.     Database of Medicine and Science

C.     Database management standard

D.    Databank management system

5.      What data type will be appropriate for “Turkestan 2/1”?

A.    Text

B.     Counter

C.     Logic

D.    Address

6.      What data type will be appropriate for unique attribute in a table?

A.    Text

B.     Logic

C.     Counter

D.    Currency

7.      Refers to maintaining and assuring the accuracy and consistency of data in a database

A.    Privacy

B.     Data integrity

C.     ERD

D.    Security

A B A A A C B