Prepare for your exams
Get points
Guidelines and tips
Sell on Docsity
Docsity AI

Prepare for your exams

Study with the several resources on Docsity

Earn points to download

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

Guidelines and tips

Sell on Docsity

Docsity AI

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

20 Points

For each uploaded document

Answer questions

5 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 and Development Assignment, Assignments of Database Programming

FPT University (FPTU)Database Programming

The development of a database system for a student management application. It includes the creation of database tables, insertion of sample data, and various sql queries to select, update, and delete data. The process of designing the database schema, implementing the tables, and validating the data. It provides step-by-step instructions and illustrations of the sql code used to create the database and manipulate the data. The assignment demonstrates the student's understanding of database design principles, sql syntax, and data management techniques. The document could be useful for students studying database design and development, as it provides a practical example of the process and the application of sql commands.

Typology: Assignments

2021/2022

Uploaded on 04/10/2023

minh-hieu-10 🇻🇳

(1)

10 documents

1 / 29

This page cannot be seen from the preview

Don't miss anything!

ASSIGNMENT 2 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

Nguyễn Đoàn Minh Hiếu

Student ID

GCD210003

Class

GCD1104

Assessor name

Ho Van Phi

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

Hieu

Grading grid

Discover Assignments of Database Programming FPT University (FPTU)

Partial preview of the text

Download Database Design and Development Assignment and more Assignments Database Programming in PDF only on Docsity!

ASSIGNMENT 2 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 Nguyễn Đoàn Minh Hiếu Student ID GCD

Class GCD110^4 Assessor name Ho Van Phi

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 Hieu

Grading grid

P2 P3 P4 P5 M2 M3 M4 M5 D2 D

 Summative Feedback:  Resubmission Feedback:

Grade: Assessor Signature: Date:

Signature & Date:

I. DEVELOP THE DATABASE SYSTEM

1. Final mock-up of the application

1.1 Introduction

Following assignment 1, all we are familiar with are the ERD designs and diagrams for the database design. We have seen how to

create a database using simple programming tools. database for SQL Server Management. This leads to a clearer understanding of

the database table construction procedure in assignment 2. Both the code that makes the tables and the code that imports data into

the ERD tables will be examined. In order to determine whether the SQLServer Management program is more than just a database

construction tool, we'll look into it further.

1.2 Code to create each table and Code to insert some sample data for each table

To create the student management data table, I use the most basic SQL Server Management Terminology. Among them are

Reservations, Construction, Contracts, Rooms, Staff and Students. I have created a database table with name assignment.

2. Queries to create database with results

2.1. Queries to create database and table

To build the system, we need to create the data first

Figure 1 : Create Database

Figure 4 : Create Table Customers

Figure 5 : Create Table Staff

Figure 6 : Create Table Orders

Figure 7 : Create Table Details

Figure 9 : Diagram

2.2 Data validation

➢ Data types.

INT: It is used to represent an integer value. Its signed range is - 2147483648 to 2147483647, and its unsigned range is 0 to

Figure 10 : : Example Data type int

Date: It is used to specify date format YYYY-MM-DD. Its supported range is from '1000- 01 - 01' to '9999- 12 - 31'.

Figure 11 : Example Data type date

Nvarchar: Variable length, both Unicode and non-Unicode characters, such as Japanese, Korean, and Chinese. It's up to 4,000 characters and

takes up 2 bytes per Unicode/Non-Unicode character

Figure 12 : Example Data type nvarchar

I. DEVELOP THE DATABASE SYSTEM
- 1. Final mock-up of the application
  - 1.1 Introduction
- 1. Queries to create database with results
  - 2.1. Queries to create database and table
  - 2.2 Data validation
  - 2.3 Querying across multiple tables
