Download giới thiệu làm việc nhóm. giải thích cpd là gì và các lí thuyết của vroom and more Schemes and Mind Maps Sociolinguistics in PDF only on Docsity!
ASSIGNMENT 1 FRONT SHEET
Qualification TEC 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 Nguyen Thi Minh Nguyet Student ID BH Class SE06201^ Assessor name Nguyen Thi Nga 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 Nguyet Grading grid
P1 M1 D
Summative Feedback: Resubmission Feedback:
r Grade: Assessor Signature: Date: Signature & Date:
- I. Introduction
- II. Contents
- interrelated tables, with clear statements of user and system requirements. P1. Design a relational database system using appropriate design tools and techniques, containing at least four
- 1.What is a database?
- SRS
- 2.1. Overview SRS:
- 2.2. Purpose SRS:
- 2.3. SRS Range:
- 2.4.What are the benefits,objects,and goals we instead to have for the product?..........................................................................................
- Logical design (ERD)
- Explanation
- Physical Design....................................................................................................................................................................................................................
- III. Conclude
- IV. Refenrences
- Figure 1: SRS Table of Figure
- Figure 2: Functional and non-functional requirements.
- Figure 3: Logical design
- Figure 4: Physical Design
I. Introduction In today's digital age, content management has become an important and complex part of running a website or application. To solve this challenge, content management systems (CMS) were born and have become important tools for creating, managing and distributing content on the Internet. A content management system (CMS) is a software or web platform designed to support the effective creation, management, and distribution of content. CMS provides a simple user interface that allows webmasters to create, edit and publish content easily, without the need for programming or web design knowledge. A CMS system includes important features such as user management, content management, image management, document management and many other features. CMS allows users to create and manage static websites, blogs, forums, online stores and many other types of web applications. CMS helps increase flexibility and efficiency in content management. Website administrators can easily edit content, change themes, manage users, and perform other administrative tasks without relying on web developers. This saves time, money and enhances customer engagement. CMS also offers scalability and customization. Users can use plugins, themes, and addons to customize the CMS to their specific needs. This allows the creation of diverse websites that meet each user's unique needs. On the market today, there are many popular CMS systems such as WordPress, Joomla, Drupal and Magento. Each system has its own advantages and is suitable for different uses. Based on the benefits that CMS brings, CMS system management plays an important role in maintaining and developing a successful website or application. CMS system management includes installation, configuration, security, optimization and user support..
Figure 1 : SRS 2.2. Purpose SRS: The purpose of SRS in CMS system management is to describe the system's data structure and database requirements, identify data storage requirements, including data format, management Database backup and data recovery. 2.3. SRS Range: The scope of SRS in online CMS systems will support the creation, editing and management of diverse content such as articles, images, videos, categories, and static pages. Furthermore, a CMS management project is necessary to build a system that meets the needs of administrators, editors, and end users. With the above factors, the SRS scope in a CMS management project not only includes constraints but can also be divided into two parts: functional requirements and non-functional requirements.
Functional requirements Non-functional requirements Definition Requirements define the functions that the system must perform Requirements that are not directly related to the system's functionality Functional Content management: Allows users to create, edit and delete posts, pages, categories and other sections of the website. Supports formatting and attaching content, including images, videos, files and link. Provides search and content sorting tools to easily manage and find information. User management: Allows administrators to create and manage user accounts with different roles and permissions. Supports registration and login functions for users. Provides a user management interface to Add, edit, and delete users. Performance: Response time requirements: The system must be able to handle requests from users quickly to ensure a good experience. Load requirements: The system must be able to withstand concurrent traffic and handle requests without performance issues. Security:Access management: The system must provide access management functionality to control access to website content and functionality.Data encryption: The system must support data encryption data to ensure that sensitive information is not exposed. Security testing: The system needs to be periodically security tested to detect and fix security vulnerabilities. Figure 2 : Functional and non-functional requirements.
Project management: SRS assists project management in defining project scope, planning, analyzing and monitoring progress. Project managers use SRS to ensure that the project is developed according to requirements and achieves its goals. Goals: The goals of SRS (Software Requirements Specification) in the CMS (Content Management System) system are: Identify functional requirements: One of the main goals of SRS is to identify and describe in detail the functional requirements of the CMS system. This includes content management functions such as creating, editing, deleting, posting, category management, user account management, and other related features. Describe non-functional requirements: SRS describes the non-functional requirements of the CMS system, including performance, security, user interface, scalability, compatibility, and version management requirements. The goal is to specify requirements that are not directly related to functionality but affect the performance and usability of the system. Determine project scope: SRS helps determine the scope of the CMS system management project. This ensures that requirements and functionality are clearly and correctly defined, and limits the work of the project. The goal is to ensure that the project is implemented within its defined scope and is not expanded beyond its original scope.
4. Logical design (ERD) ERD stands for entity relation diagram An entity relationship diagram (ERD), also known as an entity relationship model, is a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system. My erd includes 6 entity: notification, category, subject information, resource subject, learning resources and resource category.
Figure 3 : Logical design
Notification functions with notificationid, title, content, poster, postingdate and categorydate attributes include: Create new: Create a new announcement with attributes such as title, content, poster, postingdate and categorydate. Edit: Edit information of an existing announcement, including title, content, poster, postingdate and categorydate. Delete: Delete a notification from the system based on notificationid. View details: View detailed content of an announcement, including title, content, poster, postingdate and categorydate. Subject information entity includes attributes are subject name, description, document where subject is primary key. Topic information functions with topic attributes, topic name, description, and document wrapper include: Create new: Create new subject information with attributes such as subject, subject name, description and documents. Edit: Edit existing course information, including course name, description and documents.
Delete: Delete subject information from the system based on subject. View details: View detailed information about a subject, including subject name, description and documents. Resourece category entity includes attributes are resource name, description where resource name is primary key. The functions of the Resources category with resourcesname and description attributes include: Create new: Create a new resource with name and description. Edit: Edit information of an existing resource Delete: Remove unnecessary resources from the system. View list: Displays a list of available resources in the system. Learning resource entity includes 8 attributes are resourced, resource name, rategory, content, file and path where resource name is primary key and categotyid is foreign key of resource category entity.
Create table category database And add caregory database
Create table notification database And add notification database Create table subject information database
And add table learning resource database Create table resource subject database Physical Design
Figure 4 : Physical Design
