Scribd
Upload
7 views27 pages

Database Management

The document outlines the limitations of file-based data storage and retrieval, and describes how relational databases address these issues. It covers key concepts such as entity-relationship diagrams, normalization processes, and the roles of Data Definition Language (DDL) and Data Manipulation Language (DML) within Database Management Systems (DBMS). Additionally, it emphasizes the importance of Structured Query Language (SQL) for database operations.

Uploaded by

daizhuomingdai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views27 pages

Database Management

The document outlines the limitations of file-based data storage and retrieval, and describes how relational databases address these issues. It covers key concepts such as entity-relationship diagrams, normalization processes, and the roles of Data Definition Language (DDL) and Data Manipulation Language (DML) within Database Management Systems (DBMS). Additionally, it emphasizes the importance of Structured Query Language (SQL) for database operations.

Uploaded by

daizhuomingdai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 27

DATABASE

&
DATA
MODELLING
• show understanding of the limitations of using a file-based approach for the storage
and retrieval of data
• describe the features of a relational database which address the limitations of a file-
based approach
• Show understanding of and use the terminology
associated with a relational database model
• Use an entity-relationship (E-R) diagram to
document a database design
• Show understanding of the normalisation process
• Explain why a given set of database tables are, oare not, in 3NF
• Produce a normalised database design for a description of a database, a given set
of data, or a given set of tables
• Show understanding of the features provided by a Database Management System
(DBMS) that address the issues of a file based approach
• Show understanding of how software tools found within a DBMS are used in
practice
• Show understanding that the DBMS carries out all creation / modification of
the database structure using its Data Definition Language (DDL)
• Show understanding that the DBMS carries out all queries and maintenance
of data using its DML
• Show understanding that the industry standard for both DDL and DML is
Structured Query Language(SQL)
• Understand given SQL (DDL) statements and be able to write simple SQL
(DDL) statements using a sub-set of statements

You might also like