Data Modelling and SQL Language
Task 1: Understanding of database
RDBMS and file based systems
When implementing databases, it is essential for one to identify the most suitable file storage system. Other than a file system the database management system comes handy for an integrated database that runs institutions. File systems and database management systems exhibit advantages and disadvantages which people utilize to consider the most suitable.
File system advantages and disadvantages
Advantages
The file systems works efficiently for small data as it requires less amount of time to search or access files. The file system offers a simple means of downloading and storage of files. Data migration becomes simple for the case of file system and it is relatively cost effective. File system storage is also simple to migrate to cloud storage solutions.
Disadvantages
The disadvantages associated with file system could be that the file system becomes loosely packed and consistency is not guaranteed. The security of the file system is never guaranteed, and it easy to hack. It is not safe to make use of the file system if one intends to make use of a large file system.
RDBMS advantages and disadvantages
Advantages
The main benefits associated with a relational database involves the synchronization feature that ensures all data is visible from any point of the database. Files are automatically backed within the data. The relational database files become easy to secure unlike the file system.
Disadvantages
The first weakness associated with an RDBMS is that the data requires conversion before it gets implemented. Regular database updates are necessary for the database to synchronize all data elements. The RDBMS requires the RAM to operate, and thus ineffective at times.
Task 2: Concept modelling
Task 3: Logical Modelling
Task 4: SQL Script