Scribd
Upload
107 views3 pages

Database Design & Development - Assignment 2023

The document provides an assignment brief for developing a bookstore management system database. Students are asked to design and develop a relational database for a bookstore to manage book information and sales. They must analyze requirements, design the database using entity-relationship modeling, develop it in an RDBMS, test it, and document it technically and for users. The goal is to provide book information and sales functionality for a bookstore company.

Uploaded by

trantranchian
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
107 views3 pages

Database Design & Development - Assignment 2023

The document provides an assignment brief for developing a bookstore management system database. Students are asked to design and develop a relational database for a bookstore to manage book information and sales. They must analyze requirements, design the database using entity-relationship modeling, develop it in an RDBMS, test it, and document it technically and for users. The goal is to provide book information and sales functionality for a bookstore company.

Uploaded by

trantranchian
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Higher Nationals

Assignment Brief – BTEC (RQF)


Higher National Diploma in Computing

Unit Number and Title Unit 4: Database Design & Development

Academic Year 2023 - 2024

Unit Tutor Pham Son Tung

Assignment Title Bookstore Management System

Issue Date

Submission Date

IV Name & Date Nguyen Ngoc Tan & 01/08/2023

Submission Format
Each student must submit their assignment as guided in the assignment brief. The students are
guided on what sort of information is to produce to meet the criteria targeted. Some tasks might
require group work, but the student must produce the individual assignment.

Learning Outcomes

LO1 Use an appropriate design tool to design a relational database system for a substantial
problem

LO2 Develop a fully-functional relational database system, based on an existing system design

LO3 Test the system against user and system requirements

LO4 Produce technical and user documentation


Assignment Brief and Guidance
BKCsoftware is an IT company in Vietnam that has been hired by Knowledge Co., a bookstore,
to develop software called "Knowledge Bookstore" to manage and sell books for their retail
chain. Customers purchasing books need to know basic information about each book, such as
the book's title, ISBN code, author(s), publication year, publisher, description, summary, and its
price.
You are an employee of BKCsoftware assigned to the responsibility of the "Knowledge
Bookstore" software project. Your task is to design and develop a relational database using
appropriate design tools and techniques, and you must test the relational database according to
user requirements. Finally, you are required to provide the owner of Knowledge Co. with
technical documentation and demonstrate how your relational database is used in the database
management system for users to see.
To meet the requirements of the subject, students need to fulfill the following requirements:
Task 1: Investigate and analyze user and system requirements.
 Present user requirements.
 Present system requirements.
Task 2: Design a database based on the analyzed requirements.
 Present a list of entities and their attributes.
 Present the relationships between entities.
 Design an Entity-Relationship Diagram (ERD) based on the analyzed entities
and relationships.
 Design the tables in the database based on the designed ERD.
Task 3: Develop the database based on the design.
 Choose an RDBMS to develop the database.
 Implement the database based on the existing table designs and provide
evidence of the executed database implementation.
 Present the database query statements and provide evidence of their execution.
Task 4: Test the developed database.
 Provide the commands used to test the database and the test cases applied to these
commands.
Task 5: Publish technical documentation and user manuals..
 Present technical documentation.
 Present user documentation.
The submission is presented in the form of a document/file.
1. A report document.
2. A version of the database (source code).

You might also like