代写SPD4514、代做Database留学生、SQL编程调试、SQL语言代写

日期：2019-03-16 11:12

SPD4514 Database Technologies and Management

Individual Assignment (20% of total course marks)

Objectives

The objectives of this assignment are to

evaluate the students’ concept in designing database for real life applications and its

implementation.

arouse students’ attention on database security and administration

General Information

In this assignment, each student is required to design and implement a database application for in

a real-world organization. With the concept of Database System Development Lifecycle, each

student needs to specify the scope and boundaries of the database system. Entity-relationship

Model is presented as the deliverable at database design stage. The format should be consistent

with that in the textbook. Moreover, each student is required to implement the database in

Microsoft SQL Server (Express) 2012/2014/2016. After implementation, queries and views are

prepared for information retrieval. Lastly, each student is asked to discuss the security and

administration issues of the chosen application.

Stage 1

a. Proposal Form

Available in Moodle

Stage 2

b. Database Design

Scope of the database system (Background and Business Rules)

Recommended Software: StarUML @ http://staruml.io/

c. Database Implementation

Queries

◆ Prepare two queries for users at operational level and discuss their implications

◆ Prepare two queries for users at managerial level and discuss their implications

Views

◆ Create two views and discuss their implications

Required Software: Microsoft SQL Server 2012/2014/2016

d. Discussion on Security and Administration issues

Word limit: 500 words (+/- 10%)

Use of literature is highly recommended

References

Submissions

Stage 1:

Proposal Form should be submitted to Moodle on or before 23 March 2019 (23:55).

Stage 2:

Each student is required to submit a report addressing the aforementioned tasks in document

format (doc or docx). ALL files (including report, UML and MS-SQL project files) should be zipped

and submitted to Moodle on or before 19 April 2019 (23:55).

Assessment Criteria

a. Proposal Form 2%

b. Scope and Database Design 4%

1.1 Scope of the database system (Business Rules) 1%

1.2 ER Modelling (UML Class Diagram) 3%

c. Database Implementation 12%

2.1 Queries 8%

2.2 Views 4%

d. Security and Administration issues 2%

TOTAL 20%

Some possible ideas*

Learning Management Systems

Conference Management System

Library Management Systems

Volunteer Management Systems

Fundraising and Relationship (Donor) Management Systems

Sales and Marketing Information Systems

Manufacturing and Production Information Systems

Finance and Accounting Information Systems

Human Resources Information Systems

Property management system

Document Management System

Hotel Management System

Clinic (Healthcare) Management Systems

*Not limited to the ideas above.