We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

# CS403 GDB Spring 2019 Solution & Discussion Last Date: 06-08-2019

CS403 GDB Spring 2019 Solution & Discussion Last Date: 06-08-2019

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 852

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

### Replies to This Discussion

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:

• Hierarchical data model
• Network data model
• Relational data model

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

CS403 GDB Solution required.................
GDB Topic:
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:
• Hierarchical data model
• Network data model
• Relational data model
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.
Note: Answer should not exceed 200 words.

# CS403 GDB solution

## SOLUTION:

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.

# CS403 GDB Solution Spring 2019 Date:8/8/2019

## Latest Activity

36 minutes ago
36 minutes ago
50 minutes ago
50 minutes ago
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡ＪＫ彡 ❤️'s discussion Welcome to Islamabad.... ^_^
50 minutes ago
50 minutes ago
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked ++!!! Queen of Koheqaaf's discussion QADAR:
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Sajid's discussion جس کا خدا نہ ہو
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + Adeeena's discussion chay or tum : /
50 minutes ago
50 minutes ago
50 minutes ago
50 minutes ago
1 hour ago
+ ! ! ! ! ! " ℛanjha ⋆ updated their profile
1 hour ago
1 hour ago
1 hour ago
1 hour ago
1 hour ago

1

2

3