Implementation for Renewable Energy Database Design Assignment

Assignment Task

You have been engaged as a database consultant for the following organization.

“Power House” are at the cutting-edge in supplying small-footprint, eco-friendly power and lighting solutions to private home owners and small businesses, especially those in rural areas. They have also found a niche market in supporting the emergency services in on-site crime-scene and disaster-recovery situations where there is an urgent need for power and light at all hours of the day, often in remote or difficult to reach locations.

Their clients come to them for different reasons. Sometimes it is to save money on power bills, sometimes it is through a desire to minimize their impact on the environment and sometimes it is just easier and more convenient to use their small- scale, highly mobile technologies, which include wind, water, wave, tidal, solar and biofuel systems.

Typical situations would be installing a bank of solar power panels on a domestic user’s roof to reduce their utility bill, constructing a wind turbine on a hill on a farm in a remote location to allow the farmer to sheer his sheep in the field rather than bring them down off the hill into the barn, building a small-scale hydro-electric plant for a distillery in the Scottish Highlands to power their bottling facilities or perhaps to supply mobile biofuel generators to power and light emergency equipment in remote locations like cave extractions or crime-scenes. The company build some equipment themselves but also buy-in supplies as needed from their network of suppliers. The company has a fleet of vehicles used by the installation engineers, a series of warehouses dotted around the UK plus a head office in London.

Many green technologies attract government grants and other financial support, so the company works with their clients to claim such refunds. Sometimes, the installation of their technologies allows the client to actually generate a surplus of electricity and this can be returned to the national grid and sold back to the utility companies for a profit. Again, the company can provide specialist equipment to return that power back and help the client claim the money due.

The company are keen to ‘give back’ to the wider community and to that end they partner with several universities on research partnerships looking at optimizing existing green technologies or looking at emerging ones. This aspect involves grant applications to various research agencies and working closely with the university partners.

Final Point

The organisation needs a database to run all the above operations. Your job is to design and build this database. The above is simply an outline of the company and you will need to make your own assumptions and interpret or even extend the scenario as you go. Use your imagination as you see fit, but you must clearly document all assumptions and extensions.

The specific tasks you need to satisfy are listed below…

Question 1

• Develop a semantically rich data model that captures the above scenario in the form of an entity-relationship diagram (ERD). You should note (and number) all assumptions you make about the data and the reasoning behind your design choices. Also, include (and number) any appropriate constraints and a list of entity types showing their attributes and identifiers. 
• Once your ERD is complete, you should look for opportunities to use the entity sub-typing concept and thus develop an EERD 

Question 2 

• Once you are satisfied that the EER diagram is a good representation of the organisation’s data requirements, produce a logical design by mapping the EER diagram to a set of relations, showing all primary and foreign keys clearly. 
• Now produce a normalized relational model by checking each relation is in third normal form (3NF). You should clearly annotate and explain this process.
• Under what circumstances would it be necessary to de-normalize this model?

Question 3

Name and briefly discuss three Database Management Systems (DBMS) that could be used to implement a solution to your proposed database design. Decide on an appropriate DBMS that you wish to use for this project. Provide an argument for using this system rather than others that could be used and remember to relate your reasons to the actual scenario. Be sure to fully reference any external sources used.

Question 4

• Take each of the normalized relations and implement them as SQL tables using your chosen DBMS from the previous task with a series of CREATE TABLE statements. You must include all primary and foreign keys as well as any other table or column constraints you feel are appropriate such as NOT NULL, CHECK, UNIQUE and DEFAULT. Provide screenshots of the working code. Ensure your user name or some other distinguishing aspect is included in the screenshot to verify it is your code 
• Using appropriate sample data and your own imagination based on this case study, populate your finished tables with at least 10 rows of data in each Provide screenshots of the working code. When done, display the full contents of each populated table to screen and take screenshots. Ensure your user name or some other distinguishing aspect is included in the screenshot to verify it is your code. 
• To demonstrate that your final database is useful, write a set of realistic sample SQL queries based on the above scenario (use your imagination for details of each query) but they should include the following techniques:
• Joins (using two, three or more tables)
• Ordering output 
• Grouping output 

This It Computer Science have been solved by our PhD Experts at My Uni Papers. Our Assignment Writing Experts are efficient in providing a fresh solution to this question. We are serving more than 10000+ Students in Australia, the UK, and the US by helping them to score HD in their academics. Our Experts are well-trained to follow all marking rubrics and referencing styles.
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 you could choose one between the two and acquire an HD either way. You could choose a 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.