|
 Academic Year:
| 2013/4 |
| Owning Department/School:
| Department of Computer Science (administered by the Learning Partnerships Office) |
| Credits:
| 6 |
| Level:
| Intermediate (FHEQ level 5) |
| Period: |
Semester 2 at City of Bath College Semester 2 at Weston College Semester 2 at Wiltshire College |
| Assessment:
| CW 60%, EX 40% |
| Supplementary Assessment: |
Like-for-like reassessment (where allowed by programme regulations) Supplementary assessment information not currently available (this will be added shortly) |
| Requisites:
| |
| Description:
| Aims: To enable the learner to: * further an understanding of the design concepts of databases in the business environment. * identify a range of data structures and models as well as to critically examine the current implementations of database management systems. * understand how a DBMS processes and executes queries and to be able to import and export data between different database applications. * identify the functions and procedures necessary for the management and control of database systems (e.g. referential integrity and data security). Learning Outcomes: Learners should be able to: * appreciate databases, data management systems and their applications. * understand the underpinning of database design principles. * be able to design, create and document relational databases for a small business application from given user requirements. * use suitable query languages to interrogate a relational database. * discuss data independence and security, quality control and recovery procedures. Skills: Practical skills - database management skills, DDL - taught and assessed Personal skills - time management, personal organization, working with others, independent research, problem solving - facilitated Communication skills - clarity of thought demonstrated in oral explanations of the concepts; facilitated and assessed. Content: This unit will cover the following areas: Databases and data management systems * Databases: e.g. architectures, data structures, data views, data consistency, data redundancy, data formats, query languages. * Databases in a commercial context: applied database solutions * Database Management Systems (DBMS): advantages, limitations, structures, and specifications Database tools and techniques * Physical and logical design. * Relational Database concepts (e.g. terms as well as normalization). Design, create and document database production * Requirements analysis. * User interface. * Justification of the database application. * Appraisal of the design solution. * Technical and user documentation. |
| Programme availability: |
LP20549 is Optional on the following programmes:Programmes administered by the Learning Partnerships Office
|