DATABASE MANAGEMENT | Diploma Semester IV Winter 2018 | GTU Papers

Q: Q1. Answer any seven out of ten. દશમ ાથી કોઇપણ સ તન જવ બ આપો. 1. Define Database and Database Management System. ૧. Database અન Database Management System ની વય ખય આપો. 2. Define Data Dictionary and Explain its types. ૨. Data Dictionary ની વય ખય આપો અન એન પરક ર સમજાવો. 3. What is Primary key. ૩. Primary key શ ાછ. 4. State the use of Relational Algebra. ૪. Relational Algebra નો ઉપયોગ દશ ાવો. 5. Why Normalization is Important in Database Designing ? ૫. Database Designing મ Normalization શ મ ટ જરરી છ. 6. Differentiate Weak and Strong entity set. ૬. Weak અન Strong entity set વચચ તફ વત આપો. 7. What is Metadata ? ૭. Metadata શ ાછ 8. List out DDL commands of SQL. ૮. SQL ન DDL commands ની ય દી બન વો. 9. Explain the use of Distinct keyword in SQL. ૯. SQL મ Distinct Keyword નો ઉપયોગ આપો. 10. Explain Data Redundancy. ૧૦. Data Redundancy સમજાવો.

This is question 1 (14 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. Consider a following Relational Schema and give Relational Algebra Expression for the following Queries Students(Name, SPI, DOB, Enrollment_No)

This is question 2 (4 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. List out all students whose SPI is greater than 7.0. ii) List name of student whose enrollment number is 007. (ડ) નીચ દશ ાવલ Relational Schema પર થી Relational Algebra ન Expressions દશ ાવતી Query લખો. Students(Name, SPI, DOB, Enrollment_No)

This is question 2 (4 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. List out all students whose SPI is greater than 7.0. ii) List name of student whose enrollment number is 007.

This is question 2 (null marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. State the difference between Centralized and Distributed database Architecture. પરશન. ર (અ) Centralized અન Distributed Database Architecture વચચ તફ વત આપો.

This is question 2 (3 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. Explain the Advantages of Database system. (અ) Database System ન ફ યદ જણ વો.

This is question 2 (3 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. What is a Foreign Key. Explain all its Options. 1/3 (બ) Foreign Key શ ાછ ? તન બધ Options જણ વો.

This is question 2 (3 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. What is ER Diagram ? Explain all its Notations. (બ) ER Diagram શ ાછ ? તન બધ Notations જણ વો. (C) Explain the three level architecture of DBMS. (ક) DBMS ન ાThree લવલ Architecture સમજાવો.

This is question 2 (4 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. Write a Short Note on Mapping Cardinality. (ડ) Mapping Cardinality ઉપર ટ ક નોધ લખો.

This is question 2 (4 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Q: Q2. Write a short note on SQL VIEW. (ક) SQL VIEW ઉપર ટ ક નોધ લખો.

This is question 2 (4 marks) from the GTU Database Management DI Winter 2018 question paper. Subject code: 3341605.

Questions27

Q114 marks

Answer any seven out of ten. દશમ ાથી કોઇપણ સ તન જવ બ આપો. 1. Define Database and Database Management System. ૧. Database અન Database Management System ની વય ખય આપો. 2. Define Data Dictionary and Explain its types. ૨. Data Dictionary ની વય ખય આપો અન એન પરક ર સમજાવો. 3. What is Primary key. ૩. Primary key શ ાછ. 4. State the use of Relational Algebra. ૪. Relational Algebra નો ઉપયોગ દશ ાવો. 5. Why Normalization is Important in Database Designing ? ૫. Database Designing મ Normalization શ મ ટ જરરી છ. 6. Differentiate Weak and Strong entity set. ૬. Weak અન Strong entity set વચચ તફ વત આપો. 7. What is Metadata ? ૭. Metadata શ ાછ 8. List out DDL commands of SQL. ૮. SQL ન DDL commands ની ય દી બન વો. 9. Explain the use of Distinct keyword in SQL. ૯. SQL મ Distinct Keyword નો ઉપયોગ આપો. 10. Explain Data Redundancy. ૧૦. Data Redundancy સમજાવો.

Consider a following Relational Schema and give Relational Algebra Expression for the following Queries Students(Name, SPI, DOB, Enrollment_No)

[4 marks]

List out all students whose SPI is greater than 7.0. ii) List name of student whose enrollment number is 007. (ડ) નીચ દશ ાવલ Relational Schema પર થી Relational Algebra ન Expressions દશ ાવતી Query લખો. Students(Name, SPI, DOB, Enrollment_No)

[4 marks]

List out all students whose SPI is greater than 7.0. ii) List name of student whose enrollment number is 007.

[ marks]

State the difference between Centralized and Distributed database Architecture. પરશન. ર (અ) Centralized અન Distributed Database Architecture વચચ તફ વત આપો.

[3 marks]

Explain the Advantages of Database system. (અ) Database System ન ફ યદ જણ વો.

[3 marks]

What is a Foreign Key. Explain all its Options. 1/3 (બ) Foreign Key શ ાછ ? તન બધ Options જણ વો.

[3 marks]

What is ER Diagram ? Explain all its Notations. (બ) ER Diagram શ ાછ ? તન બધ Notations જણ વો. (C) Explain the three level architecture of DBMS. (ક) DBMS ન ાThree લવલ Architecture સમજાવો.

[4 marks]

Write a Short Note on Mapping Cardinality. (ડ) Mapping Cardinality ઉપર ટ ક નોધ લખો.

[4 marks]

Write a short note on SQL VIEW. (ક) SQL VIEW ઉપર ટ ક નોધ લખો.

[4 marks]

Explain the different attributes in Database (ક) Database મ બધ Attributes સમજાવો.

[4 marks]

Explain Aggregation and Specialization in ER Diagram. (અ) ER Diagram મ Aggregation અન Specialization સમજાવો.

[3 marks]

State and Explain any two Single row and Group Functions in SQL. (બ) SQL ન કોઈપણ બ Single Row અન Group Functions સમજાવો.

[3 marks]

Explain use of Grant and Revoke command with example. (બ) Grant અન Revoke Command ઉદ હરણ સ થ સમજવો.

[3 marks]

Draw ER Diagram for Student Section. પરશન. 3 (અ) Student Section મ ટ ER Diagram દોરો.

[3 marks]

What are Joins ? Explain the working of any two with example. (ક) Joins શ ાછ. કોઈપણ બ Joins ન ાWorking ઉદ હરણ સ થ સમજાવો.

[4 marks]

What are Constraints ? Explain Domain Integrity constraints NOT NULL and CHECK. (ડ) Constraints શ ાછ? Domain Integrity constraints NOT NULL અન CHECK સમજાવો.

Explain Responsibilities of DBA પરશન. ૪ (અ) DBA ની જવ બદ રીઓ સમજાવો.

[3 marks]

Using SQL commands Create a Table Employee(Name, Age, DOB, DOJ, Post, Salary). After creating this table, Add one more column ‘Deparmtment’ to the table Employee. (અ) SQL commands નો ઉપયોગ કરી Employee(Name, Age, DOB, DOJ, Post, Salary) ટબલ બન વો. તય રપછી ‘Department’ ન મ ની Column ઉમરો.

[3 marks]

Explain the HAVING and ORDERBY clause in SQL with example. (બ) SQL મ ાHAVING અન ORDERBY સમજાવો.

[4 marks]

What is difference Between Truncate Command and Drop Command. (બ) Truncate Command અન Drop Command વચચ તફ વત આપો.

[4 marks]

Explain Normalization in brief. (ક) Normalization વવસત ર થી સમજાવો.

[7 marks]

What is Data Abstraction. Explain 3 Levels of Data Abstraction. પરશન. ૫ (અ) Data Abstraction શ ાછ. Data Abstraction ન ૩ લવલ સમજાવો.

[4 marks]

Share your Views as on what difficulties will we face if there are no Database Management System. (બ) જો Database Management System ન હોઈ તો આપન કવી મ શકલી પડ એન પર તમ રો વવચ ર વયકત કરો.

[4 marks]

Write steps to Create a table ‘FACULTY’ in MS Access and Choosing appropriate datatype. (ક) MS Access મ ટબલ બન વ મ ટ વપર તી યોગય Datatype નો ઉપયોગ કરી ‘FACULTY’ ન મ નો ટબલ બન વ ન Steps લખો .

[3 marks]

Write the Output of Following Query. a. CEIL(123.57), CEIL(4.1), CEIL(-2.3) b. MOD(12,4), MOD(10,4), MOD(3,4) c. POWER(2,3), POWER(3,3), POWER(4,3) d. ROUND(121.413,1), ROUND(121.413,2) e. INITCAP(‘ahmedabad, GUJARAT’) f. LENGTH(‘AHMEDABAD’) (ડ) નીચ દશ ાવલ Query ન ા Output લ ખો. a. CEIL(123.57), CEIL(4.1), CEIL(-2.3) b. MOD(12,4), MOD(10,4), MOD(3,4) c. POWER(2,3), POWER(3,3), POWER(4,3) d. ROUND(121.413,1), ROUND(121.413,2) e. INITCAP(‘ahmedabad, GUJARAT’) f. LENGTH(‘AHMEDABAD’) 3/3

[3 marks]

Database Management — Winter 2018

Questions27

Related Papers