Practical database design methodology and use of uml diagrams
Practical database design methodology and use
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?
Calculate the price of your order
Select your paper details and see how much our professional writing services will cost.
- Freebies
- Format
- Formatting (MLA, APA, Chicago, custom, etc.)
- Title page & bibliography
- 24/7 customer support
- Amendments to your paper when they are needed
- Chat with your writer
- 275 word/double-spaced page
- 12 point Arial/Times New Roman
- Double, single, and custom spacing
-
We care about originality
Our custom human-written papers from top essay writers are always free from plagiarism.
-
We protect your privacy
Your data and payment info stay secured every time you get our help from an essay writer.
-
You control your money
Your money is safe with us. If your plans change, you can get it sent back to your card.
How it works
-
1
You give us the detailsComplete a brief order form to tell us what kind of paper you need.
-
2
We find you a top writerOne of the best experts in your discipline starts working on your essay.
-
3
You get the paper doneEnjoy writing that meets your demands and high academic standards!
Get your own paper from top experts
Order nowPerks of our essay writing service
We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.
Frequently asked questions
Get instant answers to the questions that students ask most often.
See full FAQ