II. PRODUCE QUERIES
- 1. Queries to INSERT data with illustrations of final result
- 1. Queries to SELECT data with illustrations of final result
- 1. Queries to UPDATE data with illustrations of final result
- 1. Queries to DELETE data with illustrations of final result
III. TEST THE SYSTEM
- 1. Test Plan
- 1. Test Result
Figure 1: Create Database........................................................................................................................................................................................................................................
Figure 2: Create Table Supplier
Figure 3: Create Table Product
Figure 4: Create Table Customers
Figure 5: Create Table Staff......................................................................................................................................................................................................................................
Figure 6: Create Table Orders
Figure 7: Create Table Details
Figure 8: Result after create tables
Figure 9: Diagram
Figure 10: : Example Data type int
Figure 11: Example Data type date
Figure 12: Example Data type nvarchar
Figure 13: Querying Select
Figure 14: Data
Figure 15: Querying Select
Figure 16: Data
Figure 17: Querying Select
Figure 18: Data
Figure 19: : Insert Information for table Customers
Figure 20: Insert Information for table Product
Figure 21: Insert Information for table Supplier
Figure 22: Insert Information for table Staff
Figure 23: Insert Information for table Orders
Figure 24: : Insert Information for table Details
Figure 25: Select all table
Figure 26: Data table Customers
Figure 27: Data table Details
Figure 28: Data table Orders
Figure 29: Data table Product
Figure 30: Data table Staff
Figure 31: Data table Supplier.................................................................................................................................................................................................................................
Figure 32: Query to update data for Details table
Figure 33: Before change
Figure 34: After change
Figure 35: Query to delete one Staff
Figure 36: Before change
Figure 37: Delete all data in table
Figure 15 : Querying Select
- Figure 16 : Data
Figure 17 : Querying Select
- Figure 18 : Data

Figure 20 : Insert Information for table Product

Figure 21 : Insert Information for table Supplier

Figure 23 : Insert Information for table Orders

Figure 24 : : Insert Information for table Details

2. Queries to SELECT data with illustrations of final result

➢ After inserting data into the tables, we can check the information by using the Select

Select all tables

Database Design and Development Assignment, Assignments of Database Programming

Related documents

Partial preview of the text

Download Database Design and Development Assignment and more Assignments Database Programming in PDF only on Docsity!

ASSIGNMENT 2 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 Nguyễn Đoàn Minh Hiếu Student ID GCD

Class GCD110^4 Assessor name Ho Van Phi

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 Hieu

Grading grid

P2 P3 P4 P5 M2 M3 M4 M5 D2 D

Grade: Assessor Signature: Date:

Signature & Date:

I. DEVELOP THE DATABASE SYSTEM

1. Final mock-up of the application

1.1 Introduction

Following assignment 1, all we are familiar with are the ERD designs and diagrams for the database design. We have seen how to

create a database using simple programming tools. database for SQL Server Management. This leads to a clearer understanding of

the database table construction procedure in assignment 2. Both the code that makes the tables and the code that imports data into

the ERD tables will be examined. In order to determine whether the SQLServer Management program is more than just a database

construction tool, we'll look into it further.

1.2 Code to create each table and Code to insert some sample data for each table

To create the student management data table, I use the most basic SQL Server Management Terminology. Among them are

Reservations, Construction, Contracts, Rooms, Staff and Students. I have created a database table with name assignment.

2. Queries to create database with results

2.1. Queries to create database and table

Figure 1 : Create Database

Figure 4 : Create Table Customers

Figure 5 : Create Table Staff

Figure 6 : Create Table Orders

Figure 7 : Create Table Details

Figure 9 : Diagram

2.2 Data validation

➢ Data types.

Figure 10 : : Example Data type int

Figure 11 : Example Data type date

takes up 2 bytes per Unicode/Non-Unicode character

Figure 12 : Example Data type nvarchar

Figure 20 : Insert Information for table Product

Figure 21 : Insert Information for table Supplier

Figure 23 : Insert Information for table Orders

Figure 24 : : Insert Information for table Details

2. Queries to SELECT data with illustrations of final result

➢ After inserting data into the tables, we can check the information by using the Select

Figure 25 : Select all table