DATABASE MANAGEMENT Coursework

Notes and Advice

●                 The Extenuating Circumstances procedure is there to support you if you have had any circumstances (problems) that have been serious or significant enough to prevent you from attending, completing or submitting an assessment on time.

●                 ASDAC are available to any students who disclose a disability or require additional support for their academic studies with a good set of resources on the ASDAC moodle site

●                 The University takes plagiarism seriously. Please ensure you adhere to the plagiarism guidelines. And watch the video on Plagiarism

●                 Any material included in your coursework should be fully cited and referenced in APA 7 format. Detailed advice on referencing is available from the library

●                 Any material submitted that does not meet format or submission guidelines, or falls outside of the submission deadline could be subject to a cap on your overall result or disqualification entirely.

●                 If you need additional assistance, you can ask your personal tutor, student engagement officer ana.baker@port.ac.uk

, academic tutor xia.han@port.ac.uk or your lecturers.

The portfolio is made up of two components:

 

Please note: Assessment 1 is Individual while assessment 2 is in group of 3-4. Please contact me by the week ending 13^th November, 2020 if you have failed to find a group.

Submit via Moodle

 

 

 

Assessment 1

Essay on a particular topic

Hand in: Friday 27th November 2020

 

Individual report titles

Select one of the topics listed below.

 

A maximum of 5 students can attempt each topic; you will be prompted for a choice of topic during one of the workshop sessions.

The report should contain around 1500 words. Please ensure it is properly referenced and you should follow the guidance given on the university library web page on referencing and citation. There is a new referencing style adopted by the University called APA Havard 7^th Edition, this must be used in your work.

Title

• Database Design - investigation of alternative approaches; discussion of advanced techniques and how they improve the design of a database.
• SQL: Review of SQL concepts; how SQL implements the relational model; advantages and disadvantages of the language.
• SQL: Advanced features - investigation of latest features in the current SQL Standard, such as multimedia support.
• Database container deployment and management: Feature and benefits
• Quantum Computing impact on Databases: Discuss
• Data migration and data security are major issues in System innovation: Discuss Multitenancy Vulnerabilities and its security challenges in cloud
• Multitenancy Architecture in Database: Issues and Challenges?
• Data Warehousing – issues in design, e.g., star and snowflake schemas Knowledge discovery in large databases: Discuss
• An Elastic cloud –based data warehouse: Features and benefits
• Data Quality Management Issues – discussion of how to ensure integrity and validation.
• Document record and Content Management issues.
• Relational model: main features; how it is supported by SQL; problems of areas not supported.
• Investigation of Application Development tools and how they aid the development of a database application, such as SQL Developer, Apex
• Multi-user issues: currency control; handling a multi-user DBMS; SQL support
• With a real life example, differentiate between Data Masking and Data Cleansing, how these would contribute to data management and operational efficiencies.
• Modernizing Data Architecture for a Digital Age Using Data Virtualization