database and queries ...

everthing explained in the attached file ... must be done within 24 hr .. Scenario Beetle Antiques are an antiques trading company based in Telford, England. They want you to design and implement a database that meets the requirements for their data. These requirements are specified in this scenario and examples of paper documents kept by the company are shown below. Beetle Antiques are a high end antique trading company. They need to keep detailed records of the items that they stock and sell. All items are classified by type, manufacturer and country of origin. It is also important to keep track of who has owned the items over the years. There might be many owners over the years. When items are valued, Beetle Antiques use valuers from other companies. They will get at least 3 valuations and keep track of these and note the valuer and the company they work for. Below are samples of the paper records currently kept by Beetle Antiques.