it should not be library management system. $(10$pts$)$ Choose a business$/$scientific domain, different than those you have worked on

before in this class, and design a small database under the bottom$-$up paradigm $($Start

with some data!$).$ Stop after your first attempt, making sure your schema is normalized no

higher than $2$NF$.$ I suggest a max of $4$ relations in your schema.

a$.$ Describe in English your database and dataset, including its relevance and

business$/$scientific context.

b$.$ Where did you source it from?

c$.$ Make sure you enumerate the functional dependencies for each relation and assert

in detail their normalization level.

$2)(5$pts$)$ Normalize your DB schema to $3$NF

$3)(5$pts$)$ Normalize your DB schema to BCNF$.$

Note: If your data doesn$$t allow you to do either of these parts, get a different

schema$/$dataset$,$ or modify your schema$/$data accordingly $($no need to show this$).$

$4)(5$pts$)$ Draw a corresponding ER diagram for the database at hand.

$5)(5$pts$)$ Write $10$ queries $(5$ operational and $5$ analytical$)$ in English, relational algebra, as

well as in SQL for your database.$(10$pts$)$ Choose a business$/$scientific domain, different than those you have worked on

before in this class, and design a small database under the bottom$-$up paradigm $($Start

with some data!$).$ Stop after your first attempt, making sure your schema is normalized no

higher than $2$NF$.$ I suggest a max of $4$ relations in your schema.

a$.$ Describe in English your database and dataset, including its relevance and

business$/$scientific context.

b$.$ Where did you source it from?

c$.$ Make sure you enumerate the functional dependencies for each relation and assert

in detail their normalization level.

$2)(5$pts$)$ Normalize your DB schema to $3$NF

$3)(5$pts$)$ Normalize your DB schema to BCNF$.$

Note: If your data doesn$$t allow you to do either of these parts, get a different

schema$/$dataset$,$ or modify your schema$/$data accordingly $($no need to show this$).$

$4)(5$pts$)$ Draw a corresponding ER diagram for the database at hand.

$5)(5$pts$)$ Write $10$ queries $(5$ operational and $5$ analytical$)$ in English, relational algebra, as

well as in SQL for your database.