--Question 1

--Question 2

--Question 3

I'm trying to help my friend prepare for his college acceptance exam. it would mean a lot if you could help answer these questions.

Scenario Domingo Roof Works is a closed corporation based in Pretoria, in the Gauteng province. They specialise in turning lofts in houses into liveablerooms. Job types vary between simply fitting floorboards to full conversions with dormer windows, electrical fittings and staircases. When a customer requests a quotation, the work they want is classified by job type. One or more employee(s) will be assigned to the job. Each job will be allocated equipment and materials. Jobs are charged at a rate determined by the job type and how many days are needed to complete the job. BEFORE AFTER Source: https://i.skyrock.net/6904/85516904/pics/3224889183 1 2 r8gWhXe.jpg_[Accessed 14 November 2019) NO Below are samples of the hard copy records currently kept by Domingo Roof Works: Job Card Customer Address Job Type Material used No. days 11000 Tendai 3 Leos Place Full 7 90 x standard floor boards, Ndoro 457 Church Str Conversion 3 x power points, 20 metres standard electrical PRETORIA, 0002 wiring, Standard stairs pack 10478 Donald 408 Oubos Semi 2 50 x standard floor boards Puttingh 368 Prinsloo Street Conversion 1 x power points 10 metres standard electrical PRETORIA, 0001 wiring 14253 Tracy 206 Albertros Floor 2 40 x standard floor boards Samson 269 Stead Avenue Boarding PRETORIA, 0186 Job Customer Address Job Type No. Material used Card No. days 11258 Jacob Full Smith A201 Ocerton 269 Debouvirde Str PRETORIA, 0002 80 x standard floor boards 3 x power points 20 metres standard electrical wiring Standard stairs pack 12058 Thato 11 Luttig Court 289 MALTZAN Str PRETORIA, 0001 Semi Conversion Molepo 60 x standard floor boards 2 x power points 15 metres standard electrical wiring 136971 Dakalo 1182 CEBINIA Str Full Mudau PRETORIA, 0082 Conversion 80 x standard floor boards 4x power points 40 metres standard electrical wiring Standard stairs pack 10211 Sfiso Myeni 503 Hamilton Gardens Full 337 Visagie Str Conversion PRETORIA, 0001 100 x standard floor boards 5 x power points 30 metres standard electrical wiring Standard stairs pack 10471 Ricardo Keyl 10 Silville 614 Jasmyn Str Semi Conversion 40 x standard floor boards 1 x power point 8 metres standard electrical wiring PRETORIA, 0184 13521 Semi Smallboy Mtshali 307 FEORA East PRETORIA-WEST, Conversion 65 x standard floor boards 3 x power points 18 metres standard electrical wiring 0183 10102 Wilson 2 70 x standard floor boards 701 Monticchico Flat 251 Jacob Mare Str PRETORIA, 0002 Floor Boarding Jansen Employees assigned job cards Job Card No. Employee No. Names 11000 EMP 100 Albert Malose 11000 EMP920 Chris Byne 11000 EMP010 John Hendriks 10478 EMP920 Chris Byne Smallboy Modipa 14253 EMP771 11258 EMP681 Stanley Jacobs John Hendriks 11258 EMP010 11258 EMP771 Smallboy Modipa 12058 EMP681 Stanley Jacobs Rates by job type Job Type Daily Rate Full Conversion R1 200.00 Semi Conversion R1 080.00 Floor Boarding R900.00 Example of an invoice from Domingo Roof Works: Invoice Job Card No.: 12058 Customer Details: Thato Molepo, 11 Luttig Court, 289 MALTZAN Str, PRETORIA, 0001 Job Type: Semi Conversion Employees allocated: EMP681 Stanley Jacobs Equipment/Materials 60 x standard floor boards, 2 x power points, 15 metres standard electrical wiring Costs No. of days Job Type Semi Conversion Rate R1 080.00 3 Subtotal R3 240.00 VAT @14%: R453.60 Total: R3 693.60 Assessment: Assessment/ Marks Weight Duration deliverable Task 1 100 25% 15 hrs Produce an entity relationship model for the proposed database system for Domingo Roof Works. Use Integration Definition for Information Modeling (IDEF1X) standard. A. Complete the following task by working on a local MS SQL Server. Create all the tables using SQL. Show all your SQL scripts and the finished tables. Populate data on all the job cards and the details of those jobs. Show all your SQL scripts and give a listing of this table. Populate data for the members of employees including those listed in the scenario. Assign employees to job cards. Show all your SQL scripts and give a listing of this table. Populate data on the materials that are used on a job card. Show all your SQL scripts and give a listing of this table. Write a query that selects all the job cards and which employees have worked on them Write a query that selects the materials that have been used on job cards of type 'Full Conversion'. Write a query that selects all the job cards that Chris Byne has worked on. The Independent Institute of Education (Pty) Ltd 2020 Page 8 of 13 18; 19:20 2020 Write a query that shows all job cards that have taken place in addresses that contain '0001 or '0002 Write a query that counts the number of jobs that have used electrical wiring. Write a query that produces the output that could be used to prepare an invoice. This should include a calculation for VAT charged on a job card (calculated at 14% of total cost of the job card) Update the daily rate of pay for a Full Conversion to R1 440.00 Using information from Task 1 and 2, develop and deployon cloud (Azure platform) a web application that will serve as an interface for the Domingo Roof Works. Domingo Roof Works should be able to: Create new and retrieve Job Cards. Update job type daily rate. Create and retrieve invoice for the customers. Create, update and retrieve employee information. Deploy Web App on Azure Platform and is accessible on the Web. Scenario Domingo Roof Works is a closed corporation based in Pretoria, in the Gauteng province. They specialise in turning lofts in houses into liveablerooms. Job types vary between simply fitting floorboards to full conversions with dormer windows, electrical fittings and staircases. When a customer requests a quotation, the work they want is classified by job type. One or more employee(s) will be assigned to the job. Each job will be allocated equipment and materials. Jobs are charged at a rate determined by the job type and how many days are needed to complete the job. BEFORE AFTER Source: https://i.skyrock.net/6904/85516904/pics/3224889183 1 2 r8gWhXe.jpg_[Accessed 14 November 2019) NO Below are samples of the hard copy records currently kept by Domingo Roof Works: Job Card Customer Address Job Type Material used No. days 11000 Tendai 3 Leos Place Full 7 90 x standard floor boards, Ndoro 457 Church Str Conversion 3 x power points, 20 metres standard electrical PRETORIA, 0002 wiring, Standard stairs pack 10478 Donald 408 Oubos Semi 2 50 x standard floor boards Puttingh 368 Prinsloo Street Conversion 1 x power points 10 metres standard electrical PRETORIA, 0001 wiring 14253 Tracy 206 Albertros Floor 2 40 x standard floor boards Samson 269 Stead Avenue Boarding PRETORIA, 0186 Job Customer Address Job Type No. Material used Card No. days 11258 Jacob Full Smith A201 Ocerton 269 Debouvirde Str PRETORIA, 0002 80 x standard floor boards 3 x power points 20 metres standard electrical wiring Standard stairs pack 12058 Thato 11 Luttig Court 289 MALTZAN Str PRETORIA, 0001 Semi Conversion Molepo 60 x standard floor boards 2 x power points 15 metres standard electrical wiring 136971 Dakalo 1182 CEBINIA Str Full Mudau PRETORIA, 0082 Conversion 80 x standard floor boards 4x power points 40 metres standard electrical wiring Standard stairs pack 10211 Sfiso Myeni 503 Hamilton Gardens Full 337 Visagie Str Conversion PRETORIA, 0001 100 x standard floor boards 5 x power points 30 metres standard electrical wiring Standard stairs pack 10471 Ricardo Keyl 10 Silville 614 Jasmyn Str Semi Conversion 40 x standard floor boards 1 x power point 8 metres standard electrical wiring PRETORIA, 0184 13521 Semi Smallboy Mtshali 307 FEORA East PRETORIA-WEST, Conversion 65 x standard floor boards 3 x power points 18 metres standard electrical wiring 0183 10102 Wilson 2 70 x standard floor boards 701 Monticchico Flat 251 Jacob Mare Str PRETORIA, 0002 Floor Boarding Jansen Employees assigned job cards Job Card No. Employee No. Names 11000 EMP 100 Albert Malose 11000 EMP920 Chris Byne 11000 EMP010 John Hendriks 10478 EMP920 Chris Byne Smallboy Modipa 14253 EMP771 11258 EMP681 Stanley Jacobs John Hendriks 11258 EMP010 11258 EMP771 Smallboy Modipa 12058 EMP681 Stanley Jacobs Rates by job type Job Type Daily Rate Full Conversion R1 200.00 Semi Conversion R1 080.00 Floor Boarding R900.00 Example of an invoice from Domingo Roof Works: Invoice Job Card No.: 12058 Customer Details: Thato Molepo, 11 Luttig Court, 289 MALTZAN Str, PRETORIA, 0001 Job Type: Semi Conversion Employees allocated: EMP681 Stanley Jacobs Equipment/Materials 60 x standard floor boards, 2 x power points, 15 metres standard electrical wiring Costs No. of days Job Type Semi Conversion Rate R1 080.00 3 Subtotal R3 240.00 VAT @14%: R453.60 Total: R3 693.60 Assessment: Assessment/ Marks Weight Duration deliverable Task 1 100 25% 15 hrs Produce an entity relationship model for the proposed database system for Domingo Roof Works. Use Integration Definition for Information Modeling (IDEF1X) standard. A. Complete the following task by working on a local MS SQL Server. Create all the tables using SQL. Show all your SQL scripts and the finished tables. Populate data on all the job cards and the details of those jobs. Show all your SQL scripts and give a listing of this table. Populate data for the members of employees including those listed in the scenario. Assign employees to job cards. Show all your SQL scripts and give a listing of this table. Populate data on the materials that are used on a job card. Show all your SQL scripts and give a listing of this table. Write a query that selects all the job cards and which employees have worked on them Write a query that selects the materials that have been used on job cards of type 'Full Conversion'. Write a query that selects all the job cards that Chris Byne has worked on. The Independent Institute of Education (Pty) Ltd 2020 Page 8 of 13 18; 19:20 2020 Write a query that shows all job cards that have taken place in addresses that contain '0001 or '0002 Write a query that counts the number of jobs that have used electrical wiring. Write a query that produces the output that could be used to prepare an invoice. This should include a calculation for VAT charged on a job card (calculated at 14% of total cost of the job card) Update the daily rate of pay for a Full Conversion to R1 440.00 Using information from Task 1 and 2, develop and deployon cloud (Azure platform) a web application that will serve as an interface for the Domingo Roof Works. Domingo Roof Works should be able to: Create new and retrieve Job Cards. Update job type daily rate. Create and retrieve invoice for the customers. Create, update and retrieve employee information. Deploy Web App on Azure Platform and is accessible on the Web