220 CT Coursework 2020/2021
This is an induvial assignment. Please type everything neatly in a MS word file and submit to the Canvas System on time.
There are 5 tasks in this CW. They are all mandatory – Online submission no later than 23:59 on the last week of semester. This CW represents 50% of your total module mark.
Question #1: Database Design (This task is worth 20 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.
|Mission No.||Agency No.||Lead Agency||Country||Mission Date||Equipment||Qty||Item Weight||Total Weight|
|ISS-2237||178||JAXA||Japan||14/12/2013||Potable water dispenser||2||100kg||211kg|
|Flexible air duct||6||0.5kg|
|Small storage Rack||4||2kg|
|ISS-2356||167||NASA||USA||12/02/2014||Small storage Rack||3||2kg||69kg|
|Urine transfer tubing||2||1.5kg|
|ISS-1234||032||Roskosmos||Russia||16/04/2014||Small storage Rack||1||2kg||3kg|
|Flexible air duct||2||0.5kg|
Currently there is no database being used for managing the payload inventory information in the table above. It is therefore necessary to convert the inventory table into a set of database relations by applying and showing the process of normalization to determine the correct relations.
You are required to normalize the current data inventory to third normal form to produce appropriate relations (tables) for the database by providing the steps from UNF, 1NF, 2NF, to 3NF.It is also required to specify the primary and foreign keys for the 3NF tables. You will then be asked to implement the DB using a database of your choice (MySQL recommended).A script of database creation is required to be submitted too with record contents. The data contained inside the database needs to be retrieved by at least one simple query by mission no.Query script and screen dump of script execution would be expected to be submitted as evidence of successful query execution.
Activity 1: Put data in First Normal Form: Remove Repeating Elements or Groups of Elements in Data (3 marks)
Activity 2: Put data in Second Normal Form: Remove Partial Dependencies on a Concatenated Key in Data (3 marks)
Activity 3: Put data in Third Normal Form: Remove Dependencies on Non-Key Attributes / Final Database Design (4 marks)
Database creation script with integrity control (i.e. foreign keys): 7 marks
Data insertion / preparation script: 1.5 marks
Query script: 1.5 marks
Question 2– Database and Information Retrieval Systems (This task is worth 20 Marks)
Question 3– A data mining system for a bank (This task is worth 20 Marks)
A bank has been collecting data on their customers and has heard that use of data mining could increase their competitiveness. They would like you to create a brief report that explores the following.
Question 4: Your Big Data Idea (This task is worth 20 marks)
Identify and implement an idea that you have about how you’d use Big Data for advancedanalytics of retail chain stores such as managing customer relationship, finding new customers, and developing new products and services, finding a new trends that may facilitate understanding some scientific or engineering areas, etc.. Produce a short report the includes you have done in the following steps, your analysis results, data visualization and constructive comments / thoughts.
Question 5: Data Retrieval (This task is worth 20 marks)
Information Retrieval (IR) includes three main processes: Indexing, Searching and Ranking.
Refer to the following diagram, perform the tasks below:
(a) build an inverted index (indexing process) (12 marks),
(b) use the Boolean Retrieval Model to find file(s) which contains the words ‘Java’ and ‘SQLDev’ (searching process) (4 marks),
(c) rank the results based on relevance. (ranking process) (4 marks)
Advantages of using our writing services
Custom Writing From Scratch
All our custom papers are written by qualified writers according to your instructions, thus evading any case of plagiarism. Our team consists of native writers from the USA, Canada, and the Uk, making it convenient for us to find the best to handle your order.
Unlimited Free Revisions
If you feel your paper didn't meet all your requirements, we won't stop till it's perfect. You're entitled to request a free revision within 7 days after we submit your paper.
Quality Writing In Any Format
If you have issues with citing sources and referencing, you need not worry. Our writers are highly knowledgeable in referencing, including APA/MLA/Havard/Chicago/Turabian and all other formatting styles.
Fast Delivery And Adherence To The Deadline
All our custom papers are delivered on time, even the most urgent. If we need more time to perfect your paper, we may contact you via email or phone regarding the deadline extension.
Originality & Security
At Master Homework, your security and privacy is our greatest concern. For this reason, we never share your personal information with third parties. We use several writing tools to ensure your paper is original and free from plagiarism.
24/7 Customer Support
Our agents are online 24 hours a day, 7 days a week, and are always ready to serve you. Feel free to contact us through email or talk to our live agents whenever you need assistance with your order.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
We work nonstop to see the best client experience.
We offer pocket-friendly prices that coincide with the preferred client's deadline.
Admission help & Client-Writer Contact
Our support team is always ready to ensure vital interaction between you and the writer whenever you need to elaborate on something.
We deliver our papers early within the stipulated deadlines. We are glad to help you if there should be an occurrence of any alterations required.
Your review, positive or negative, is of great concern to us and we take it very seriously. We are, consequently adjusting our policies to ensure the best customer/writer experience.