Database implementation • You are to design and implement the ER model of assignment-1, including entities/associative entities, relationships and cardinalities, into a Microsoft Access database. You need to ensure that your database is compatible with MS Access 2007 for marking purpose. • You need to ensure that relations of your database meet 3NF. • Your database needs to include sample data to support the required SQL queries. 2. SQL query As a way to demonstrate success, you are to implement a series of queries on the database to reflect the business logic of the Best Deal. Note: You are to create the queries manually by using the SQL view of MS Access query builder to demonstrate your competency in SQL. Failing to do so may result in marks to be deducted. Query-1: List all the sellers to show: • The seller names • The seller addresses Query-2: List all the buyers to show: • The buyer names • The buyer addresses Query-3: List all the contact details of a seller or a buyer to show: • The buyer/seller name • The contact type e.g. email • The contact details e.g. [email protected] 2 Note: the seller name is a parameter to enter when executing this query in Microsoft Access. A seller or buyer could have more than one contact e.g. email, mobile and home phone. Query-4: List all the sellers and the products that they have already sold to show: • The seller name • The product brand, model , sold price and sold amount Query-5: List all the listings that have no bids to be put for them so far to show: • The product ID, brand and model • The listing numbers Query-6: List all the applications for all used phones to show • The product ID, brand and model • The data, call rates and network • The weekly rent • The application numbers Query-7: List sellers and the benefit they have made to show: • The customer name • The product ID, brand and model • The data, call rates and network • The weekly rent and contract weeks • The benefit that can be made in dollars Query-8: List all sellers who had obtained quick delivery comments to show: • The seller name • The complete comment 3. Query Report Generate a Microsoft Access report for the biggest bid of each listing to show: • The listing ID • The brand and model • The starting price of the listing and the biggest bid for it