Smart Solutions Development – II (Databases)
Industries store large amount of data for their day to day operations. The data related to customers, employees and machines is all managed using database management system (DBMS). The data can be organized and can be accessed at any point for operations management using DBMS.
This module introduces the theoretical basis of databases and how relational databases can be developed. It will equip students to understand organisational information requirements and can model data solutions using conceptual data modelling techniques. The database design and solutions will be discussed using industry standard DBMS. The fundamental concepts related to data quality and security will be discussed.
An introduction to structured query language (SQL) will be included which will enable students to extract data from the DBMS. The introduction of developing user interface will be covered which can be used for accessing data from DBMS. A part of the course will focus towards designing, implementing, testing and debugging database including front end development according to user requirements so in an effect full stack development will be covered.
Principal Learning Outcomes
By the end of module students will be able to:
• Know the role of data management systems in managing organisational data and information.
• Describe the logical and conceptual data modelling.
• Make entity relationship model for incorporating system and user requirements.
• Use SQL to perform simple queries including adding, updating and deleting queries.
• Identify the data redundancy problems and update anomalies.
• Apply data normalization techniques to combat the data redundancy problem.
• Use a high-level language to create user interface for accessing data from DBMS
• Use analytical and critical thinking skills to technology solutions development
• Analyse and apply structured problem-solving techniques to complex systems and situations.