Warning: Undefined array key 1 in /home/acaproso/public_html/._System/._Template/.Main.php on line 116
Management to database systems questions.

Management to database systems questions.

Find Management to database systems university examination questions in acaproso.com

# Question
1

The type of relationship that involves three entity types is called ____


Fill in blanks
2

A database concept that describes a set of allowable values for one or more attributes is _____


Fill in blanks
3

Fill in the following gaps for table of alternative terminologies for relational model terms.

Formal term Alternative 1 Alternative 2
i. _________ Table File
Tuple ii. _______ Record
Attribute Column iii. ________

 


Fill in blanks
4

An entity type with an independent existence is referred to as____


Fill in blanks
5

A set of attributes of a weak entity that uniquely distinguish one entity instance from another in the entity set is called_____


Fill in blanks
6

A department has many lecturers . A lecturer belongs to only one department. The department offers many different courses and a course is offered by only one department . Many students enroll to many different courses. A course is taught by only one lecture and lecturers can teach on more than one course.  Draw a complete E-R diagram for this description.


Short answers
7

Map the following E-R diagram into its Relational Schema.

E-R diagrma Management of Database System


Short answers
8

Map each of the following ERD into its corresponding relational schema.

ER diagrams management to database systems


Short answers
9

Map each of the following ERD into its corresponding relational schema.

ER diagrams management to database systems


Short answers
10

Write the letter of the database concept in column B against its corresponding description in column A.

Column A Column B

i. A clause in the sql select statement that specifies the tables to be used in the search for data.

  1. A data type in MYSQL that accepts fixed-length of text data up to 255 characters.
  2. A clause in the sql statement that filters the rows to be displayed.
  3. A client program used to connect to MYSQL databases
  4. Another name used to describe a table
  5. A clause in the sql select statement that specifies the order in which the output is to be displayed
  6. An alternative term used for a tuple
  7. An aggregate function that returns largest value in specified column.
  8. A remote login utility used to connect to MYSQL databases
  9. An aggregate function that returns number of values in a specified column.

A. GROUP BY

  1. TELNET
  2. SUM()
  3. ORDER BY
  4. MYSQLADMIN
  5. CHAR
  6. RELATION
  7. WHERE
  8. COLUMN
  9. COUNT()
  10. DATABASE
  11. FROM
  12. RECORD
  13. PHPMYADMIN
  14. VARCHAR
  15. MAX()
  16. AVG()

 


Matching items