You have to be signed in to use this resource.
Introduction to Database systems
what you will learn
- Student will recognize meaning of database, DBMS, component of DBMS environment, Advantages and disadvantages of DBMS, and three-level database architecture
- Student will understand terminology of relational model and how to use Entity–Relationship (ER) modeling in database design
- Student will understand the purpose of normalization, data redundancy, how to identify functional dependencies, the process of normalization
- Student will understand data types supported by SQL standard, how to create a table and define integrity constraints using SQL
- Student will understand how to update database using INSERT, UPDATE, and DELETE, how to retrieve data from one table and multiple table using SELECT
Resource details
| Contributed by: | Digital Academy |
| Authored by: |
|
| Licence: | More information on licences |
| First contributed: | 19 May 2025 |
| Audience access level: | Full user |
Share this resource
Report an issue with this resource
You may report a resource, for example, if there is an issue with copyright infringement, breach of personal data, factual inaccuracies, typing errors or safety concerns. The type of issue will determine whether the resource is immediately removed from the platform or if the contributor is asked to make amendments. You can report a resource from the resource information page or by contacting the Learning Hub support team.
You can contact the Learning Hub support team by completing the support form or if you have a general enquiry you can email enquiries@learninghub.nhs.uk.