Functional Database Requirements $(4$ points$)$

Functional requirements are the ones that focus on the services provided to cover the database user needs. For example, "A user shall be able to log into the system from multiple devices". Functional requirements are grouped by the entity that performed the action.

Students must provide at least $60$ functional database requirements, and they must be enumerated and grouped by the entity that performs the action. The following are some examples of database requirements extracted from a library database management system

$1.$ User

$1\mathrm{.}1.$ A user shall create only one account

$1\mathrm{.}2.$ A user shall be able to check out multiple books at a time

$1\mathrm{.}3.$ A user shall have at least one role.

$2.$ Account

$2\mathrm{.}1.$ An account shall be created by only one user.

$3.$ Role

$3\mathrm{.}1$ A role shall be linked to many users.

$4.$ Book

$4\mathrm{.}1$ A book can be checked out by multiple users

Functional database requirements listed in this section must cover ALL the following relationships:

Many$-$to$-$Many

One$-$to$-$One

Many$-$to$-$One

One$-$to$-$Many

ISA

Aggregation

Recursive

Section V: Non$-$functional Database Requirements $(4$ points$)$

Non$-$functional database requirements focus on the constraints and properties of the database system. They are grouped by categories $($for more details refer to your class notes and slides$)$

Students must provide at least $5$ non$-$functional requirements per category for the categories of Performance, Security, Scalability, Capability, Environmental, Coding Standards, Media Storage and Privacy. Feel free to add more categories to this list.

The following are some examples of non$-$functional database requirements:

$1.$ Performance

$1\mathrm{.}1$ The database system shall support concurrent transactions.

$2.$ Storage

$2\mathrm{.}1$ The database system shall assign $10$ MB of memory per table.

$2\mathrm{.}2$ The database system should support persistent storage

$3.$ Security

$3\mathrm{.}1$ Only encrypted passwords shall be supported by the database system

$3\mathrm{.}2$ All the values inserted into the database shall be consistent with the attribute's datatype and domain.

$3\mathrm{.}2$ The database shall be automatically backed up everyday at $11$:$59$ pm$.$