Answer to Question #257533 in Databases | SQL | Oracle | MS Access for junior

Question

a) What is Relational Database Management Systems (DBMS)? Give three examples of

DBMS    

b) The entity “Student” has attributes such as Student ID, First Name, Last Name. Give three examples of other entities and list three attributes for each one of them.

 c) Provide a unique attribute you will use to identify each entity you listed for Qb

d) Provide five IT roles you would like to endorse in your future company.

Answer 1

ANSWER TO THE ABOVE QUESTION

a) What is Relational Database Management Systems (DBMS)? Give three examples of

DBMS  

ANSWER. 

An RDBMS is a type of database management system (DBMS) that stores data in a row-based 

table structure which connects related data elements. RDBMS makes sure the the data stored

is secure, accurate and that

its integrity and consistency is maintained.

EXAMPLES OF DBMS.

Oracle.

MySQL.

PostgreSQL.

b) The entity “Student” has attributes such as Student ID, First Name, Last Name.

 Give three examples of other entities and list three attributes for each one of them.

ANSWER.

i)Entity "Course"

 Attributes: course_code, course_title, course_duration.

ii)Entity "Department"

 Attributes: department_number, department_name, department_location 

iii)Entity "Transaction"

 Attributes: transaction_Number, transaction_type, transaction_amount

 c) Provide a unique attribute you will use to identify each entity you listed for Qb

 ANSWER.

  i)Unique attribute for "Course" entity is "course_code"

 ii)Unique attribute for "Department" entity is "course_code"

 iii)Unique attribute for "Transaction" entity is "transaction_Number, "

d) Provide five IT roles you would like to endorse in your future company.

 

ANSWER.

 i)Help Desk Support to offer assistance to customers.

 ii)Network Administration.

 ii)Systems Engineering Management

 iv)IT Project Management

  v)Hardware engineering