Computer science i want the solution plz

. . 4:34 49 Microsoft Acces... King Saud University College of Business Administration MIS Department Ind semester 2021 201 MIS (Lab Assignment - Microsoft Access) Instructions: 1. The assignment starts from Wednesday 20 Oct, to 30 Oct. 2. Each Student should work individually. 3- It contributes 3 marks of the total 10 lab marks. Open Microsoft Access and create database with name "Stores Database". A. Create the following tables: Branch Table B-id (Number-primary key) B-name (text) B-city (text) 2 AA1 Riyadh 3 Jeddah 5 BW2 Dammam 7 DR1 Hail Employee Table E-id (Number-primary FirstName Last Name Salary B-id key) (text) (text) (currency) (Number-Foreign key) Employee-Biography table E-Id(Number Place-Of-Birth Nationality (text) Gender (text) Primary key) (text) B. Do the following: (1 point) 1. Create relationship between (Branch table and Employee table) 2- Create relationship between (Employee table and Employee - Biography table) 3- Insert at least 5 employees in each Branch. 4- Insert Biography information for each employee. C. Queries (1 point) Create the following Queries: 1. Q1: Retrieve First name, last name, and salary for each employee. 2- Q2: Retrieve the first name and last name for the loyee that work in branch that located in Jeddah. 3- Q3: parameter query to retrieve all employee information by entering the branch name. D. Forms and Report (1 point) 1- Create Form that display each Employee information 2- Create Report that display each Branch information Good luck, . . 4:34 49 Microsoft Acces... King Saud University College of Business Administration MIS Department Ind semester 2021 201 MIS (Lab Assignment - Microsoft Access) Instructions: 1. The assignment starts from Wednesday 20 Oct, to 30 Oct. 2. Each Student should work individually. 3- It contributes 3 marks of the total 10 lab marks. Open Microsoft Access and create database with name "Stores Database". A. Create the following tables: Branch Table B-id (Number-primary key) B-name (text) B-city (text) 2 AA1 Riyadh 3 Jeddah 5 BW2 Dammam 7 DR1 Hail Employee Table E-id (Number-primary FirstName Last Name Salary B-id key) (text) (text) (currency) (Number-Foreign key) Employee-Biography table E-Id(Number Place-Of-Birth Nationality (text) Gender (text) Primary key) (text) B. Do the following: (1 point) 1. Create relationship between (Branch table and Employee table) 2- Create relationship between (Employee table and Employee - Biography table) 3- Insert at least 5 employees in each Branch. 4- Insert Biography information for each employee. C. Queries (1 point) Create the following Queries: 1. Q1: Retrieve First name, last name, and salary for each employee. 2- Q2: Retrieve the first name and last name for the loyee that work in branch that located in Jeddah. 3- Q3: parameter query to retrieve all employee information by entering the branch name. D. Forms and Report (1 point) 1- Create Form that display each Employee information 2- Create Report that display each Branch information Good luck