BSc CS Sem 1 BSc CS Semester 1 (ATKT) 2017-18 Database Systems Question Paper - Mumbai University | munotes

Questions asked in this paper

• 2) Figures to the right indicate marks

1. Q3 Illustrations, in-depth answers and diagrams will be appreciated
2. Q4 Mixing of sub-questions is not allowed
3. Q5 Assume suitable data if necessary and state it clearly
4. Q1 Attempt All. (15M)
   • (a) Multiple Choice Questions in a table represents a relationship among a set of values
   • A) Column
   • B) key
   • C) Row
   • D) Entry
5. Q2 Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
   • A) NAME
   • B) ID
   • C) CITY
   • D) CITY , ID
6. Q3 Which of the following is used to denote the selection operation in relational algebra?
   • A) Pi(Greek)
   • B) Sigma(Greek)
   • C) Lambda(Greek)
   • D) Omega (Greek)
7. Q4 Which of the following query is correct for using comparison operators in SQL: WHERE age>50 & WHERE age<80;
   • D) None of the above
8. Q5 In 2NF
   • A) No functional dependencies exist
   • C) No partial functional dependencies exist
   • D) No partial multivalued dependencies exist
   • (b) Fill in the blanks
9. Q1 Field is otherwise called as . of the record
10. Q2 The related to the concept of multi-valued
11. Q3 The _ operator takes the results of two queries and returns only rows that appear in both result sets
12. Q4 Architecture of the database can be viewed full form of SQL
    • (c) Short Answers
13. Q1 State any two examples based on derived attribute
14. Q2 Write syntax of select operation of relational algebra
15. Q3 What is the output produce by date () function?
16. Q4 Explain the string function Itrim () with example
17. Q5 Define the term DBMS
18. Q2 Attempt the following (Any THREE) (15M)
    • (a) State the drawback of traditional file processing systems
    • (b) Show an E-R diagram illustrating the use entity sets listed Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Pieces of artwork are also classified into groups of various kinds, for example, portraits, still lifes, works by Picasso, or works of the 19th century; a given piece may belong to more than one group Each group is identified by a name (like those just given) that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent in the gallery (very important!), and the artists and groups of art that the customer tends to like
    • Q.P.Code: 12182
    • (c) List and explain List and explain different database users
    • (d) do you mean by Null constraint, Check constraint? Discuss with suitable example?
    • (e) List and explain different types of mapping cardinalities
    • (f) an ER diagram showing movie ticket management system [Assume suitable data and state them clearly.]
19. Q3 Attempt the following (Any THREE) (15M)
    • (a) Giving 2 examples explain | NF
    • (b) Explain any 3 aggregate functions with examples
    • (c) Discuss cross product, union operations from relational algebra with suitable example
20. Q1 Create a table student (rollno, name, address) rollno is PK
21. Q2 Insert 2 records
22. Q3 Delete a record whose rollno is 3 marks
23. Q4 Find a record whose name starts with a
    • (e) How to perform commit and rollback operation give example to support your answer Construct tables from the above ER diagram. [assume suitable mapping cardinalities and mention them.]
    • Q.P.Code: 12182
24. Q4 Attempt the following (Any THREE) 15 marks
    • (a) Explain the concept of functional dependency with suitable
    • (b) Describe the process of creating user in mysql
    • (c) a short note on how to create a view with suitable example
    • (d) Perform following by assuming suitable data and database
25. Q1 Create a report that shows the city, company name, and contact name of all customers who are in cities that begin with "A" or "B." Sort by contact name in descending order
26. Q2 Create a report that shows the company name, contact name and fax number of all customers that have a fax number. Sort by company name
27. Q3 select name from student where name like '%i';
    • (e) do you mean by privilege with respect to database and its types
    • (f) Discuss various types of Threats to Databases
28. Q5 Attempt the following (Any THREE) 15 marks
    • (a) Consider the following entities for a hospital management system Equipment: The main attributes are identification number, name, description of its functionalities, type, location, purchase cost, Department: The main attributes are identification number, name, address, total number of doctors, total number of nurses, etc Doctor: The main attributes are identification number, name, address, area of specialty, current working schedule, etc Nurse: The main attributes are identification number, name, Patient: The main attributes are identification number, name, address, type (inpatient or outpatient), disease, etc Room: The main attributes are room number, type (operating Draw ER diagram and define relationships
    • Q.P.Code: 12182
    • (b) Write queries in relational algebra form:
29. Q1 Find the information of name “ram” from student table
30. Q2 Select the records from student table who has marks > 60 marks
31. Q3 Find all students having marks< 40 from student table
32. Q4 Rename student table to SST
33. Q5 Find name from student whose address is virar
    • (c) Discuss avg (), max (), min () functions with suitable example
    • (d) Write a note on sub-query and provide example
    • (e) Define the terms data, information, entity, attribute, relationship

Read from the scan above, so a character or two may differ. The scan is the original.