Briefly describe the main purpose of normalization in database design. (3 marks) (6 marks) (b) Describe...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Briefly describe the main purpose of normalization in database design. (3 marks) (6 marks) (b) Describe the rules of one normal form (INF), 2 NF and 3 NF. (c) You work as an administrator in UCSI Pet shop, and your task is to record health history of pets that visited your shop. Evaluate each entity against the rules of normalization (from first normal form to third normal form) and present your answer in the form of relations. Figure 1 is the health history report. (16 marks) Pet ID 111 222 333 444 Pet Name Robby Spotty May Tweedy Figure 1. Health History Report Pet Age Pet Owner Pet Type Rabbit Cat Cat Dog 1 3 5 Tim Cook Monica Lee Wayne Terry Kim Visit Date & Time 1/3/2021, 3,30 pm 2/4/2021,2.00 pm 3/3/2021, 11.10 am 1/6/2021, 9.00 am Procedure 01- Rabies Vaccination 05-Heart Worm Test 08-Tetanus Vaccination 05- Heart Worm Test 01-Rabies Vaccination 01-Rabies Vaccination 20-Annual Check up 12-Eye Wash [Total: 25 Marks] Briefly describe the main purpose of normalization in database design. (3 marks) (6 marks) (b) Describe the rules of one normal form (INF), 2 NF and 3 NF. (c) You work as an administrator in UCSI Pet shop, and your task is to record health history of pets that visited your shop. Evaluate each entity against the rules of normalization (from first normal form to third normal form) and present your answer in the form of relations. Figure 1 is the health history report. (16 marks) Pet ID 111 222 333 444 Pet Name Robby Spotty May Tweedy Figure 1. Health History Report Pet Age Pet Owner Pet Type Rabbit Cat Cat Dog 1 3 5 Tim Cook Monica Lee Wayne Terry Kim Visit Date & Time 1/3/2021, 3,30 pm 2/4/2021,2.00 pm 3/3/2021, 11.10 am 1/6/2021, 9.00 am Procedure 01- Rabies Vaccination 05-Heart Worm Test 08-Tetanus Vaccination 05- Heart Worm Test 01-Rabies Vaccination 01-Rabies Vaccination 20-Annual Check up 12-Eye Wash [Total: 25 Marks]
Expert Answer:
Answer rating: 100% (QA)
The image shows a question from an examination or assignment about database normalization It contains three parts a b and c Part a asks for a brief de... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
Which type of linked list stores the address of the head node in the next painter of the last node? Your answer: Doubly linked list Q Hashed list Singly linked list Circular linked list
-
List any five examples of documented information required to be maintained in accordance with ISO 9 0 0 1 : 2 0 1 5
-
If Patty Shoemaker estimates that her $400 weekly grocery bill will increase at an annual inflation rate of 3%, what should her weekly grocery bill be in 2 years?
-
In the first case, the relationship between F and H is found to be inverse when the height decrease the area will increase, and the force will increase too. Therefore, I need a logical and practical...
-
Air, with stagnation conditions of 800 kPa and 100C, expands isentropically to a section of a duct where A1 = 20 cm2 and p1 = 47 kPa. Compute (a) Ma1; (b) The throat area; and (c) M. At section 2,...
-
Show that Eq. (4.58) can be used to prove Gauss' law, Eq. (4.57). In Eq. (4.58) In Eq. (4.57) rdy dz
-
A process design for the disproportionation of toluene to benzene and the xylene isomers is being completed. Your assistance is needed on the design of the liquid separation section. It has been...
-
Consider a venturi with a throat-to-inlet area ratio of 0.8, mounted on the side of an airplane fuselage. The airplane is in flight at standard sea level. If the static pressure at the throat is 2100...
-
Concord Corporation is analyzing its account balances for 2022. As of the end of 2022, a debit balance of $4500 remains in the Manufacturing Overhead account. What impact will this have on the...
-
Oasis Co., a U.S. shareholder, owns 100% of Shack Co. and 100% of Studio Co., both CFCs. Shack Co. has $300,000 of gross income, of which $50,000 is effectively connected income, and $30,000 is...
-
A startup small food retail company is opening its flagship restaurant in Time Square New York 1. Generate 6 problems or situations the company would face in starting business in time square with...
-
create a table to compare the scale, reasons, and potential legal settlements of incidents Marriott International (Nov 2018) Equifax (Jul 2017) Target (Dec 2013) Adobe (Oct 2013) Based on Rapid7 case
-
Communication 1. In the following chart, explain how you would use each of the below job designs in a fast food company. Job Design Explanation of use in a fast food company Job Simplification Job...
-
Client is a 36-year-old, White female. She is recently divorced with two children, 13 and 15. Client lives in West Phoenix where she has lived all her life. She completed high school and has taken...
-
Question 5 [10 Marks] Jonny Depp an audit senior at Amber Heard Pty Ltd, a large international audit firm. He has been asked by the audit partner to evaluate the following audit risks of a major...
-
Explain why most software development projects fail and what can be done to remedy that. (In APA)
-
The plane truss shown in the figure is subjected to an external force P. It is given that P = 70 kN, a = 2 m, and b = 3 m. a E DIN B BO a Ao TO H The magnitude (absolute value) of force (in kN) in...
-
Which task is performed by a book-keeper? A. Analysing the trading results B. Entering transactions in the ledger C. Preparing year-end financial statements D. Providing information for...
-
Greg died on July 1, 2012, and left Lea, his wife, a $50,000 life insurance policy which she elects to receive at $5,000 per year plus interest for 10 years. In the current year, Lea receives $6,200....
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-7. Ivan sold the following securities during the year and received a Form 1099-B that...
-
To correct the vision of a near-sighted patient, an optician needs to make a pair of eyeglasses using -3.0-diopter lenses. The lenses are plano-concave, and the front surface (that is, the surface...
-
A lens has an index of refraction of 1. 50 . Its left side curves outward with an absolute value of radius of curvature of \(0.15 \mathrm{~m}\), and its right side curves inward with an absolute...
-
You have a thin lens that is convex on both surfaces. The material of which the lens is made has index of refraction \(n=1.40\), and the radii of curvature are \(\left|R_{1} ight|=300 \mathrm{~mm}\)...
Study smarter with the SolutionInn App