How can i apply normalization rules in the flowing database ? need help with N1,N2,N3,BCNF Student Stu_ID
Fantastic news! We've Found the answer you've been seeking!
Question:
How can i apply normalization rules in the flowing database ?
need help with N1,N2,N3,BCNF
Transcribed Image Text:
Student Stu_ID FirstName Last Name Gender Age Contact Number StudEmail Stud Pass Courses Course ID Course Name Schooly ear Schedule Sch_ID Course ID Stu ID Staff ID Subject ID Class Num Starting time Ending time Staff Staff ID First Name LastName Job Title Green - Primary Key Blue-Foreign Key Gender Age Contact Number StaffEmail StaffPass Subjects Subject ID Sub Name Course ID Student Stu_ID FirstName Last Name Gender Age Contact Number StudEmail Stud Pass Courses Course ID Course Name Schooly ear Schedule Sch_ID Course ID Stu ID Staff ID Subject ID Class Num Starting time Ending time Staff Staff ID First Name LastName Job Title Green - Primary Key Blue-Foreign Key Gender Age Contact Number StaffEmail StaffPass Subjects Subject ID Sub Name Course ID
Expert Answer:
Answer rating: 100% (QA)
Normalization is a database design technique that reduces data redundancy and ensures data integrity It involves organizing the columns attributes and tables relations of a database to ensure that the... View the full answer
Related Book For
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall
Posted Date:
Students also viewed these databases questions
-
An apartment complex has 100 units. The monthly profit (in dollars) from renting out apartments is given by the function P(z)--10x+1520x - 50000 How many units should be rented out to maximize...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Lopez Company uses a job order cost accounting system that charges overhead to jobs on the basis of direct material cost. At year-end, the Goods in Process Inventory account shows the following. 1....
-
The following data were obtained for flow of 20C water at 20 m3/hr through a badly corroded 5-cm-diameter pipe which slopes downward at an angle of 8: p1 = 420 kPa, z1 = 12 m, p2 = 250 kPa, z2 = 3 m....
-
As a financial analyst at Credit Suisse Corporate Finance desk, you are evaluating an option to purchase an equipment to expand the product line for the company. There are two machines meeting the...
-
A 6 cylinder, 4 stroke I.C. engine is to develop \(89.5 \mathrm{~kW}\) at \(800 \mathrm{rpm}\). The stroke to bore ratio is 1.25:1. Assuming mechanical efficiency of \(80 \%\) and brake mean...
-
A firm had the following values for the four debt ratios discussed in the chapter: Liabilities to Assets Ratio: less than 1.0 Liabilities to Shareholders Equity Ratio: equal to 1.0 Long-Term Debt to...
-
addi x1,x0, 0xFEA addi x2,x0, x0 addi x3,x0, 0x010 sw x1, 0(x3) Ibu x2, 2(x3) Iw x4, 0(x3) What are the values for: x1=? x2=? x4=?
-
Futoshiki is a Sudoku-like Japanese logic puzzle that is very simple, but can be quite challenging. You are given an n x n grid, and must place the numbers 1, . . . n in the grid such that every row...
-
Making a good decision A) requires probabilities for all states of nature. B) requires a clear understanding of decision alternatives, states of nature, and payoffs. C) implies that a desirable...
-
Four years ago, Nopay Inc. paid a dividend of $ 0 . 8 0 per share. Today Nopay paid a dividend of S 1 . 6 6 per share. It is expected that the company will pay dividends growing at this same rate for...
-
2. Write a program that calculates the tip amount and total amount for a bill at a restaurant. Declare variables bill of type double, totalBill of type double, and tipRate of type int. Calculate and...
-
Imagine the coffee shop market in a mid-sized city had the follow the following market share breakdown? Firm "A": 50% Market Share Firm "B": 20% Market Share Firm "C": 15% Market Share Firm "D": 14%...
-
turkish govermnet is now planning to initiate a national budget savings program to construct "canal istanbul". Auction will be announced just after 5 yeras from now. Consortiums, each made up of 3...
-
Instead of stop-loss reinsurance, the insurer is evaluating changing to coinsurance, whereby it will pay a portion of the losses and transfer the rest to the reinsurer. If the insurer keeps 75% of...
-
For the cantilever beam shown A) Derive the equation of motion. B) Determine the natural frequency C) Determine x(t) if for the given initial conditions 1m 8-210-10 N/m 1-1.610 m 150 kg T. x(0)-0.015...
-
Tiger, Inc. signed a lease for equipment on July 1, 2007.The lease is for 10 years (the useful life of the asset).The first of 10 equal annual payments of $500,000 was made on July 1, 2007.The...
-
Raul Esparza, the ecommerce manager for Moonlight Mugs, a company that sells customized coffee mugs, would like to send information to another company that maintains the warehouse and provides...
-
What information about the decision maker does the analyst seek to gain from observation?
-
Gregg Baker orders tickets for two concerts over the Web. His orders are processed, exact seat locations are assigned, and the tickets are mailed separately. One of the sets of tickets gets lost in...
-
A drainage ditch is to be built to carry runoff from a subdivision. The maximum design capacity is to be $1 \mathrm{million} \mathrm{gph}(\mathrm{gal} / \mathrm{h})$ and it is to be concrete lined....
-
An open drainage canal with a rectangular cross section is $3 \mathrm{~m}$ wide and $1.5 \mathrm{~m}$ deep. If the canal slopes $950 \mathrm{~mm}$ in $1 \mathrm{~km}$ of length, what is the maximum...
-
An open drainage canal is to be constructed to carry water at a maximum rate of $10^{6} \mathrm{gpm}$. The canal is concrete lined and has a rectangular cross section, with a width that is twice its...
Study smarter with the SolutionInn App