$(5)$ What is a database management system and how do rela$9$onal databases organize $(5^{\text{'}})$ What is a database management system and how do relational databases organize data?

$(5\text{'})$ What are $4$ different types of DBMS table relationships. Give a brief explanation for each.

$({10}^{\text{'}})$ What is a primary key and why is it important?

$(5\text{'})$ Some of the Fordham University databases$/$applications represent the year$/$semester attribute of a section in the form $"2023\_2".$ The first four characters are the academic year, and the last character is the semester $(1,2,$ or $3).$ The data type for this attribute might be char$(6).$ Using this example, explain the concepts of domain and atomic domain. How is domain different from type?

$(5\text{'})$ Briefly explain the difference between a schema and instance.

$(20\text{'})$ Design a relational database corresponding to the E$-$R diagram of Figure $1.$

$\text{'}\text{'}$sule $+$

$(20\text{'})$ Construct an E$-$R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars and has one or more premium payments associated with it$.$ Each payment is for a particular period of time, and has an associated due date. and the date when the bavment was received.$({20}^{\text{'}})$ Design an E$-$R diagram for keeping track of the scoring statistics of your favorite

sports team. You should store the matches played, the scores in each match, the players

in each match, and individual player scoring statistics for each match. Summary statistics

should be modeled as derived attributes with an explanation as to how they are

computed.

$({10}^{\text{'}})$ Lab setup

data?

$2.(5)$ What are $4$ different types of DBMS table rela$9$onships. Give a brief explana$9$on for

each.

$3.(10)$ What is a primary key and why is it important?

$4.(5)$ Some of the Fordham University databases$/$applica$9$ons represent the

year$/$semester aOribute of a sec$9$on in the form $"2023\_2".$ The first four characters are

the academic year, and the last character is the semester $(1,2,$ or $3).$ The data type for

this aOribute might be char$(6).$ Using this example, explain the concepts of domain and

atomic domain. How is domain different from type?

$5.(5)$ Briefly explain the difference between a schema and instance.

$6.(20)$ Design a rela$9$onal database corresponding to the E$-$R diagram of Figure $1.$

Figure $1$

$7.(20)$ Construct an E$-$R diagram for a car insurance company whose customers own one

or more cars each. Each car has associated with it zero to any number of recorded

accidents. Each insurance policy covers one or more cars and has one or more premium

payments associated with it$.$ Each payment is for a par$9$cular period of $9$me$,$ and has an

associated due date, and the date when the payment was received.

$8.(20)$ Design an E$-$R diagram for keeping track of the scoring sta$9$s$9$cs of your favorite

sports team. You should store the matches played, the scores in each match, the players

in each match, and individual player scoring sta$9$s$9$cs for each match. Summary sta$9$s$9$cs

should be modeled as derived aOributes with an explana$9$on as to how they are

computed.

$9.(10)$ Lab setup