Question: A possible DDL corresponding to Figure 3.1 is shown below: Discuss the following detailed design decisions: a. The choice of requiring NAME to be NON

A possible DDL corresponding to Figure 3.1 is shown below:

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.

NAME SSN HOMEPHONE VARCHAR(14) ADDRESS OFFICEPHONE VARCHAR(14) AGE GPA VARCHAR(30 NOT NULL CHAR(9) PRIMARY KEY, VARCHAR(40), INT DECIMAL(4,3

Step by Step Solution

★★★★★

3.48 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a This means that no Students can exist without a Name b This has a possible problem because there are some restrictions on using SSN as an identifier ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

888-CS-DB (2322).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Figure 8.19 shows tie operations that Alice must perform with POP to provide confidentiality, authentication, and integrity. Diagram the corresponding operations that Bob mat perform on the package...

1. Explain the advantages of locating the PRIDE database in the clouded. Flores and his partners could place it on one of their own servers in the practice. Give reasons why it would be unwise for...

Complete the SQL DDL definition of the bank database of Figure to include the relations loan andborrower. create table customer (customer-name char(20), customer-street char(30), customer-city...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

5, Putting Together an Evaluation Matrix An evaluation plan is a written document that describes the cWill/mat\Questions to ask yourself when putting together an evaluation matrix: Evaluation...

NASA/SP-2011-3422 Version 1.0 November 2011 NASA Risk Management Handbook NASA/SP-2011-3422 Version 1.0 NASA Risk Management Handbook National Aeronautics and Space Administration NASA Headquarters...

Based on Hambrick and Frederickson paper on Are you sure you have a strategy?, please explain in detail what strategic management is . I appreciate it if you please build up your explanations...

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

An advertisement similar to the following appeared in a popular Canadian business magazine.What legal obligations does it create for Star?

Linux runs on a variety of hardware platforms. What steps must the Linux developers take to ensure that the system is portable to different processors and memory-management architectures, and to...

If you are evaluating a project that has a cost of capital of 1 0 % and your analysis results in a positive NPV , which of the following statements is true? a . The IRR is higher than 1 0 % . b ....

An unfair fair game. Define random variables recursively by Y0 D 1 and for n 1, Yn is chosen uniformly on .0; Yn1/. If we let U1;U2; : : : be uniform on .0; 1/, then we can write this sequence as Yn...

What are the components of a disk block address?

Why are disks, not tapes, used to store online database files?

Consider the following decompositions for the relation schema R of Exercise 14.24. Determine whether each decomposition has (1) The dependency preservation property, and (2) The lossless join...

j Alicia (age 27) is a single, full-time college student. She earns $13,200 from a part- time job and has taxable interest income of $1,450. Her itemized deductions are $845. Calculate Alicias...

The balance sheet for Ferguson Corp. is shown here in market value terms. There are 7,000 shares of stock outstanding. Instead of a dividend of $1.80 per share, the company has announced a share...

Question 4 Which of the following is not one of the three empirically observed facts related to the yield curve? Approximately half of the time the yield curve will slope up and half of the time it...