mycw

4. A/an________ entity is not dependent on another entity for its existence.
7. A/an_______ entity is dependent on some other entity for its existence.
8. Set of rules/protocol to organize databases, reduces data redundancy (duplicate data).
10. In the Oracle APEX, the SQL _________ provides tools that enable you to view and manage database objects.
11. A _______ key is a primary key containing multiple columns. The combination creates a unique identification for each record.
13. The problems inherent in many-to-many relationship can easily be avoided by creating a composite entity or also referred as ______ entity.
14. _________ rules are used to understand business processes and the nature, role, and scope of the data.
15. A form where the relation is in 1NF and has no partial dependencies

1. Property or characteristic of an entity or relationship type (often corresponds to a field in a table).
2. ________ dependency is a relationship between two attributes in a relation. For each value of X, the same value of Y will always be found.
3. A text field is an example of an _______. (Oracle APEX)
5. The function is as containers for content. It can simply contain static HTML or it can be report based on a SQL query. It can contain items, buttons and navigation menu. (Oracle APEX)
6. To get started with using Oracle Application Express, the first step is to obtain an Oracle Application Express ______.
9. In referential integrity, ______ key always references an existing record in another table. These references must be maintained as tables are updated and deleted.
12. In SQL, to specify one or more columns on which to order the display we use ______.