Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Database Design Report for FPT Shop's New Database System, Summaries of Principles of Database Management

FPT University (FPTU)Principles of Database Management

A report for the CEO of FPT Shop outlining the user and system requirements and the design of a relational database system to be developed for their expanding business. The report includes clear statements of user roles and requirements, a design of the database system using appropriate design tools and techniques, and an assessment of the effectiveness of the design in meeting user and system needs.

Typology: Summaries

2021/2022

Uploaded on 10/03/2022

luc-thanh-quy-fgw-hcm
luc-thanh-quy-fgw-hcm 🇻🇳

18 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Higher Nationals in Computing
Database Design and
Development
ASSIGNMENT
No.1
Learner’s name: .............................
Assessor name: NGUYEN VAN SON
Class: .............................................
Learner’s ID: .................................
Subject’s ID: .................................
Assignment due: Assignment submitted:
pf3
pf4
pf5

Partial preview of the text

Download Database Design Report for FPT Shop's New Database System and more Summaries Principles of Database Management in PDF only on Docsity!

Higher Nationals in Computing

Database Design and

Development

ASSIGNMENT

No.

Learner’s name: .............................

Assessor name: NGUYEN VAN SON

Class: .............................................

Learner’s ID: .................................

Subject’s ID: .................................

Assignment due: Assignment submitted:

ASSIGNMENT 1 FRONT SHEET

Qualification BTEC Level 5 HND Diploma in Computing

Unit number and

title

Unit 04: Database Design & Development

Submission date

Date Received 1st

submission

Re-submission Date

Date Received 2nd

submission

Student Name Student ID

Class Assessor name

Student declaration

I certify that the assignment submission is entirely my own work and I fully understand the

consequences of plagiarism. I understand that making a false declaration is a form of malpractice.

Student’s signature

Grading grid

P1 M1 D

❒ Summative Feedback: ❒ Resubmission Feedback: \

Grade: Assessor Signature: Date:

Lecturer Signature:

LO1 Use an appropriate design tool to design a relational database system for a substantial problem Assignment Brief and Guidance: You are employed as a Database Developer for a large IT consultancy company. The company has been approached by FPT Shop which is expanding due to the growth of the number of stores. FPT Shop is currently facing difficulties in dealing with managing the database from all shops on over country. It decided to develop a new database so that: users can register with their phone numbers as IDs and order or rate, comment for their bought devices, shop managers can take care for their stores and director board can view all data from all shops. You are tasked to select one of those systems to develop database for FPT Shop. Your tasks are to:  Work with FPT Shop to find out about current requirements for each system  Analyse the requirements and produce clear statements of user and system requirements.  Design a relational database system using appropriate design tools and techniques  Develop a fully functional relational database system, based on an existing system design.

 Test the system against user and system requirements.

 Produce technical and user documentation

Part 1 (Assignment 1) Before you start the development process, your manager has asked you to produce a report for the CEO of FPT, containing:

  1. Clear statements of user and system requirements. The system must have at least 3 user roles, including business processes and statistical reports for FPT Shop managers.
  2. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables. You would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include interface and output designs, data validations and cover data normalization. Your manager would like on the report your assessment of the effectiveness of the design in relation to user and system requirements. Learning Outcomes and Assessment Criteria (Assignment 1): Learning Outcome Pass Merit Distinction LO1 P1 Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements.

M1 Produce a

comprehensive design

for a fully functional

system which includes

interface and output

designs, data

validations and data

normalisation.

D1 Assess the effectiveness of the design in relation to user and system requirements.