COMP1802 Advanced Database Technologies | University of Greenwich

Published: 11 Feb, 2025
Category Coursework Subject Computer Science
University University of Greenwich Module Title COMP1802 Advanced Database Technologies

COMP1802 Advanced Database Technologies

Plagiarism is presenting somebody else's work as your own. It includes: copying information directly from the Web or books without referencing the material; submitting joint coursework as an individual effort; copying another student's coursework; stealing coursework from another student and submitting it as your own work.  Suspected plagiarism will be investigated and if found to have occurred will be dealt with according to the procedures set down by the University. Please see your student handbook for further details of what is / isn't plagiarism. 

All material copied or amended from any source (e.g. internet, books) must be referenced correctly according to the reference style you are using. 

Your work will be submitted for plagiarism checking.  Any attempt to bypass our plagiarism detection systems will be treated as a severe Assessment Offence.

CW_COMP1802_2024_25 (5) (1).docx

Detailed Specification 

This is an individual coursework. 

You need to complete the implementation and to write a final report to support the following  case study and requirements. 

Case Study: 

You are hired as a DBA for a medium size retailer company. The company stores  information about its products, orders and customers in a database.  

The database design is complete (please see the Entity Relationship Diagram below). At  the beginning of the module, you have been provided with the script to upload all the  necessary data into your VM Oracle Database. The owner of the tables is the user oe  having password oe. 

The employees of the company work in several departments: Sales, Marketing, Inventory,  Customer Service, HR, etc. They need to have different access rights to the tables in the  database, based on their job descriptions.

Your tasks are as follows: 

• to implement DBA requirements specified below using your Virtual Machine (VM) provided for the module and a created Oracle Database on the VM; 

• to describe your solutions for potential DBA problems as specified in the  Problem-solving requirements.

Entity Relationship Diagram (ERD) 

oe schema:

COMP1802 Advanced Database Technologies

DBA requirements

1. Please create a new permanent tablespace tbse in your database to store  additional information that can be updated on a regular basis. This tablespace should  have an initial size of 50 megabytes and one data file. The space in this tablespace  should be managed locally and extend automatically by 10 megabytes. 

You must provide an SQL command for a tablespace creation and a  screenshot of successful execution of that SQL command. Please also provide  a detailed explanation on why you made those choices of tablespace properties and their values, and what are the benefits and drawbacks of your  choices.

2. You are required to create the following two new users with login requirements specified below: 

a) One user called cust for the Customer Service department and one user called invent for the Inventory department.  

b) The default tablespace with unlimited quota for both users should be set to tbse (created in Question 1). The temporary tablespace for both users should  be set to temp. The profile profdep should be assigned to both users. 

c) The user cust should be forced to change their password on the first login. The user invent does not have this requirement. 

d) Both users should be forced to change their passwords every 2 months.

You must provide SQL commands and screenshots of successful execution of  these SQL commands. Make sure you include an explanation on how all the  requirements are implemented, possible alternatives, their benefits and drawbacks. Please provide passwords (existing and new if changed) for the  created users.

3. Two new users (created in Question 2) should have the following access rights: a) Both users should be able to login to the database. 

b) The user cust should have Read/Only access to the OE.ORDERS and OE.CUSTOMERS tables. 

c) The user invent should have Read/Write access to the OE.WAREHOUSES table. 

d) Both users should be allowed to create new tables and views. 

You must provide SQL commands and screenshots of successful execution of  these SQL commands. Make sure you include an explanation on how all the  requirements are implemented, possible alternatives, their benefits and  drawbacks. 

4. New information about contractors working with the retailer company should be  inserted into the database. 

a) Create a new table Contractors in the schema of the user invent (created in  Question 2) and stored in the tbse tablespace (created in Question 1). Please use the structure described in the table below.  

Make sure all the constraints have user-defined names.

Column  

name

Data type 

Constraint

id 

NUMBER(10) 

Primary Key

name 

VARCHAR2(30) 

Not Null

phone 

NUMBER(15)

 

status 

CHAR(1) 

Check constraint: this column  should contain only two values: ‘A’ (for ‘Available’) and ‘U’ (for  ‘Unavailable’)

b) Populate the created table Contractors with information of your choice about any  two contractors, validate the column constraints of the table. 

You must provide SQL commands and screenshots of successful execution of these  SQL commands. Make sure you include an explanation on how all the requirements are implemented.

Problem solving requirements

5. You have accidently dropped an important schema (for example, hr) in your  database. Please discuss the best functionality to use in order to recover it quickly  and safely, providing SQL commands and explanations of the steps needed to  recover data. 

You must provide discussions and explanations, including SQL commands,  for the potential specified DBA problem. There is no need to execute these  SQL commands on your database. 

6. You try to execute SQL command SELECT * FROM MYTABLE; but get an error “ORA-00942: table or view does not exist”. Please explain all possible reasons for this error. Describe your solutions for this  error depending on each reason, including necessary SQL commands. 

You must provide discussions and explanations, including SQL commands,  for the potential specified DBA problem. There is no need to execute these  SQL commands on your database.

If you are facing a problem in completing the COMP1802 Advanced Database Technologies assignment, then our computer science assignment help in UK and assignment writing help service is the perfect solution for you! We will cover all the important topics such as ER Model, Normalization, SQL Queries, NoSQL Databases, Transaction Management, Data Warehousing. We do not rely on AI-generated content but on providing 100% human-written, plagiarism-free solutions. First, avail free samples; check the quality and get done with your work stress-free. Contact us for online coursework writing today and win the grades war!

 

If you want to see the Sample of this brief, then click here:-COMP1802

Workingment Unique Features

Hire Assignment Helper Today!


Latest Free Samples for University Students

COM00186M Autonomous Robotic Systems Engineering (AURO) Coursework Example

Category: Coursework

Subject: Engineering

University: University of York

Module Title: COM00186M Autonomous Robotic Systems Engineering (AURO)

View Free Samples

7BSP1266 Dissertation-Project Management Coursework 4 Example | UoH

Category: Coursework

Subject: Management

University: University of Hertfordshire

Module Title: 7BSP1266 Dissertation-Project Management

View Free Samples

HSC419 Modern Society Coursework 2 Assignment Sample | CU

Category: Coursework

Subject: Sociology

University: Coventry University

Module Title: HSC419 Modern Society

View Free Samples

BMMM 5003 Integrated Marketing Communications Coursework 1 Example | DMU

Category: Coursework

Subject: Marketing

University: De Montfort University

Module Title: BMMM 5003 Integrated Marketing Communications

View Free Samples

ACC2222 Accounting and Finance for Business Individual Coursework Example | MUL

Category: Coursework

Subject: Accounting

University: Middlesex University London

Module Title: ACC2222 Accounting and Finance for Business

View Free Samples
Online Assignment Help in UK