onsider the following scenario and answer the questions below. ustomers wishing to claim after an accident should visit the insurance company within 2 ays. The insurance company will take details of the location of accident, date and time, port_no. The details of the car and the driver should also be provided. The customers he or more cars each. Each car has associated with it zero to any number of recorded cidents. The driver may have met with one or more accidents. The driver has driver ID ame, license and address. The car has serial_no, model and year manufactured. List the entities with their corresponding attributes. Draw an E-R diagram for a car-insurance company.

Need help identifying and establishing Primary keys and foreign keys

DATABASE SYSTEMS   AllTaste Restaurant is a restaurant that is famous for its taste, so it has a lot of customers. All the flavors are here, serving typical archipelago food that has spread in several cities with various mainstay menus. However, even though it already has many branches and a large number of order transactions every day, AllTaste Restaurant does not yet have an application and database to manage transactions and data. Order recording and sales reports are still done manually. AllTaste Restaurant owners know that information technology can support their business, so they plan to build applications to serve food orders both offline and online. In the database design stage, it is known as bottom-up, top-down, and inside-out approaches. Explain the three approaches! In your opinion, what approach is used for database system development at AllTaste Restaurant? Explain why you chose this approach! What techniques do you use to collect information (fact-finding technique)?…