Question collection of database part 1

-
  1. Is there any difference between Database and Database Management System? Explain.
  2. Explain Network Model and Hierarchical Model with diagram.
  3. Design a ER Diagram for Hospital Management System.
  4. Write short notes on (Any TWO)
    1. Primary Key
    2. Mapping Constraints
    3. Instances and Schema
  5. Write down SQL statements for following (Any THREE)
    1. Display all employee whose name is starting from letter ‘R’ and ending with letter ‘H’.
    2. Display all employees no, name, annual salary of department 20.
    3. Display all employees whose salary is greater than their commission.
    4. Display all employees working under department no 10,20,30.
6. Who is Database Administrator (DBA)? Explain their task and dutie

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