Sheet $1\mathrm{.}2$

$$Database Concept term $22024$

$----------------------------------------------------------------------------------------------------------------------$

$1.$ Define the following terms: data, database, DBMS$,$ database catalog, DBA, end user, Transaction, and meta$-$data.

$2.$Discuss the main characteristics of the database approach and how it differs from traditional file system.

$3.$ What are the responsibilities of the DBA and the database designers?

$4.$ What are the different types of database end users? Discuss the main activities of each.

$5.$ Discuss the capabilities that should be provided by DBMS$.$

$6.$ Illustrate and define the transaction's properties.

$7.$ Use the ER$-$to$-$Relational mapping algorithm to map the following ER$-$diagram

into a relational database design.

$$

$8.$ A university registrar$$s office maintains data about the following entities:

$$

$1.$ courses, including number, title, credits, syllabus, and prerequisites;

$2.$ course offerings, including course number, year, semester, section number,

instructor$($s$),$ timings, and classroom;

$3.$ students, including student$-$id$,$ name, and program;

$4.$ instructors, including identification number, name, department, and title.

Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled.

$$

$$Construct an E$-$R diagram for the registrar$$s with all assumptions that you make about the mapping constraints.

$$

$$

$$

$$

$$