Normalize following table up to BCNF. In this example we extend the PropertyInspection database to include property inspection by members of staff. When staffs are required to undertake the inspections, they are allocated a company car for use on the day of the inspections. However, a car may be allocated to several members of staff as required throughout the working day. A member of staff may inspect several properties on a given date, but a property is only inspected once on a given date. StaffPropertyInspection
propertyNo iDate iTime pAddress comments staffNo sName carReg
PG4 18-Oct-00 10.00 6 Lawrence St Glasgow Need to replace crockery SG37 Ann Beech M231JGR
PG4 22-Apr-01 09.00 6 Lawrence St Glasgow In good order SG14 David Ford M533 HDR
PG4 1-Oct-01 12.00 6 Lawrence St Glasgow Damp rot in bathroom SG14 David Ford N721 HFR
PG16 22-Apr-01 13.00 6 Novar Dr. Glasgow Need to replace crockery SG14 David Ford M533 HDR
PG16 24-Oct-01 14.00 6 Novar Dr. Glasgow Good condition SG37 Ann Beech N721 HFR
a) Find all the candidate keys.
b) Determine the primary key
c) Find all the functional dependencies.
d) Get the first normal form
e) Get the second normal form
f) Get the third normal form g) Gent the BCNF normal form.

Ineed on this app i was at ambitious but then all of the sudden i got put back to about 30 points. is there something i can do about this, because i lost all of my progress in this app.

{asap} select the correct text in the passage. which line in this excerpt from jonathan swift's "a modest proposal" uses the rhetorical device of irony? and secondly, there being a round million of creatures in humane figure throughout this kingdom, whose whole subsistence put into a common stock, would leave them in debt two million of pounds sterling, adding those who are beggars by profession, to the bulk of farmers, cottagers and labourers, with their wives and children, who are beggars in effect; i desire those politicians who dislike my overture, and may perhaps be so bold to attempt an answer, that they will first ask the parents of these mortals, whether they would not at this day think it a great happiness to have been sold for food at a year old, in the manner i prescribe, and thereby have avoided such a perpetual scene of misfortunes, as they have since gone through, by the oppression of landlords, the impossibility of paying rent without money or trade, the want of common sustenance, with neither house nor cloaths to cover them from the inclemencies of the weather, and the most inevitable prospect of intailing the like, or greater miseries, upon their breed for ever. i profess, in the sincerity of my heart, that i have not the least personal interest in endeavouring to promote this necessary work, having no other motive than the publick good of my country, by advancing our trade, providing for infants, relieving the poor, and giving some pleasure to the rich. i have no children, by which i can propose to get a single penny; the youngest being nine years old, and my wife past child-bearing. lines highlighted: - there being a round million of creatures in humane figure throughout this kingdom, whose whole subsistence put into a common stock, would leave them in debt two million of pounds sterling, - they have since gone through, by the oppression of landlords, the impossibility of paying rent without money or trade, the want of common sustenance, with neither house nor cloaths to cover them from the inclemencies of the weather - i have not the least personal interest in endeavouring to promote this necessary work, having no other motive than the publick good of my country, - i have no children, by which i can propose to get a single penny; the youngest being nine years old, and my wife past child-bearing.

Excerpt from an enemy of the people henrik ibsen mrs. stockmann. (turns to the hall door, listening.) i expect that is mr. hovstad coming. billing. very likely. (peter stockmann comes in. he wears an overcoat and his official hat, and carries a stick.) peter stockmann. good evening, katherine. mrs. stockmann (coming forward into the sitting-room). ah, good evening--is it you? how good of you to come up and see us! peter stockmann. i happened to be passing, and into the dining-room). but you have company with you, i see. mrs. stockmann (a little embarrassed). oh, no--it was quite by chance he came in. (hurriedly.) won't you come in and have something, too? peter stockmann. i! no, you. good gracious--hot meat at night! not with my digestion, when peter stockmann enters, what does his physical appearance to reveal about his character?