Expected to use the University Harvard Referencing Style<\/p>\n
Write a 1000 words report on database design and its implementation based on the scenario
\nbelow (65 marks)
\nThe International Space Station (ISS) is a habitable artificial satellite in low Earth orbit. It is the
\nninth space station to be inhabited by crews following previous orbital stations that were launched
\nby the US the former Soviet Union and later Russia. The ISS is intended to be a laboratory,
\nobservatory and factory in space as well as to provide transportation, maintenance, and act as a
\nstaging base for possible future missions to the Moon, Mars and beyond. In order to support the
\ncrew and overall operation of ISS the space agencies in charge of running the station conduct
\nregular missions to launch spacecraft carrying payloads of essential or replacement equipment up
\nto ISS. A payload inventory, see table below, is recorded of each mission, consisting of the space
\nagency leading the mission and the equipment payload to be sent up to ISS. The overall weight of
\nthe payload is also determined in order to calculate the fuel needed for orbital insertion of the
\nspacecraft to successfully rendezvous with ISS.<\/p>\n
IMAGE OF DATABASE ATTACHED<\/p>\n
Currently there is no database being used for managing the information in the table above. The report
\nshould include the following:<\/p>\n
A. An answer to the following question, together with a justification for the decision: In its current
\nform, it is a traditional database. Should you keep it that way?<\/p>\n
B. The detailed process of implementing the database using SQL, including the normalisation of the
\ntable (should that be required), the identification of the attributes, the Entity-Relationship<\/p>\n
Diagram, and the use of SQL commands in order to create and populate the tables with data<\/p>\n
![\"\"](\"https:\/\/homeworkaider.com\/wp-content\/uploads\/2019\/11\/weer.png\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"