WikiSysop at 10:04, 12 January 2025

2025-01-12T10:04:41Z

← Older revision		Revision as of 06:04, 12 January 2025
Line 1:		Line 1:
	TRIBHUVAN UNIVERSITY		== TRIBHUVAN UNIVERSITY ==
	2081-ii (New/Old Course)		2081-ii (New/Old Course)

	Bachelor/Education/4th Semester		Bachelor/Education/4th Semester

	ICT.Ed.446 Database Management System		ICT.Ed.446 Database Management System

	Full Marks: 40		Full Marks: 40

	Time: 3 hrs.		Time: 3 hrs.

	Candidates are required to give answers in their own words as far as practicable. The figures in the margin indicate full marks.		'''Candidates are required to give answers in their own words as far as practicable. The figures in the margin indicate full marks.'''
	~~Attempt all questions~~

	Group "B"		'''Attempt all questions'''
	6 X 5 marks =30
			Group "B" 6 X 5 marks =30

	1. What do you mean by anomalies in database? Explain each type of anomalies with example.		1. What do you mean by anomalies in database? Explain each type of anomalies with example.
Line 18:		Line 22:
	3. Discuss mapping constraints, participation constraints and integrity constraints with example.		3. Discuss mapping constraints, participation constraints and integrity constraints with example.

	OR		''OR''

	Why view is created? Describe level of abstraction in brief.		Why view is created? Describe level of abstraction in brief.

	4. Define transaction. Explain transaction properties with		4. Define transaction. Explain transaction properties with examples.

	~~examples~~.		5. Read following paragraph and make E-R diagram on the basis of given paragraph.<blockquote>Actors play movies. One movie can have more than one actor and one actor can work in several movies. Movies must contain at least one actor. Movies have name, release_date, length. Actors are described by id (unique), name (composite), age(derived), address(multivalued). Movies are directed by directors. A director directs one or more movies and a movie is directed by more than one director. Directors have name, address, age and perfection. (here perfection means type of movie in which director is well-known like: comedy, action, drama etc). Movie must contain at least one director.</blockquote>OR

	~~5. Read following paragraph and make E-R diagram on the basis of given paragraph.~~		Consider following relations:<blockquote>Actor(actor id, name, age, address)

	Actors play movies. One movie can have more than one actor and one actor can work in several movies. Movies must contain at least one actor. Movies have name, release_date, length. Actors are described by id (unique), name (composite), age(derived), address(multivalued). Movies are directed by directors. A director directs one or more movies and a movie is directed by more than one director. Directors have name, address, age and perfection. (here perfection means type of movie in which director is well-known like: comedy, action, drama etc). Movie must contain at least one director.

	OR

	Consider following relations:

	Actor(actor id, name, age, address)
	Movies (movie no, name, release_date, duration)		Movies (movie no, name, release_date, duration)
	Acts(actor_id, movie_no)		Acts(actor_id, movie_no)
Line 44:		Line 40:
	v. Delete record of all movies which is of less than 85 minutes.		v. Delete record of all movies which is of less than 85 minutes.
	6. Consider following relations:		6. Consider following relations:
	Employee(eid, ename, age, address) Department(dept_no, name, phoneno) Works(eid, dept_no, joined_date)		Employee(eid, ename, age, address) Department(dept_no, name, phoneno) Works(eid, dept_no, joined_date)</blockquote>6.Write SQL statements for following queries:

	~~Write SQL statements for following queries:~~
	i. Retrieve name of department which phone number is 444444.		i. Retrieve name of department which phone number is 444444.

	ii. Retrieve name of employee who joined department on		ii. Retrieve name of employee who joined department on
	'2010-04-01'		'2010-04-01'

	iii. Remove employee named ram who worked in finance department.		iii. Remove employee named ram who worked in finance department.

	iv. Modify name attribute of department which can hold 70 characters.		iv. Modify name attribute of department which can hold 70 characters.

	v. Display those employees who do not belong to any department.		v. Display those employees who do not belong to any department.

WikiSysop: Created page with "TRIBHUVAN UNIVERSITY 2081-ii (New/Old Course) Bachelor/Education/4th Semester ICT.Ed.446 Database Management System Full Marks: 40 Time: 3 hrs. Candidates are required to give answers in their own words as far as practicable. The figures in the margin indicate full marks. Attempt all questions Group "B" 6 X 5 marks =30 1. What do you mean by anomalies in database? Explain each type of anomalies with example. 2. 'Using DBMS in place of file system is advantageous'. J..."

2025-01-12T10:02:43Z

Created page with "TRIBHUVAN UNIVERSITY 2081-ii (New/Old Course) Bachelor/Education/4th Semester ICT.Ed.446 Database Management System Full Marks: 40 Time: 3 hrs. Candidates are required to give answers in their own words as far as practicable. The figures in the margin indicate full marks. Attempt all questions Group "B" 6 X 5 marks =30 1. What do you mean by anomalies in database? Explain each type of anomalies with example. 2. 'Using DBMS in place of file system is advantageous'. J..."

New page

TRIBHUVAN UNIVERSITY
2081-ii (New/Old Course)
Bachelor/Education/4th Semester
ICT.Ed.446 Database Management System
Full Marks: 40
Time: 3 hrs.

Candidates are required to give answers in their own words as far as practicable. The figures in the margin indicate full marks.
Attempt all questions

Group "B"
6 X 5 marks =30

1. What do you mean by anomalies in database? Explain each type of anomalies with example.

2. 'Using DBMS in place of file system is advantageous'. Justify it.

3. Discuss mapping constraints, participation constraints and integrity constraints with example.

OR

Why view is created? Describe level of abstraction in brief.

4. Define transaction. Explain transaction properties with

examples.

5. Read following paragraph and make E-R diagram on the basis of given paragraph.

Actors play movies. One movie can have more than one actor and one actor can work in several movies. Movies must contain at least one actor. Movies have name, release_date, length. Actors are described by id (unique), name (composite), age(derived), address(multivalued). Movies are directed by directors. A director directs one or more movies and a movie is directed by more than one director. Directors have name, address, age and perfection. (here perfection means type of movie in which director is well-known like: comedy, action, drama etc). Movie must contain at least one director.

OR

Consider following relations:

Actor(actor id, name, age, address)
Movies (movie no, name, release_date, duration)
Acts(actor_id, movie_no)
Write Relational algebra for following queries:
1. Display name of actors from "Kathmandu".
ii. List name of movies that are acted by "Rajesh".
iii. Insert record (111, Tom Curise', 'LA') into actor relation
iv. Update attribute address of actor named "Steve" to "KTM"
v. Delete record of all movies which is of less than 85 minutes.
6. Consider following relations:
Employee(eid, ename, age, address) Department(dept_no, name, phoneno) Works(eid, dept_no, joined_date)

Write SQL statements for following queries:
i. Retrieve name of department which phone number is 444444.
ii. Retrieve name of employee who joined department on
'2010-04-01'
iii. Remove employee named ram who worked in finance department.
iv. Modify name attribute of department which can hold 70 characters.
v. Display those employees who do not belong to any department.

[[Category:OLD is Gold]]
[[Category:Database Management System]]
[[Category:2081]]
[[Category:BICTE]]
[[Category:4th Semester]]

BICTE ICTED 446 Database Management System 2081 - Revision history

WikiSysop at 10:04, 12 January 2025