The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to three coaches (offensive, defensive, and physical training coaches). During the season, each team plays two games (home and visitor) against each of the other teams. Given those conditions, do the following:   Your task Create an ERD for each of the above statements that describe the current business rules for JCBC: Use Crows Foot notations and include all of the following in each part: Include your student ID and full name under the ERD (in Draw.io) then copy the whole ERD as an image to your Word Document.

The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to three coaches (offensive, defensive, and physical training coaches). During the season, each team plays two games (home and visitor) against each of the other teams. Given those conditions, do the following:   Your task Create an ERD for each of the above statements that describe the current business rules for JCBC: Use Crows Foot notations and include all of the following in each part: All entities with Primary key and any foreign key attributes

You are considering the purchase of a new home offered at a price of $225,000. Create an amortization table in a new workbook that shows how much interest and principal you will pay each month for the duration of the loan. The following is a list of assumptions and requirements you need to consider for this assignment: 1. You will be making a down payment of 20% on the home (refer to Table 2.5 in the textbook for loan and lease terms). 2. The bank will offer you a loan at an annual interest rate of 5.5% for 30 years. 3. Your mortgage payments will be made at the end of each month. 4. You must construct the amortization table so that any change in the loan variables, down payment percent, length of loan, interest rate, and so on will automatically produce new outputs for each month of the amortization table. 5. The amortization table must show the interest payment, principal payment, and balance remaining to be paid on the loan for every month of the loan duration. The beginning balance…

The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to three coaches (offensive, defensive, and physical training coaches). During the season, each team plays two games (home and visitor) against each of the other teams. Given those conditions, do the following:   Your task Create an ERD for each of the above statements that describe the current business rules for JCBC: Use Crows Foot notations and include all of the following in each part: All entities with Primary key and any foreign key attributes;  The relationships between entities;  Identify the cardinality between teams and players and between teams and city  Draw the  Crow’s Foot ERDs to represent the JCBC database  Include your student ID and full name under the ERD (in Draw.io) then copy the whole ERD as an image to your Word Document.

Draw an ERD for the following problem:Company organized into departments. Each department has unique, name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations. A department controls a number of projects. Projects have a unique name, number and a single location. Company’s employees name, ssno, address, salary, sex and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; the immediate Supervisor for the employee. Employee’s dependents are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).

When a customer contacts the company to ask for an estimate, the proprietormakes a note of the customer’s contact details and an outline of the proposedwork. He agrees a date with the customer to view the property in order to givean estimate of the cost for the work. When visiting the property on the agreeddate the proprietor adds more detail to the outline of the proposed work. Within3 days of visiting the property the proprietor produces a fully detailed estimateand sends it to the customer. If the customer agrees the estimate, the proprietorschedules a date to start the job (this is based on the size of the job and otherjobs that have already been scheduled).A few days before the agreed start date of a job, the proprietor contacts thecustomer to confirm the start date, and then orders the required buildingmaterials from suppliers to be delivered on the date the job starts. At theend/completion of the job the proprietor calculates the actual cost of the job toproduce an invoice which…

University AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).can I know how to answer question a and b ?

University AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).

University AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).what is the input,process,output and pseudocode or flowchart for this question?