Organisations depend on their databases to provide information essential for their day-to-day operations and to help them take advantage of today’s rapidly growing and maturing e-commerce opportunities. An understanding of database tools and technologies is an essential skill for designing and developing systems to support them.
Database systems continue to demand more complex data structures and interfaces, as applications get increasingly sophisticated. Most organisations collect and store large volumes of data, either on their own systems or in the cloud, and this data is used not just for the operational running of their business but also mined for other more intelligent and complex applications. Databases stand as the back-end of most systems used by organisations for their operations.
Database design and development is a fundamental and highly beneficial skill for computing students to master, regardless of their specialism.
The aim of this unit is to give students opportunities to develop an understanding of the concepts and issues relating to database design and development, as well as to provide the practical skills to translate that understanding into the design and creation of complex databases.
Topics included in this unit are: examination of different design tools and techniques; examination of different development software options; considering the development features of a fully functional robust solution covering data integrity, data validation, data consistency, data security and advanced database querying facilities across multiple tables; appropriate user interfaces for databases and for other externally linked systems; creating complex reports/dashboards, testing the system against the user and system requirements; and elements of complete system documentation.
On successful completion of this unit students will be able to use appropriate tools to design and develop a relational database system for a substantial problem. They will be able to test the system to ensure it meets user and system requirements and fully document the system by providing technical and user documentation. For practical purposes, this unit covers relational databases and related tools and techniques. A brief overview of object-oriented databases will also be covered.
Students will develop skills such as communication literacy, critical thinking, analysis, reasoning and interpretation, which are crucial for gaining employment and developing academic competence.
What you will study
By the end of this unit students will be able to:
- Use an appropriate design tool to design a relational database system for a substantial problem.
- Develop a fully functional relational database system, based on an existing system design.
- Test the system against user and system requirements.
- Produce technical and user documentation.
How you will learn
ICT is both an academic and a practical subject so you will be taught with a flexible classroom-based method, through different ways, such as lectures, discussions and hands-on activities. We provide you with key reading and research activities, and you will make the most of our learning portal.
Our classrooms are equipped with PCs running Windows 7 and/or Linux and a whole range of industry-standard and educational software from Microsoft, Oracle, Adobe, and others.
Most of our students bring their own laptops, but this is not essential since you can use the school’s facilities. Our Learning Portal Moodle allows you to access electronic learning resources, as well as electronic discussions with lecturers and other students.
Method of Assessment
The purpose of assessment is to ensure that effective learning has taken place of the content of each unit. Evidence of this learning, or the application of the learning, is required for each unit. The assessment of the evidence relates directly to the assessment criteria for each unit. The grading of BTEC Higher National qualifications is at the unit and the qualification level.
Each successfully completed unit will be graded as a pass, merit or distinction. A pass is awarded for the achievement of all outcomes against the specified assessment criteria. Merit and distinction grades are awarded for higher-level achievement.
Summary of grades
|In order to achieve a pass in a unit
- All learning outcomes and associated assessment criteria have been met
|In order to achieve a merit in a unit
- Pass requirements achieved
- All merit grade descriptors achieved and all prescribed indicative characteristics
|In order to achieve a distinction in a unit
- Pass and merit requirements achieved
- All distinction grade descriptors achieved and all prescribed indicative characteristics
Refund through Get Qualified Scheme: €343*
Net Amount: €147*
*Terms and Conditions Apply