You are required to write an opinion article (also known as an "op-ed" piece) for a technology magazine on the following topic:
Relational Database in the Era of Big Data
A number of alternative technologies such as NoSQL, Hadoop famework and Predictive Analytics applications are poised to facilitate big data management. Several years into the big data revolution, Relational Database still has a big presence and are not failing in this new era.
Why do you think? Present your thoughts and arguments in relation to why Relational Database are still strong in this new era even though it was predicted to fail.
Big data refers to a broad term for comprehensive data sets that are huge in size, unstructured in format and highly recurring in frequency. Due to these complexities in these data sets, it is widely believed that traditional data management applications including relational databases and SQL are inadequate to capture, store, analyse and visualise big data.
Your opinion piece (op-ed) should be no longer than 500 words.
You are required to extensively research on the relevant topics, take a stance (role of relational databases in big data) and present concise and workable arguments.
There is no requirement for formal in-text referencing in this question. However, it is recommended to put a list of references at the end of the article showing the published materials that you researched while writing this article.
The following E-R diagram represents the JustLee Books database. The script for the table creation is located on the Moodle website for the CIS2002 course under the assignment specifications. You will need to make sure that you re-run the script to reset the tables to their default state. see image. JustLee Book's table structures after normalization
In this question, you will use the JustLee books database. The JustLee database including appropriate data will be made available on the USQ Oracle server. You must use this data.
Full description of the JustLee database is found in Appendix A in the textbook on page 511. You may also get most of the details by using data dictionary on the oracle server.
Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT. A screen dump of the output is acceptable. Show as many rows as you can. A screen dump is usually done via the ALT + PRNT SCRN command sequence or use the Snipping Tool under windows to capture parts of the screen.
While the output helps to understand your solution, you should not be analyzing the output of the query in detail. As long as you are confident that your query corresponds to the question completely, your output may not be significant. You can have an output that says NO ROWS FOUND and it could be a perfectly valid output as long as your query fulfils the requirement. Explain why the query may not contain any output in this instance.
1.Display full name of all the customers in a single column in a format (LASTNAME, FIRSTNAME i.e. lastname followed by a comma and a space concatenated with firstname) and rename the field Customer Name, for all customers living in FL and WA state.
2.Display ISBN, Title and Retail of books in the BOOKS table where the book has discount and category does not start with letter C.
3.Display full name of all the Author in the AUTHOR table (by concatenating first name and last name eg. SAM SMITH) and the names should be in ascending order.
4.Display the ISBN, quantity, paid each price and total price (i.e. quantity * paideach) for all orders in the ORDERITEMS table where quantity is greater or equal to 2.
5.Display Customer Number, Ship Address (in a format 1201 ORANGE AVE, SEATTLE, WA 98114) and Ship cost for all orders that are getting shipped to FL and shipping cost is greater than 2.
6.Display the book title, cost, retail and calculate the profit and name the new field profit for all the books where the profit from the sale of the book is more than 30% of the cost of the book and has a discount which is at least 5% of the retail price of the book.
7.Display the book title, Publication date, Category, Cost and retail price after discount for books that have discount. Rename the new field Discounted Price and order by Publication date.
8.Display the Author Name, book title, cost and Category of the book.
9.Display Publisher name, Book title, publication date and Cost of the book for books with catgory COMPUTER or SELF HELP
10.List ISBN, title, retail, category and published date of all the books that have the (category of COMPUTER or where the category contains the string FAMILY anywhere in the category description) AND where (price of the books is more than 20 dollars and where the published date is after the end of the financial year for 2003/2004 i.e. 30 June 2004).
Construct data models for the following specifications. Include an ERD and a list of relations (entity list). Your relations must show all attributes, primary keys and foreign keys. You must use the USQ (Finkelstein) methodology as described in your Study Book, the lectures and the tutorials.
Question 1
A Gym records gym member details and their session with their personal trainers. Each member record consists of Member number, Name, Address, Contact number, Email Address, Date of Birth and Trainer ID if there is any. When a Member books a training session with their personal trainers, the system records the date and time of the session, Trainer ID, Member number, training duration and fees. Other details of Personal trainers include Trainer Name, Contact Number and Qualifications.
Question 2
A mattress must be assigned to a specific category but a category may apply to many mattresses. A mattress may be combined with many beds and a bed with many mattresses. A bed is made by one manufacturer but a manufacturer may make many beds. For mattress, we store the id number and brand name, while we store a category number and name for category. For bed, we store the brand name (unique), size, length and width. Each time a specific mattress is allocated to a bed, we need to store the comfort rating and the rating date.
Prepare the following for both questions:
1. An ER diagram: Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities but do not create entities that are not specifically covered by the specification. You must use the Finkelstein methodology as per the study book and tutorials.
2. A list of relations (entity list). Produce complete relations for all entities and attributes. Show all primary and foreign keys. Include all attributes that are specifically mentioned and all key attributes. You may need to create primary and foreign keys that are not specifically mentioned but do not create any other additional attributes.