Expected to use the University Harvard Referencing Style
Write a 1000 words report on database design and its implementation based on the scenario
below (65 marks)
The International Space Station (ISS) is a habitable artificial satellite in low Earth orbit. It is the
ninth space station to be inhabited by crews following previous orbital stations that were launched
by the US the former Soviet Union and later Russia. The ISS is intended to be a laboratory,
observatory and factory in space as well as to provide transportation, maintenance, and act as a
staging base for possible future missions to the Moon, Mars and beyond. In order to support the
crew and overall operation of ISS the space agencies in charge of running the station conduct
regular missions to launch spacecraft carrying payloads of essential or replacement equipment up
to ISS. A payload inventory, see table below, is recorded of each mission, consisting of the space
agency leading the mission and the equipment payload to be sent up to ISS. The overall weight of
the payload is also determined in order to calculate the fuel needed for orbital insertion of the
spacecraft to successfully rendezvous with ISS.
IMAGE OF DATABASE ATTACHED
Currently there is no database being used for managing the information in the table above. The report
should include the following:
A. An answer to the following question, together with a justification for the decision: In its current
form, it is a traditional database. Should you keep it that way?
B. The detailed process of implementing the database using SQL, including the normalisation of the
table (should that be required), the identification of the attributes, the Entity-Relationship
Diagram, and the use of SQL commands in order to create and populate the tables with data
WE’VE HAD A GOOD SUCCESS RATE ON THIS ASSIGNMENT. PLACE THIS ORDER OR A SIMILAR ORDER WITH PapersSpot AND GET AN AMAZING DISCOUNT
