CS403 GDB Spring 2019 Solution & Discussion Last Date: 06-08-2019
The Virtual University has a multi-disciplinary approach and offers extensive degree programs in numerous academic disciplines. Although undergraduate and post graduate degrees are awarded in many disciplines, the most sought and highly popular degrees offered by the University are in the fields of Computer and IT. BS, MS and PhD program offered under the department of CS and IT. Students get enrolled and study the relevant courses in a particular semester. VU manages the information about students, degree programs, student’s achievements, course credentials and many more.
Let’s suppose, you are the database designer and asked to design the database of above given scenario.
In order to design the database, you have to choose a data model from the following data models:
As a database designer which data model will you choose for the database designing? Justify your answer in either case with only very solid points.
Relational data model
As a database designer, I’ll choose relational data model for the database designing because the relational model represents the database as a collection of relations. A relation is nothing but a table of values. Every row in the table represents a collection of related data values. These rows in the table denote a real-world entity or relationship.
The table name and column names are helpful to interpret the meaning of values in each row. The data are represented as a set of relations. In the relational model, data are stored as tables. However, the physical storage of the data is independent of the way the data are logically organized.
Relational Integrity constraints are referred to conditions which must be present for a valid relation. These integrity constraints are derived from the rules in the mini-world that the database represents.
Four basic update operations performed on relational database model are
Insert, update, delete and select. The Relational database model represents the database as a collection of relations (tables)Attribute, Tables, Tuple, Relation Schema, Degree, Cardinality, Column, Relation instance, are some important components of Relational Model Relational Integrity constraints are referred to conditions which must be present for a valid relation. The relational database is only concerned with data and not with a structure which can improve the performance of the model
In the above scenario,
The Virtual University has a multi-disciplinary approach and offers extensive degree programs in numerous academic disciplines. So, As a database designer i will use relational model for this system because the other two model hierarchical database model and network model are old models. They have very complex navigation system and Lack of structural independence. All the records are maintained using pointers and hence the whole database structure becomes very complex.
So, I prefer the Relational Model. This can improve the performance of the model. Query capability: It makes possible for a high-level query language like SQL to avoid complex database navigation and Data independence. The structure of a database can be changed without having to change any application. Through the Relational Model, I can easily manage that type of Database system. So, the Relational Model best choice for this system.