An understanding of database tools and technologies is key to many of today’s industries. Database systems are predominant in the world of IT, and continue to demand more complex data structures and interface, as applications get increasingly sophisticated.
Databases provide the infrastructure to many organisations, and they offer support to key business applications and information systems. The most common database model used commercially is the relational one.
The aim of this unit is to provide a knowledge and understanding of database systems including design principles, practical implementation and development skills for both the system designer and software engineer. The importance of structured query languages should be stressed, in terms of how they can be used to manipulate data and how they are used for a variety of tasks including querying and report writing.
On completion of this unit the learner should be able to understand, design, query and implement a database(s). Learners will also have a theoretical insight into the requirement for designing a database that meets a given user or system requirement and that is functional, user friendly and robust.
To provide learners with the knowledge and skills needed to understand, design, query and implement database systems.
4. Be able to test and document relational database systems.
1 Understand data models and database technologies
Data models: Hierarchical; Network; Relational; data manipulation languages; data definition languages; data independence; data redundancy issues; data integrity; schema; e.g. tables fields relationships, views, indexes; conceptual scheme; physical scheme, data dictionary.
Approaches: top down and bottom up; tools and techniques e.g. entity analysis, Entity Relation Diagrams (ERDs), determinacy diagrams, data flow diagrams; entities; attributes and key identifiers; relationship types and enterprise rules; degrees of relationships; functional dependency; first, second and third normal forms New developments: dynamic storage; data mining and data warehousing; web enabled database applications; other developments e.g. multimedia databases, document management systems, digital libraries
2 Be able to design and implement relational database systems
Designs: data types; entity and referential constraints; conversion of logical database design to a physical implementation; tools and techniques; issues around the degree of normalisation chosen; verification and validity checks; data definition; control mechanisms
Requirements: requirements specification; relational requirements; other requirements e.g. need to integrate with legacy systems, future requirements, timescales, costs. User interface: requirements e.g. functionality, reliability, consistency, performance, menu driven, HCI interface
3 Be able to use manipulation and querying tools
Data manipulation: query languages; visual tools; typical tasks e.g. for database maintenance, inserts, updates and amendments
Queries and reporting: query languages and query by example (QBE); formatting; functions/formulae; report writing tools
4 Be able to test and document relational database
Control mechanisms: example systems e.g. Total Quality Management (TQM); connection to requirements specification; sign off procedures.
Testing procedures: test plans; test models e.g. white box, black box; test documentation; other e.g. organisational requirements; user documentation e.g. help menu, pop-ups, hot-spots.
LO1 Understand data models and database technologies
1.1 critically compare different data models and schemas
1.2 critically discuss the benefits and limitations of different database technologies
1.3 analyse different approaches to database design
LO2 Be able to design and implement relational database systems
2.1 design a relational database system to meet a given requirement
2.2 build a relational database system based on a prepared design
2.3 apply a range of database tools and techniques to enhance the user interface
LO3 Be able to use manipulation and querying tools
3.1 explain the benefits of using manipulation and query tools in a relational database system
3.2 implement a query language into the relational database system
3.3 critically evaluate how meaningful data has been extracted through the use of query tools
LO4 Be able to test and document relational database systems
4.1 critically review and test a relational database system
4.2 create documentation to support the implementation and testing of a relational database system
4.3 create user documentation for a developed relational database system
4.4 explain how verification and validation has been addressed
4.5 explain how control mechanisms have been used.
Knowledge and Understanding:
What will 21st century database system development challenges. The data analysis and design related problem to database system development.Tools use for data analyses and design for logical database design such requirements collection for IT system development. Creating Database physical design.Validation and verification of designed database system. Documentation to support data analysis and design for database system.
Section 3: Teaching and learning Methods
The module tutor(s) will aim to combine lectures with tutorial activities. This environment will provide opportunities for the student to understand the course material through case study and text and to apply it in a practical way. The intent is to facilitate interactive class activities, and discussion about the significant role of research in a global and local business environment.
The College’s approach towards teaching and learning is simple and effective. The main aim of UKCBC is to assist learners in maximising their potential by ensuring that they are taught clearly and effectively. This will enable students to engage in the learning environment and promote success in both their academic studies and subsequent career.
Section 4: Assessment Methods -Summary
These will be developed around the key concepts as mentioned in the indicative course content and will use a range of live examples and cases from business practice to demonstrate the application of theoretical concepts. This method is primarily used to identify and explain key aspects of the subject so that learners can utilise their private study time more effectively.
Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...
55 - Completed Orders
Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...
52 - Completed Orders
Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...
102 - Completed Orders
To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...
109 - Completed Orders
JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...
202 - Completed Orders
Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...
20 - Completed Orders
Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...
100 - Completed Orders
Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...
200 - Completed Orders
I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi...
109 - Completed Orders