ICS $311-$Database Management Systems

Homework # $1$: Relational DB

Due: June $3^{RD},20245$:$59$ PM Before class

Explain the concept of physical data independence and its importance in database systems.

five responsibilities of a database$-$management system. For each responsibility, explain the problems that would arise if the responsibility were not discharged.

List at least two reasons why database systems support data manipulation using a declarative query language such as SQL$,$ instead of just providing a library of $C$ or C$++$ functions to carry out data manipulation.

Assume that two students are trying to register for a course in which there is only one open seat. What component of a database system prevents both students from being given that last seat?