Reference no: EM132600203

ACCC5001 Database Management Systems - University of Wales

Database Management Systems Assessment

Learning Outcome 1: Demonstrate a sound understanding of the knowledge and skills required to design, implement and manage multi-user database applications.

Task 1: Database Creation
1. Create an Oracle or SQL Server database (using SQL statements) to implement the To-Rent Estate Agents Case Study database.
Note:
a. The database should include the following features:
i. Primary key for each table
ii. Referential integrity constraints (foreign keys)
iii. At least one check constraint
iv. Multi-user access to tables
b. You are required to populate the database with a minimum of four records per table. The data entered should be used to test the functionality of the primary key, foreign key and check constraints.
c. You should grant select and update rights to one other database user.
d. Also test the rollback and commit operations.

Note: You must submit the SQL code implemented for the above, see instructions below.
2. Create two documented (use comments) .sql files with the following:
File 1
a. SQL code used to generate each table structure
b. SQL code used to create the referential integrity constraints
c. SQL code used to create the check constraint(s)
d. SQL code to manage users

File 2
e. SQL code to populate each table with sample data (minimum of four records per table)
f. SQL code to demonstrate evidence of testing carried out to validate the constraints
g. SQL code to demonstrate evidence of rollback and commit operations
3. Create a compressed (zipped) file containing your completed .sql files and upload to the link provided on Moodle.

Task 2: Assignment Project Report

You have been invited by To-Rent agents to assist them with coming up with the proposed distributed database solution. You are required to submit the following project specification report. The report should be approximately 1500 words (excluding title page, table of contents, references and appendices).

1. Write a report to document the strategies that can be employed by To-Rent Estates with a DBMS server at your defined regional locations.
Note:
a. Include in the report a sample of tables and how they can be distributed according to the proposed strategies presented in the case study.
b. Identify the advantages to be gained from your proposed distributed DBMS solution and use appropriate examples from your solution to support your discussion.
c. References to any sources that have contributed to your completion of the assignment (i.e. relevant journals, articles, books, tutorials and online sources) should be added in a references section at the end of your report.
d. Present the report in appropriate report writing format, using a formal writing style. Your report should also include:
i. an abstract: a short (one/two sentences) summary description of the contents of the report
ii. a table of contents outlining the organisation structure of the report

Attachment:- Database Management Systems.rar