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

Looking For Something at vustudents.ning.com? Click Here to Search

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

+ How to Join Subject Study Groups & Get Helping Material?

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

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


See Your Saved Posts Timeline

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)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

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

RSS

Latest Activity

Saif liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
36 minutes ago
Saif liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
36 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + "αяsαℓ " Ќąƶµяɨ •"'s blog post نظر لگنا کیا ہے اور بُری نظر انسان کے جسم پر کیسے اثر انداز ہوتی ہے
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut+'s blog post Things about Arabic Language in an info graphic
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut+'s discussion Qatta Taluq....
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡JK彡 ❤️'s discussion Welcome to Islamabad.... ^_^
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut+'s discussion What is the importance of Virtual University degree in Pakistan?
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut+'s discussion Islam in the Middle of Christianity
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
+ ! ! ! ! ! ! ! ! ! AG liked ϝ ι ყ α's discussion When You Block $omeone.......XD XD !!
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked ϝ ι ყ α's discussion What is Microsoft Excel..............???
50 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
50 minutes ago
ϝ ι ყ α replied to 彡JK彡 ❤️'s discussion ^__^....... Lets Dedicate yOurself A quOte...... ^_^
1 hour ago
+ ! ! ! ! ! " ℛanjha ⋆ updated their profile
1 hour ago
+ ! ! ! ! МĂĤĂŔ βĂŚĨŤ ŚĨĂĹ ^ replied to + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion تربیت اسے کہتے ہیں
1 hour ago
+ ! ! ! ! МĂĤĂŔ βĂŚĨŤ ŚĨĂĹ ^ replied to ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
1 hour ago
+ ! ! ! ! МĂĤĂŔ βĂŚĨŤ ŚĨĂĹ ^ replied to ϝ ι ყ α's discussion *خواتین.........XD XD *
1 hour ago
+ ! ! ! ! МĂĤĂŔ βĂŚĨŤ ŚĨĂĹ ^ replied to ϝ ι ყ α's discussion What is Microsoft Excel..............???
1 hour ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service