Contextlevel dfd and the level dfd activity

Higher Nationals

ii

Unit 04: Database Design & Development

Assignment 01

assignment brief as your cover page and make sure all details are accurately filled.

2. The entire assignment brief should be attached as the first section of your assignment.

Word Processing Rules

1. The font size should be 12 point, and should be in the style of Time New Roman.

submission.

5. Use the spell check and grammar check function of the word processing application to

Important Points:

1. Carefully check carefully the hand in date and the instructions given with the assignment.

4. You must be responsible for efficient management of your time.

5. If you are unable to hand in your assignment on time and have valid reasons such as illness,

8. If you use other people’s work or ideas in your assignment, it must be properly referenced,

using the HARVARD referencing system, in your text or any bibliography. Otherwise, you’ll be

v

3. I know what the consequences will be if I plagiarise or copy another’s work in any of the assignments for this program.

I declare therefore that all work presented by me for every aspect of my program, will be my 4.

Higher National Diploma in Computing
Assignment Brief

vi

viii

x

B.P.B.C. S Devendra Unit 4: Database

xiii

And this assignment is to create a system for transport company which is SmartMover. This business transport chemicals from one place to another.

This assignment is grate support to the new students which are interesting in Database Design & Development. They can learn how to Create a system by studying this assignment.

1 Acknowledgement.........................................................................................................xiii

2 Introduction...................................................................................................................xiv

1.1.2 Identify entities and attributes of the given scenario and design a relational

database system using conceptual design (ER Model) by including identifiers (primary

1.2 Activity......................................................................................................................28

1.2.1 Explain data normalization with examples. Check whether the provided logical

1.2.3 Explain the validation mechanisms to validate data in the tables with examples.

34

2.1 Activity......................................................................................................................41

2.1.1 a. Develop a relational database system according to the ER diagram you have

B.P.B.C. S Devendra Unit 4: Database

xv

2.2 Activity......................................................................................................................52

2.2.1 Explain the usage of DML with below mentioned queries by giving at least one

(EX: -User groups, access permissions) in the developed database................................54

2.3.2 Implemented System Security...........................................................................57

3.1.1 Provide a suitable test plan to test the system against user and system

requirements....................................................................................................................61

3.3 Activity......................................................................................................................65

3.3.1 Get independent feedback on your database solution from the non-technical

4.1.1 Prepare a simple users’ guide and a technical documentation for the support

and maintenance of the software....................................................................................69

4.3 Activity......................................................................................................................80

B.P.B.C. S Devendra Unit 4: Database

3 Gantt chart......................................................................................................................81

4 References.......................................................................................................................82

Table Of figures
Figure 1:Example for Entity Relationship Diagram (ERD) Tool.............................................24 Figure 2:Symbols used in ER Diagrams..................................................................................24 Figure 3: Symbols used in ER Diagrams.................................................................................25 Figure 4:Smart Movers ERD....................................................................................................26 Figure 5:logical database design using relational database......................................................27 Figure 6:Login form for SmartMovers Database System........................................................31 Figure 7:Control Panel Menu for SmartMovers Database System..........................................31 Figure 8:Customer Management Menu for SmartMovers System..........................................32 Figure 9:New Customer Registration Form for SmartMovers System....................................32 Figure 10;Job Management menu for SmartMovers System...................................................33 Figure 11:New Job Registration form for SmartMovers System.............................................33 Figure 12:Existing Jobs Management form for SmartMovers System....................................34 Figure 13:SmartMovers System Customers Table Using NOT NULL Constraint Validation.35 Figure 14:Error Caused when Null value is entered in a NOT NULL Field............................36 Figure 15: SmartMovers System Customers Table using Data Type Validation......................37 Figure 16: Error Caused when entering a value that is of the wrong data type.......................37 Figure 17:SmartMovers System Payments Table using Format Check Validation..................38 Figure 18:Error Caused when entering data of the wrong data type into a field.....................38 Figure 19:SmartMovers System Loads Table Using Length Check Validation.......................39 Figure 20:Example of error displayed when length is exceeded..............................................40 Figure 21: 1 SQL Script for SmartMovers Database...............................................................43 Figure 22: 2 SQL Script for SmartMovers Database...............................................................43 Figure 23: 3 SQL Script for SmartMovers Database...............................................................44 Figure 24:Creating Database....................................................................................................44 Figure 25:after Created Data....................................................................................................44 Figure 26:Creating Customers Table........................................................................................45 Figure 27:Creating Payment Table...........................................................................................45 Figure 28:Creating Product Table............................................................................................45 Figure 29:Creating Load Table.................................................................................................45 Figure 30:Creating Job Table...................................................................................................46 Figure 31:Creating Depots Table..............................................................................................46 Figure 32:Creating Transport Units Table................................................................................46 Figure 33:Before Insert............................................................................................................47 Figure 34:After Insert...............................................................................................................47 Figure 35:After Edit.................................................................................................................48 Figure 36: Delete Succeed Message.........................................................................................48 Figure 37:After Delete..............................................................................................................49 Figure 38:User interface using join Queries.............................................................................50 Figure 39:Join Queries in SQL.................................................................................................51 Figure 40:Inserting new users into the database......................................................................52 Figure 41:Using DML Language SELECT Query...................................................................53 Figure 42:Updating Products Table Records............................................................................53 Figure 43:Deleting Records Using DML Language................................................................54 Figure 44:- Creating New Database Users...............................................................................56

B.P.B.C. S Devendra Unit 4: Database

xix