Database Design and Management
Database Design and Management (Cambria) 2023-24
Ysgol Cyfrifiadureg a Pheirianneg
Modiwl - Semester 1 a 2
Indicative content includes:
● Fundamentals of database design – For example, Relationships between tables, Primary and Foreign Key, data integrity, fields, Data types(such as TEXT, DATE, NUMBER etc)
● Conceptual data modelling (Entity Relationship Model) – For example Logical relationships including One to one, one to many and Many to Many
● Relational design – functional dependency and normalisation (up to third normal form)
● Create a database structure using a suitable front end database. (Create tables, reports, forms and query the database)
● Create a database structure using SQL commands
● Develop SQL commands to maintain a database (CREATE, INSERT, UPDATE, ROLLBACK, COMMIT, JOIN, ALTER etc)
-threshold -Equivalent to 40%.Uses key areas of theory or knowledge to meet the Learning Outcomes of the module. Is able to formulate an appropriate solution to accurately solve tasks and questions. Can identify individual aspects, but lacks an awareness of links between them and the wider contexts. Outputs can be understood, but lack structure and/or coherence.
-good -Equivalent to the range 60%-69%.Is able to analyse a task or problem to decide which aspects of theory and knowledge to apply. Solutions are of a workable quality, demonstrating understanding of underlying principles. Major themes can be linked appropriately but may not be able to extend this to individual aspects. Outputs are readily understood, with an appropriate structure but may lack sophistication.
-excellent -Equivalent to the range 70%+.Assemble critically evaluated, relevant areas of knowledge and theory to constuct professional-level solutions to tasks and questions presented. Is able to cross-link themes and aspects to draw considered conclusions. Presents outputs in a cohesive, accurate, and efficient manner.
- Analyse the data requirements of a system to a design and a relational model.
- Build a database to satisfy the data requirements.
- Demonstrate understanding of the principles of suitable query language.
- Develop a design and a relational model for a given scenario.
The theory of Relational databases and normalisation, including examples. Design a database from a specified scenario. This will include the development of an Entity Relationship Model (ERD)
Laboratory exercise on the topic of SQL You will be given a laboratory exercise on the topic of SQL. The questions will be answered using SQL commands. These commands will include, table creation, insertion and querying.
Implement a Working Database in Access Implement a working database in Access using the designs from Assignment 1. An evaluation on your own performance towards the assignment. 30%, Guideline time to complete this assignment is approximately 21 hours.