PRACTICAL DATABASE DESIGN METHODOLOGY AND USE OF UML DIAGRAMS

profileProfArgeol
 (Not rated)
 (Not rated)
Chat

CH 10: PRACTICAL DATABASE DESIGN METHODOLOGY AND USE OF UML DIAGRAMS

#10.22 - What are the current relational DBMSs that dominate the market? Pick one that you are familiar with and show how it measures up based on the criteria laid out in Section 10.2.3?

10.23 - A possible DDL corresponding to Figure 3.1 is shown below:
CREATE TABLE STUDENT (
NAME VARCHAR(30) NOT NULL,
SSN CHAR(9) PRIMARY KEY,
HOMEPHONE VARCHAR(14),
ADDRESS VARCHAR(40),
OFFICEPHONE VARCHAR(14),
AGE INT,
GPA DECIMAL(4,3)
);

Discuss the following detailed design decisions:
a. The choice of requiring NAME to be NON NULL.
b. Selection of SSN as the PRIMARY KEY.
c. Choice of field sizes and precision.
d. Any modification of the fields defined in this database.
e. Any constraints on individual fields.

#10.24 - What naming conventions can you develop to help identify foreign keys more efficiently?

  • 10 years ago
100% perfect answer detailed work A1++Tutorial Always at Top student already got A+ score in it checked by copy scpe and Turnitin Plagiarism
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    practical_database_design_methodology_and_use_of_uml_diagrams.docx