DATABASE DESIGN REVISION (1-5)

Select the CORRECT software used for Database Management System.

• RDBUS

• ORACLE

• DBUSE

• REDHAT

Identify the activity that can be done in requirement analysis

• Design Database

• Conduct Survey

• Developing database

• Implementing database

Choose the level in the three-schema architecture that describe the structures and constraints for the whole database to the user

• Internal level

• External level

• Conceptual level

• Database level

Express the meaning of the following relational algebra in Figure given :

• Compute the intersection between the STUDENT and COURSE relations

• Compute the difference between the STUDENT and COURSE relations

• Compute the natural join between the STUDENT and COURSE relations

• Compute the union between the STUDENT and COURSE relations

Identify the type of key to represent the relationship between table

• Secondary key

• Candidate key

• Primary key

• Foreign key

Express the relational algebra operator to display StudID and StudName from Table below :

• 
• 
• 
• 

Identify the characteristic of data that is in First Normal Form (1NF).

• There is data redundancy

• Contains one or more repeating groups

• A column contains a value that is of a different type

• Each attribute contains one and only one atomic value

Identify the symbol for relationship in E-R Diagram

• Oval

• Triangle

• Diamond

• Rectangle

Figure below shows the relationship of entity PROFESSOR and SECTION. Choose the BEST suited answer for the relationship.

• A professor can teach many section and a professor not teaching any section.

• One section can only e taught by one professor and many professor can teach many section

• A professor does not need to teach a section at all and many professor can teach many section

• One section of a course can be taught by many professor and a professor teaching any section

Identify the CORRECT answer for Data Definition Language (DDL).

• Create and modify the structure of objects in database

• Manipulation of data inside the database

• Manage changes made by DML statement

• Control the user access to the database, table, views, procedure, function and package