数据库代写 | SEHS 4514 Database Technologies and Management

这个作业是自选主题并完成对应的数据库系统设计
SEHS 4514 Database Technologies and Management
Individual Assignment 1 (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 or above. 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.
a. Database Design
1) Scope of the database system – Introduction of your company (business context,
database operation, data flow)
– Business rule (the entity relationship among tables, table
descriptions, e.g., 1 customer can place 0 or many orders)
2) ER Modelling (UML Class Diagram)
3) Recommended Software: Diagram in Microsoft SQL Server (Express) 2012/2014/2016
StarUML @ http://staruml.io/
b. Database Implementation
1) Queries

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

Prepare two queries for users at managerial level and discuss their implications
2) Views
◆ Create two views and discuss their implications
3) Required Software: Microsoft SQL Server 2012/2014/2016
c. Discussion on Security and Administration issues (Networking environment, Hacker, Disaster
recovery planning, Authorization, Access right) with literature support (academic papersHighly Recommended)
– IEEE communications magazine
– Information Systems Security Conf
– IEEE International Symposium on Secure Software
Engineering
– IEEE/ACM international Conference on Automated
software engineering
Word limit: 500~600 words + Reference List
Example
Example
3
Submissions
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 5 May 2020 (23:00).
Assessment Criteria
a. Scope and Database Design Weight
1.1 Scope of the database system (Business Rules) 3%
1.2 ER Modelling (UML Class Diagram) 3%
b. Database Implementation
2.1 Queries 8%
2.2 Views 4%
c. Security and Administration issues 1%
d. Database Complexity and Business Logic 1%
TOTAL 20%
Some possible ideas for your proposed business context*

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.
-End-