Higher DDD - Analysis

I can detail functional requirements of a database solution given the end-user requirements  

I can identify query types and aggregate functions required to meet the functional requirements of a database solution  

Achievement

We are learning how the end-user and functional requirements of a database solution are determined at the analysis stage.  

Aims

Open Ended

The National Swimming Association (NSA) collects data of multiple events, races, teams, and swimmers. The NSA needs a database to store and manage this data and has approached a database developer to help. During a meeting with the database developer, the end users provide the following feedback:

“I would like to see the results of a race displayed by position, from first to last.”

“I need to see the time difference between the winning time and each swimmer’s time for a race.”

“I need to find the team reference number for a swimmer.”

“I need to be able to see all the swimmers who finished first, second and third in each race.”

“I need to know the total number of days each city has hosted an event.”

“I need to be able to update the details of events, races and swimmers.”

The database exists with the appropriate entities and all appropriate attributes. Using the user requirements above, create two functional requirements (2 marks)

Open Ended

Gnome Sweet Gnome is a company that sells garden gnomes. The owners want to create a relational database to store details of their customers, orders and garden gnomes. They have appointed a database developer to do this. The developer asked employees about the features they would like in the completed database. The following is a summary of their responses. (2 marks)