oQ.5. 2. Make Suitable assumptions wherever necessary. 3. Figures to the right indicate full marks. 4. Use of programmable & Communication aids are strictly prohibited. 5. Use of only simple calculator is permitted in Mathematics. 6. English version is authentic. Q-1 Answer any seven out of ten. 1. Define DBMS and Information DBMS અન Informationની વયાખયા આપો 2. Define Entity and Attribute Entity અન Attributeની વયાખયા આપો 3. List out different joins જદા જદા joins ની યાદી લખો 4. Define REFERENCE KEY REFERENCE KEY ની વયાખયા આપો 5. Write syntax of Create Table command Create Table command લખો 6. What is E-Rdiagram? E–R ડાયાગરામ એટલ શ? 7. List data types used in DBMS ડી.બી.એમ.એસ ના ડટા ટાઇપ ની યાદી લખો 8. Write any four advantages of three tier architecture Three tier architectureની કોઇપણ ચાર ફાયદાઓ લખો 9. Give types of SQL commands SQL COMMANDS ની ટાઇપ આપો 10. What is the NOT NULL constraint? NOT NULL constraint શા છ?
Explain the distributed database architecture Distributed database architecture સમજાવો a Explain components of data dictionary Data dictionaryના ઘટકો સમજાવો. b Define followings: (1) Metadata (2) System Catalog (3) Data Warehouse નીચનાની વયાખયા આપો: (1) Metadata (2) System Catalog (3) Data Warehouse
[3 marks]b Explain second Normal Form (2NF) with example Second Normal Form (2NF) ઉદ હરણ સ થ સમજાવો c Explain UNIQUE KEY and PRIMARY KEY UNIQUE KEY અન PRIMARY KEY સમજાવો c Explain the application of DBMS. DBMSની application સમજાવો d List different Database Systems. Explain Centralized Database System વવવવધ Database Systemsની યાદી બનાવો. Centralized Database System સમજાવો d Explain functions and services of DBMS DBMSન ફનકશન અન સરવિસીસ સમજાવો
[4 marks]Explain Components of a DBMS ડીબીએમએસ ના કમપોનનટસ સમજાવો
[3 marks]a Explain specialization in E-Rdiagram ઇ-આર ડાયાગરામ મા Specializationન સમજાવો b Explain the Client/Server Database System Client/Server Database System સમજાવો
[3 marks]b Explain Distributed Database Systems Distributed Database Systems સમજાવો c Explain Group by clause with example Group by clause ઉદાહરણ સવહત સમજાવો
[4 marks]c Explain Order by clause with example Order by clause ઉદાહરણ સવહત સમજાવો d List different types of Joins. Explain Equi-join with example વવવવધ પરકાર ના Joinsની યાદી બનાવો. Equi-join ઉદાહરણ સવહત સમજાવો
[4 marks]d Write short note: Mapping Cardinality ટ કનોધ લખો : Mapping Cardinality
[4 marks]Explain the Responsibilities of Database Administrator ડટા બઇઝ એડમીનીસટરટરની જવાબદારીઓ સમજાવો a Explain the concept of generalization generalization સમજાવો b Differentiate Physical Data Independence and Logical Data Independence Physical Data Independence and Logical Data Independence નો તફાવત આપો
[4 marks]b Explain union and intersection operations of relational algebra union and intersection of relational algebra ઓપરશન સમજાવો c Explain SQL Functions for different operations with example SQL Functions for different operations ઉદાહરણ સાથ સમજાવો Q5 a Explain the GRANT and REVOKE statement in SQL SQL મા GRANT અન REVOKE statement સમજાવો b Explain select operations of relational algebra with example Relational algebra ના select operations સમજાવો c Consider following table and solve given queries:07 EMP(emp_no, emp_name, desg, salary, deptno) (1) Create table EMP. (2) Display information of all employees whose name starts with ‘p’ and ends with ‘h’. (3) Display department wise salary total. (4) Add new column email_id in EMP table નીચના ટબલન ધયાન મા લો અન આપલી કવરીનો ઉકલ શોધો EMP(emp_no, emp_name, desg, salary, deptno) (1) Create table EMP. (2) Display information of all employees whose name starts with ‘p’ and ends with ‘h’. (3) Display department wise salary total. (4) Add new column email_id in EMP table.
[7 marks]