Next Generation- AutoBusiness Rules: The Next Generation Auto is the vehicle manufacturing company. The company manufactures vehicles like car, truck, bike etc. The company consists of different divisions. Each division builtparticular type of vehicle. When a vehicle is to be built by a division they order for the vehicle parts that are needed to the purchasing officer of the company. The purchasing officer checks for the available stock in the company and then orders the supplier for the parts required by the division. Some of the business rules followed to develop the database are given below:a)Each division is uniquely identified by its unique id. The division information such as thename, contact person of the division and the phone number of the division are maintainedby the databaseb)The Company maintains the stock list of the parts. Each part is uniquely identified with the part_id. Each part is given a name and the number of parts available must be maintained in the database.c)The company is connected with many suppliers. Each supplier is identified by the unique supplier_id. The supplier information such as their name, contact information like phone number, Email address and postal address are maintained by the database.d)It is possible that a supplier can supply one or more parts to the next generation company and a part can be supplied by one or more supplier to the next generation auto company.e)Each orders placed by the division is maintained with the unique order_id. The database maintains information about the date the order was placed together with the id of the division that places the order.f)Each order placed by the division may contain one or more parts. The database maintains the information about the part description provided by the division in the order placementtogether with the required quantityEntity Relationship Diagram:The Entity relationship diagram (ERD) for the Next Generation Auto Company is shown below. The ERD shows the primary and foreign keys involved in each of the entity.