Design and development of a database system

Assignment Help Other Subject

Reference no: EM132286710

Assessment - Design and Development of a Database System

ASSIGNMENT OBJECTIVES:

1. To develop/analyse a set of requirements for a database system.

2. To develop an ERD and a normalised schema.

3. To implement the database system in SQL Server.

Details of assignment brief

Assessment Task

You are required to develop the design of a database system for a company/business of your choice.

The implementation of your system must be carried out using MS SQL Server. As part of the assessment, you are required to submit the following:

Report

The report must include the following:

- Background for the development of the chosen database system. (Why the Database is needed) Scope including requirements for the database system to be developed. (What should it be able to do)
- Description of at least 3 business rules and their implementation.
- An Entity Relationship Diagram (ERD) of the system which must include a minimum of 6 entities displaying all the relationships with cardinalities and all the constraints.The model (relational schema) of your database system that must fulfil the requirements of 3NF. Use Draw.ioto develop the ERD.
- Evaluation of your database design, highlighting the strengths and weaknesses.
- Appropriately structured report showing precise information. (Cover page, Table of Contents, Headings etc)
Completed Database System (Using MS SQL Server Management Studio)
Consider the ERD created and ;
- Create the relevant tables with appropriate relationships in MS SQL Server using the CREATE TABLE statement.
- Ensure appropriate Data types are used.
- Populate the tables with a minimum of 5 records using INSERT INTO SQL Statements.
- Create a data diagram and include it in the appendix of your report.

- Create 3 Stored Procedures. The Following must be included
o List all items from any table in order of some attribute
o Data from 2 tables
o Use of "DISTINCT" operator
(8 Marks)

- Create the followingparametric stored procedures :
o Search between two dates
o Use of the "LIKE" operator
o A parametric Stored Procedure that would support the business

- Create a View that would be beneficial for the business.

- Scripts for your SQL server database for structure and data.

Attachment:- Design and Development of a Database System.rar

Reference no: EM132286710

Questions Cloud

Case project-data for traveling users : They have a server running Windows Server 2012 R2 that can be configured as a remote access server

How knowing more about your career personality : Wrap up your summary by considering your strengths and weaknesses and how knowing more about your "career personality" (based on the Holland Code).

Remote desktop and remote assistance : What are the differences between Remote Desktop and Remote Assistance? When should you use each one?

Describe ethical boundaries in clinical psychology : Describe ethical boundaries in clinical psychology and explain why they are important to the profession. Explain the importance of self-care for professional.

Design and development of a database system : B7IS100 - Information Systems and Databases - Dublin Business School - develop the design of a database system for a company/business of your choice

Discuss new potential technologies rising in the industry : Discuss any new potential technologies rising in the industry that could cause a new disruption.

How do people react when you do not conform : Consider your own social behavior and the various normative and informational social influences you encounter in everyday life. Then, complete the following.

How many number of comparisons are necessary : How many number of comparisons are necessary to find 15 in the tree?

Assume the existence of an operator : Let the domain of discourse be all people in the CS department. Let's define the predicates Student(x) and Instructor(x) to mean that x is a student or an

Reviews

len2286710

4/17/2019 11:14:21 PM

General Assessment Submission Requirements for Students: 1. Online assignments must be submitted no later than the stated deadline. 2. All relevant provisions of the Assessment Regulations must be complied with. 4. Students are required to retain a copy of each assignment submitted, and the submission receipt. 5. Assignments that exceed the word count will be penalised. 6. Students are required to refer to the assessment regulations in their Student Guides and on the Student Website. 7. Dublin Business School penalises students who engage in academic impropriety (i.e. plagiarism, collusion and/or copying). Please refer to the attached referencing guidelines for information on correct referencing.

len2286710

4/17/2019 11:14:07 PM

Database System with MS SQL Server Less than four tables not properly structured, queries without the required features that do not meet business requirements, no/poor implementation of stored procedures. Four substantial tables demonstrating some structure of data, queries with some required features that meet some business requirements, some implementation of stored procedures.

len2286710

4/17/2019 11:14:01 PM

Criteria/ Mark < 40 40 - 49 Report Insufficient or incomplete report with poor or incomplete data model, no/poor normalisation, poor explanation, etc. Some but insufficient and poorly written report with poorly developed data model, some normalisation and explanation not enough to meet the requirements

len2286710

4/17/2019 11:13:56 PM

Instructions for Submission: You are required to: • Create a folder with yourNameStudentNumber. • Include the report in the folder. • Develop the scripts for your SQL server database and include in the folder. Note: Your SQL server database must be available in your SQL Server Account until you receive your results for this module.

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages