REVISION DATABASE 1

1.                  Name the software that defines a database, stores data, produces reports and creates data entry screens.

• Data Integrity

• Data Dictionary

• Relational Database

•   Database Management System

2. 2.Identify the definition of database?

• software that manages data and information in relational table

• an organized collection of structured information, or data, typically stored electronically in a computer system

• Organized collection of fix data that cannot be updated

3. Identify which of the following is NOT an advantages of DBMS

• Increase data isolation

• Improve data security

•   Increase data consistency

• Increase data redundancy

4. 4.Identify the relation key that uniquely defines each row in a table.

• A.    Foreign Key

• Primary Key

• Super Key

• Composite Key

5.Identify the total number of attributes in a relational data model.

• Tuple

• Entity

• Degree

• Cardinality

6.Identify the CORRECT symbol of PROJECT in the Relational Algebra.

•     σ

•     ×

•     υ

•     π

7. Determine a relational algebra expression to find customers, who have a payment balance of over than RM1000.

•     π customer_name (σ balance>1000(Deposit))

• σ customer_name (π balance>1000(Deposit))

• π customer_name (σ balance<1000(Deposit))

• σ customer_name (σ balance>1000(Deposit))

8. 8.Choose the correct example of Database Management (DBMS) for desktop database.

• Oracle

• MySQL

• Microsoft Access

9.Identify the benefit of Desktop Database

• Any element can be upgraded when needed

• New technology can be easily integrated into the system.

• Simple functionality to modify and maintain the database

• Server can be accessed remotely and across multiple platforms

10."Produces a set of tuples that two relations share in common". Based on the above statement, identify the operation stated in relational algebra operator.

• Union

• Difference

• Intersection

• Cross product