Reference no: EM131418978
Project Assignment
Examine the following relation and its attributes and answer the following questions. Assume these are the values for "all time". Assume girls with the same name are the same person.
|
GIRL
|
GROUP
|
AGE
|
GAME
|
CATEGORY
|
PRICE
|
|
Charlotte
|
5 year olds
|
5
|
Mirror
|
Makeup
|
4.88
|
|
Susan
|
6 year olds
|
6
|
Lipstick Makeup
|
|
5.95
|
|
Jane
|
5 year olds
|
5
|
Chess
|
Games
|
7.55
|
|
Susan
|
6 year olds
|
6
|
Checkers
|
Games
|
5.95
|
|
Susan
|
6 year olds
|
6
|
Mirror
|
Makeup
|
4.88
|
|
Carrie
|
6 year olds
|
6
|
Lipstick Makeup
|
|
5.95
|
|
Jacqueline
|
5 year olds
|
5
|
Visual Basic
|
Prog. Languages
|
199.99
|
1) Is this relation in at least 1NF? Why or why not?
2) What is the primary key of the initial relation (assume the values shown are the only possible tuples for all time)? Remember that a primary key must be unique and not null.
3) Describe the specific data anomalies that exist if we DELETE the tuple containing Jacqueline.
4) Draw a functional dependency diagram for the initial relation. This diagram should agree with the primary key you selected in above.
5) Based on your diagram, what normal form is the initial relation in? Why?
6) If necessary, decompose the initial relation into a set of non-loss 3NF relations by showing the relations, attributes, and tuples. Show complete relations with attribute headings and all data values in the tuples of your relations. Determine the number of 3NF relations you end up with after normalization, write this number, and then circle the number.
|
Concept statement top-two-boxes respondent group
: What is the term used to describe the number or percentage of people who would buy a product or service and is used as an indicator of group reaction? Concept statement Top-two-boxes Respondent Group Response Situation.
|
|
Explain possible ethical dilemmas and governance issues
: Subject Matter - Organizational Strategy Proctor a... Bookmark Subject Matter - Organizational Strategy Proctor and Gamble: This is a huge multinational firm with products you probably buy every day. Explain possible ethical dilemmas and governance i..
|
|
How does this behavior compare to that of dr jekyll
: What does Frankenstein's behavior as he is creating the monster tell us about him and his state of mind - How do these changes connect to those of Dr. Jekyll after Jekyll loses control of his transformations?
|
|
Differences in expatriation and re-patriation process
: For this assignment you are required to research, explain and give examples that are specifically relevant to international HRM. You are also encouraged to use real life examples by reviewing secondary data on the IHRM strategies of organisations ..
|
|
Draw a functional dependency diagram for initial relation
: CMIS 320- Describe the specific data anomalies that exist if we DELETE the tuple containing Jacqueline. Draw a functional dependency diagram for the initial relation.
|
|
Problem regarding the changing economic condition
: 1) Discuss examples of how the changing economic condition has called for qualified employees who are flexible and willing to deal with rapid and unstructured changes. Give examples of impacts of economic changes on employees' and employers' expec..
|
|
What is white privilege and what is color blind
: SOCA 101 :What is "White privilege"? (provide definition and example) What is "color blind"? (provide definition and example) What is the factual relationship between the college scholarship distribution and race and ethnicity in the U.S.?
|
|
Process participants might be influenced in buying process
: Discuss how B2B (business to business) buying process participants might be influenced in the buying process? Why is it important for a business to try to quantify the expected benefits of implementing a solution to a problem? What should be containe..
|
|
Designing a total compensation plan
: Unsure of legal obligations in designing a total compensation plan, a client has asked you, as a human resources consultant, to explain how certain laws and regulations affect total compensation in their organization. The client's organization emp..
|