Reference no: EM131054251
Consider a STUDENT relation in a UNIVERSITY database with the following attributes (Name, Ssn, Local_phone, Address, Cell_phone, Age, Gpa). Note that the cell phone may be from a different city and state (or province) from the local phone. A possible tuple of the relation is shown below:
a. Identify the critical missing information from the Local_phone and Cell_phone attributes. (Hint: How do you call someone who lives in a different state or province?)
b. Would you store this additional information in the Local_phone and Cell_phone attributes or add new attributes to the schema for STUDENT?
c. Consider the Name attribute. What are the advantages and disadvantages of splitting this field from one attribute into three attributes (first name, middle name, and last name)?
d. What general guideline would you recommend for deciding when to store information in a single attribute and when to split the information?
e. Suppose the student can have between 0 and 5 phones. Suggest two different designs that allow this type of information.
|
Annual rate of return on painting
: During 2010, an auction house sold a painting, at auction for a price of $1,010,000. Unfortunately for the previous owner, he had purchased it three years earlier at a price of $1,590,000. What was his annual rate of return on this painting?
|
|
Which is a release criteria used by the parole board
: Because of ______, many states have devised ways to get around the rigidity of mandatory release.
|
|
Identify the three forms of restructuring
: "Identify the three forms of restructuring within strategic management. In your answer explain why firms restructure, giving a detailed example for each form
|
|
Write a one-page resume for one person
: For each question. write a response according to the directions given by your instructor. Each response should contain correct grammar. spelling, and punctuation.
|
|
How do you call someone who lives in a different state
: Consider the Name attribute. What are the advantages and disadvantages of splitting this field from one attribute into three attributes (first name, middle name, and last name)?
|
|
Journal reports the asked price for the bond
: A government bond with a coupon rate of 8% makes semiannual coupon payments on January 9 and July 9 of each year. The Wall Street Journal reports the asked price for the bond on January 24 at 100:17. What is the invoice price of the bond? The coup..
|
|
Write a python program to demonstrate a theme for your robot
: Write a Python program to demonstrate a theme for your robot. Your team must think of something fc your robot to do using the sensors and/or motors.
|
|
What is the present value
: What is the present value of $13,750 to be received 4 years from today if the discount rate is 4.75 percent?
|
|
Differences between it and operational planning
: What is Strategic planning it's traits what it involves and the main differences between it and operational planning.
|