Download Dtabase project report and more Assignments Database Programming in PDF only on Docsity!
Higher Nationals Internal verification of assessment decisions – BTEC (RQF) INTERNAL VERIFICATION – ASSESSMENT DECISIONS Programme title Database Design & Development Assignment 01 Assessor Mr. Nuwan Hirantha Internal Verifier Unit(s) Unit 04: Database Design & Development Assignment title Database system for the Smart Movers Transport Company Student’s name List which assessment criteria the Assessor has awarded. Pass Merit Distinction INTERNAL VERIFIER CHECKLIST Do the assessment criteria awarded match those shown in the assignment brief?
Y/N
Is the Pass/Merit/Distinction grade awarded justified by the assessor’s comments on the student work?
Y/N
Has the work been assessed accurately?
Y/N
Is the feedback to the student: Give details:
- Constructive?
- Linked to relevant assessment criteria?
- Identifying opportunities for improved performance?
- Agreeing actions?
Y/N
Y/N
Y/N
Y/N
Does the assessment decision need amending?
Y/N
Assessor signature Date Internal Verifier signature Date Programme Leader signature (if required) Date 1 | P a g e
Confirm action completed Remedial action taken Give details: Assessor signature Date Internal Verifier signature Date Programme Leader signature (if required) Date 2 | P a g e
- Please note that grade decisions are provisional. They are only confirmed once internal and external moderation has taken place and grades decisions have been agreed at the assessment board. Pearson Higher Nationals in Computing Unit 04: Database Design & Development Assignment 01 4 | P a g e
General Guidelines
- A cover page or title page should be attached to your assignment. Use page 1 of this assignment brief as your cover page and make sure all details are accurately filled.
- The entire assignment brief should be attached as the first section of your assignment.
- The assignment should be prepared using a word processing software.
- The assignment should be printed single sided in an A4 sized paper.
- Allow 1” margin on top, bottom and right sides of the paper and 1.25” on the left side (for binding). Word Processing Rules
- The font size should be 12 point and should be in the style of Time New Roman.
- Set line spacing to 1.5. Justify all paragraphs.
- Ensure that all headings are consistent in terms of size and font style.
- Use footer function on the word processor to insert your name, unit, assignment no, and page number on each pag e. This is useful if individual sheets get detached from the submission.
- Use the spell check and grammar check function of the word processing application to review the use of language on your assignment. 5 | P a g e
Student Declaration I hereby, declare that I know what plagiarism entails, namely, to use another’s work and to present it as my own without attributing the sources in the correct form. I further understand what it means to copy another’s work.
- I know that plagiarism is a punishable offence because it constitutes theft.
- I understand the plagiarism and copying policy of Edexcel UK.
- 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 own, and where I have made use of another’s work, I will attribute the source in the correct way.
- I acknowledge that the attachment of this document signed or not, constitutes a binding agreement between myself and Edexcel UK.
- I understand that my assignment will not be considered as submitted if this document is not attached to the assignment. [email protected] Student’s Signature: Date: ( Provide E-mail ID ) ( Provide Submission Date ) 7 | P a g e
Higher National Diploma in Computing Assignment Brief Student Name /ID Number (^) T.M. Rumasha Minakshi Dharmarathna/KJ Unit Number and Title (^) Unit 4: Database Design & Development Academic Year 2017/ Unit Tutor Mr. Nuwan Hirantha Assignment Title Data base system for the Smart Movers Transport Company Issue Date Submission Date IV Name & Date Submission format Part 1: The submission is in the form of an individual written report. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system. Please also provide a bibliography using the Harvard referencing system. The recommended word limit is 2,000–2,500 words, although you will not be penalised for exceeding the total word limit. Part 2: The submission is in the form of a fully functional relational database system demonstrated to the Tutor; and an individual written report (please see details in Part 1 above). Part 3: The submission is in the form of a witness statement of the testing completed by the Tutor; technical documentation; and a written report (please see details in Part 1 above). Unit 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: *Please note that assignment guidance is for reference only and should be more specific in detail to meet customized needs. Assignment brief Case study You are employed as a Database Developer for a large IT development company. 8 | P a g e
above scenario. b. Identify entities and attributes of the given scenario and design a relational database system using conceptual design (ER Model) by including identifiers (primary Key) of entities and cardinalities, participations of relationships. c. Convert the ER Model into logical database design using relational database model including primary keys foreign keys and referential Integrities. It should contain at least five interrelated tables. Note: -It is allowed to have your own assumptions and related attributes within the scope of the case study given. Task 1. (M1) Produce a comprehensive design for a fully functional system, which includes interface and output designs, data validations and data normalisation. a. Explain data normalization with examples. Check whether the provided logical design in task 1.1 is normalised. If not, normalize the database by removing the anomalies. b. Design set of simple interfaces to input and output for the above scenario using Wireframe or any interface-designing tool. c. Explain the validation mechanisms to validate data in the tables with examples. Task 1. (D1) Assess the effectiveness of the design in relation to user and system requirements a. Check whether the given design (ERD and Logical design) is representing the identified user and system requirements to access the effectiveness of the design. Task 2 - LO2 Develop a fully functional relational database system, based on an existing system design Task 2. (P2) Develop the database system with evidence of user interface, output and 10 | P a g e
data validations, and querying across multiple tables. a. Develop a relational database system according to the ER diagram you have created (Use SQL DDL statements). b. Implement the validation methods explained in task 1.2-part c. c. Display the details payment with the job details and the customer details using Join queries Task 2. (P3) Implement a query language into the relational database system a. Explain the usage of DML with below mentioned queries by giving at least one single example per each case from the developed database. Select Update Delete Note: - The queries you have selected should be meaningful and relevant to the given scenario. Task 2. (M2) Implement a fully functional database system, which includes system security and database maintenance. a. Explain how security mechanisms have been used and the importance of these mechanisms for the security of the database. Implement proper security mechanisms (EX: -User groups, access permissions) in the developed database. Task 2. (M3) Assess whether meaningful data has been extracted using query tools to produce appropriate management information. a. Explain the usage of the below SQL statements with the examples from the developed database Group by Order by 11 | P a g e
Task 4. (M5) Produce technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works. a. Your technical documentation should include some of the UML diagrams (Use case diagram Class diagram, etc.), flow charts for the important functionalities, context level DFD and the Level 1 DFD Task 4. (D3) Assess any future improvements that may be required to ensure the continued effectiveness of the database system. a. Suggest the future improvements that may be required to ensure the continued effectiveness of the database system. 13 | P a g e
Grading Criteria Ach ieve d Feedback LO1 Use an appropriate design tool to design a relational database system for a substantial problem 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 that includes interface and output designs, data validations and data normalization. D1 Assess the effectiveness of the design in relation to user and system requirements. LO2 Develop a fully functional relational database system, based on an existing system design P2 Develop the database 14 | P a g e
of the database solution in relation to user and system requirements and suggest improvements. LO4 Produce technical and user documentation P5 Produce technical and user documentation. M5 Produce technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works. D3 Assess any future improvements that may be required to ensure the continued effectiveness of the database system. 16 | P a g e
Database design and development
UNIT
SMART MOVERS Database Management System
17 | P a g e
Task 1 – (LO1) Use an appropriate design tool to design a relational database system for a substantial problem Task 1. b. Identify the user and system requirements to design a database for the above scenario. Introduction about requirement Functional requirements describe a list of functions that the system must accomplish. Non- functional requirements describe other constraints such as performance expectations or standards to be used. The discussion centres on functional requirements. Knowing what is to be built is one of the most important aspects of a software development process. Getting the requirements in line with what the actual user need is also a very important aspect. 19 | P a g e
User Requirement
user requirements are functional
requirements.
They work for visible and
important users that a system
must provide to meet the
business objectives it is
designed to achieve.
SystemRequirement
System requirements are non-
functional requirements. They
deal with features that the
system must meet to provide
reliability,usability,maintenanc
e,availability and all other
"capabilities" that are
important for the proper
functioning of the system.
They are common features of
the system and are not directly
observable to the user.
According to SMARTMOVERS, user requirement system Requirements Add new customer Create suitable table with customer’s information’s using record system. Payment options Create payment table include billing systems and card payment system. Record products Create products table (using categories chemicals) Transport option Create job table. Start and end location Create depot table. Carrying the chemicals Create chemical type table. Unique numbers are giving to the system registered customers. Create all customer type table. Generate job including unique number. Create load type table. Transported expending a specific transport unit. Create transport unit table. Maintain all technical and system issues. Backup storage in system. Configuer 20 | P a g e
