same idea for solution in below

The Motor Vehicle Department Database Design an entity-relationship diagram and build the design using a data modeling tool such as Visio. . The Motor Vehicle Branch administers driving tests and issues driver's licenses. Any person who wants a driver's license must take a learner's exam at any Motor Vehicle Branch in the province. . If he/she fails the exam, he can take the exam again any time after a week of the failed exam date, at any branch. o If he passes the exam, he is issued a license (type = learner's) with a unique license number. A learner's license may contain a single restriction on it. The person may take his driver's exam at any branch any time before the learner's license expiry date (which is usually set at six months after the license issue date). o If he passes the exam, the branch issues him a driver's license. . A driver's license must also record if the driver has completed driver's education, for insurance purposes. Student Name: Section #: Grade: The following list itemizes the major requirements for a banking enterprise: The bank is organized into branches. Each branch is located in a particular city and is a identified by a unique name. The bank monitors the assets of each branch. Bank customers are identified by their customer-id values. The bank stores each customer's name, and the street and city where the customer lives. Customers may have accounts and can take out loans. A customer may be associated with a particular banker, who may act as a loan officer or personal banker for that customer. Bank employees are identified by their employee-id values. The bank administration stores the name and telephone number of each employee, the names of the employee's dependents, and the employee-id number of the employee's manager. The bank also keeps track of the employee's start date and, thus, length of employment. The bank offers two types of accounts-savings and checking accounts. Accounts can be held by more than one customer, and a customer can have more than one account. Each account is assigned a unique account number. The bank maintains a record of each account's balance, and the most recent date on which the account was accessed by each customer holding the account. In addition, each savings account has an interest rate, and overdrafts are recorded for each checking account. A loan originates at a particular branch and can be held by one or more customers. A loan is identified by a unique loan number. For each loan, the bank keeps track of the loan amount and the loan payments. Although a loan payment number does not uniquely identify a particular payment among those for all the bank's loans, a payment number does identify a particular payment for a specific loan. The date and amount are recorded for each payment, . . In a real banking enterprise, the bank would keep track of deposits and withdrawals from savings and checking accounts, just as it keeps track of payments to loan accounts. Since the modeling requirements for that tracking are similar, and we would like to keep the example application small, we do not want to keep track of such deposits and withdrawals in the model. Design an entity-relationship diagram for the BANK database and build the design using a data modeling tool such as Visio. LAB2_Solution Nacinn an entity-relationship diagram for the BANK database and build the design using odeling tool such as Visio. 2 2 ENC - 212 Computer Applications Lab LAB # 2: Enhanced Entity Relationship (EER) Model branch-city branch-home branch assets Jam-branch Customer-me payment-date Columbo payment-membe payment amount customer-street customer loan-sumber customer-city MO customer borrower LON loan payment payment access-date balance cuest-banker type depositor account manager ceployee toorks for ISA worker employee-dd Employment Strings account clarking-accesort Clandet (Turne-rial Employment lerigth... start-date - interest-rate overdraft-amount