Question of Nobel College DBMS 2005

-

NOBEL COLLEGE
Sinamangal, Kathmandu

Final Assesment 2005


Section :BCIS IV                                                                               F.M 100
Subject : DBMS                                                                                P.M 50
                                                                                                            Time:3 hrs     
Attempt all the questions.
1.         a.   Explain the advantages and disadvantages of the DBMS [8]
            b   What are the various component of DBSM                      [7]

2.         a.  Explain the E-R data model with the suitable example.    [9]
            b) Explain the importance of feasibility study in database design [6]

3.         a.   Explain the importance of the normalization in database. Explain about the first, second and third normal form. [9]
            b.   Consider the following table with the given functional dependencies, primary keys are underlined: [6]
            Drinkers (name, address, beersLiked, manufacturer, favBeer)
            name->address, favBeer
            beersLiked->manufacturer
State in which normal form the given table is and normalize it up to 3NF.
4. a.  Consider the following class diagram and write the SQL syntax to create necessary tables. [7]         



 









b. Write SQL syntax to perform the following operations:[4X2=8]
                                                 I.      Insert data into the employee table
                                              II.      Alter table department to add column branch.
                                           III.      Show name of all employees who live in Kathmandu.
                                           IV.      Display the no. of employees working in each department.

6.         a.  Define the functions of Data Administrator and Database Administrator. [8]
b.   Explain the Cryptographic technique used in the database.[7]

7.         a.   Define Distributed Database System with its important properties.[8]
b. What is client server database? Explain its advantage over file server.[7]

8.         Write short notes. (Any two): [5X2=10]
a)      Data types
b)      Transaction
c)      Horizontal and vertical partitioning.

****Good Luck****

Comments

Post a Comment

Popular posts from this blog

Opencart error: Notice: Trying to access array offset on value of type null in ..../vendor/scss.inc.php on line 1753

-
Image
If you see an error in opencart like below: Notice: Trying to access array offset on the value of type null in .../vendor/scss.inc.php on line 1753 then the solution is: Open the file  .../vendor/scss.inc.php and go to line as given in the above case it is 1753 where you will see code like below: foreach ($args as $arg) {     list($key, $value) = $arg;     $key = $key[1];     if (empty($key)) {         $posArgs[] = $value;     } else {         $keyArgs[$key] = $value;     } } Then change the line to the following, the changes done is in bold.  foreach ($args as $arg) {     list($key, $value) = $arg;     if (!empty($key[1])) {         $key = $key[1];     }     if (empty($key)) {         $posArgs[] = $value;     } else {         $keyArgs[$key] = $value;     } }    
Read more

Creating Class Templates

-
Image
Creating Class Templates Class templates are useful for creating abstract data types, which can then be used to create classes based on specific data types. For example, you can use a linked list template to parameterize the data that is held at each of the link list's nodes. You can use class templates to create collection templates, create new data types, and modify existing data types. This section includes the following topics: Class Template Syntax Class templates are composed of three elements: ® The template keyword ® A comma-delimited list of formal parameters, enclosed in angle brackets ( <> ) ® The class definition A class that is generated from a template is sometimes called a templated class. You can use class templates to modify existing classes. For example, you can define a class template that adds reference counting to an object as follows: template <class T> class TCount { int m_count; T m_type; public: TCount(
Read more

Fixed: Opencart installation error linux: warning: fopen(system/storage) failed to open stream: Permission denied

-
Image
Warning: fopen(/var/www/html/webocreation.com/system/storage/session/....): failed to open stream: Permission denied in /var/www/html/webocreation.com/system/library/session/file.php on line 29 Warning: flock() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 31 Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 33 Warning: fflush() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 35 Warning: flock() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 37 Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/html/webocreation/system/library/session/file.php on line 39    These errors occurs because of the file permissions. In most of the forum, I found that they suggested to give full
Read more