Langsung ke konten utama

Postingan populer dari blog ini

Section 6 Quiz Database Design Oracle

Oleh
Section 6 Quiz             (Answer all questions in this section) 1.         Examine the following Entity and decide which rule of Normal Form is being violated: ENTITY: CLIENT ATTRIBUTES:     # CLIENT ID     FIRST NAME     LAST NAME     STREET     CITY     ZIP CODE  Mark for Review (1) Points             1st Normal Form.             2nd Normal Form.             3rd Normal Form.             None of the above, the entity is fully normalised. (*) 2.         A transitive dependency exists when any attribute in an entity...
17 komentar
Baca selengkapnya

Section 6 Quiz Oracle Database Programming with SQL

Oleh
Section 6 Quiz             (Answer all questions in this section)                                                             1.         Given the following descriptions of the employees and jobs tables, which of the following scripts will display each employee ï¾’ s possible minimum and maximum salaries based on their job title? EMPLOYEES Table: Name   Null?    Type EMPLOYEE_ID          NOT NULL     NUMBER (6) FIRST_NAME             VARCHAR2 (20) ...
41 komentar
Baca selengkapnya

Section 9 Quiz Database Design Oracle

Oleh
Section 9 Quiz             (Answer all questions in this section) 1.         When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two)     Mark for Review (1) Points                                     (Choose all correct answers)               Make all relationships mandatory             Make all relationships optional (*) ...
22 komentar
Baca selengkapnya