View the step-by-step solution to:

CH 10: PRACTICAL DATABASE DESIGN METHODOLOGY AND USE OF UML DIAGRAMS #10.22 - What are the current relational DBMSs that dominate the market?

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?
Sign up to view the entire interaction

Top Answer

Please see the attached... View the full answer

8441138.docx

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?
Answer:
The current...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online