Floor Plans for a Two-Storey office Block - Engineering Assignment Help

Assignment Task

Task
The ground floor of the office block has a car park with 12 spaces, each labelled with a name e.g. A1, A2, A3 etc. The first floor has a section for the lift & stairs, reception, break room and office area, with a hallway that runs through the top of the first floor and connects the north side (where the reception, lift and stairs area are) to the south (where there is a shared office area). In both the ground and first floor, the coordinates for each section of the layout are included in the floor plans. For example, on the ground floor, the coordinates for the parking space labelled C3 is defined with the  coordinates ((2 4, 3 4, 3 6, 2 6, 2 4)). The first floor of the office block contains a section labelled as Open area. On the ground floor, this area has no roof, meaning that if you stand in the area labelled Hallway on the first floor and face east, you can see a section of the ground floor beneath.
i. Your first task is to create a spatial database using the coordinates for each area on both floors. Implement your design as a MySQL database using the spatial datatypes available with MySQL. Refer to Exercise 6 of practical 9 as required. Once you have created your database, export it as an SQL script using the export tab on phpMyAdmin. Copy and paste the contents of this script into your submission document for this assignment. (5)
ii. You second task is to write an SQL query to list the parking spaces on the ground floor directly beneath the Office area on the first floor. Write this query in SQL script and include it in your submission document. (3)
iii. Your third task is to write an SQL query to list the parking slots which are visible from standing in the Hallway on the first floor and facing east. State any assumptions you make.
 

This Engineering Assignment has been solved by our Engineering Experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.