Part 1: Please recognize the office declaration beneath and drag ER, NER, and Table Schema diagrams control it.
The plan is environing developing an auction Web office. The elements are as follows:
BA is an online auction Web office. Herd can bribe and hawk individuals in this Web office. Bribeers are herd who approve to bribe individuals, and hawkers are herd who approve to hawk individuals.
Each hawker can hawk individuals.
Each individual has a order rouse period, an purpose period, and an possessor. Hawkers are possessors of
their individual. The rouse period and purpose period enclose the time as courteous.
Each hawker has a indicate, contiguity notification, and honor card notification. They as-well accept a user indicate and a password.
Contiguity notification consists of an oration, an email, and a telephone.
An oration consists of a street enumerate and indicate, city, recite, and zip command.
Honor card notification consists of possessor indicate, card enumerate, and spiritlessness time.
Each individual has a indicate, circumstances, an primal figure, a designation, share, undivided or past pictures, and an possessor.
The circumstances could be New, Refurbished, or Interpreted. If the circumstances of an individual is cemal to Interpreted, the hawker should interpret environing the individual circumstances in the individual designation.
Each bribeer has a indicate, contiguity notification, and honor card notification. They as-well accept a user indicate and a password.
When bribeers login to Web office, they can go to the roll of full beneficial individuals and then go to the individual element page. Bribeers can as-well exploration control an individual. The contact accomplish exploration through individual indicates control the exploration specialty.
Buyers can command on individuals. Once a command is made, bribeers are answerable control their command. In other language, bribeers cannot singly separate their command. If they transmute their understanding, full they can do is to uptime their command with the figure of nothing. Of series, they can do that precedently the auction expires.
After an auction expires, the bribeer with the highest command is the winner.
Part 2: Please transcribe SQL Query control each declaration beneath.
• BA approves to accept a cemal of statistics environing the rule as follows:
The most free hawker (the undivided who has offered the most enumerate of individuals)
The most free bribeer (the undivided who has bought the most enumerate of individuals)
The most dear individual sold ever
The most dear individual beneficial
The cheapest individual sold ever
The cheapest individual beneficial