Bright is a small technical college that offers information technology skills courses. Their courses run for a duration of six months to twelve months. The course offerings comprise of Java programming, database design, SQL programming and various other software development and network courses. The administration staff record all prospective student information using file system data processing, i.e. is a collection of programs that store and manage files in computer hard-disk. Course offerings and marks are also recorded and managed using file system data processing. This seemed to work fine currently, but will result in huge challenges as Bright College plans to open branches in six other cities. 

Insert Source: own Answer ALL the questions in this section.

 

With reference to the case extract, explain FIVE (5) database management system (DBMS) functions that will guarantee the integrity and consistency of the data stored in Bright College's database. 

 

 Management at Bright College decided to implement a database system to curb the challenges experienced with the traditional file system. In order to simplify designing a database, a database designer may model the database based on degrees of abstraction. In your capacity as the database designer discuss the external model and the conceptual model. 

 

Data modelling is the first step in database design, serving as a bridge between real-world objects and the database model that is implemented in the computer. Therefore, data modelling details are expressed graphically through entity relationship diagrams (ERDs) and are of great importance. Attributes are characteristics of entities.

  Explain FIVE (5) types of attributes that exist in an ERD diagram.