It is not possible to define every single aspect of all systems in the assignment brief, nor is it beneficial to attempt this. Part of the process of completing the assignment tasks is making (and declaring) assumptions that define any grey areas or unspecified details in the scenarios. It is up to you to make these assumptions, but feel free to discuss them with your tutor if you are uncertain of their validity.There is no "universally correct" set of assumptions for the tasks. Think about the problem, and make assumptions as you encounter the need for them. All assumptions should affect or be enforced/implemented by your database design, and they should not contradict something that is specified in the assignment brief. Some assumptions may make a task easier, but avoid always making assumptions that make the task easier, as this is a questionable practise and is likely result in an assignment that does not demonstrate a deep understanding. Always remember to clearly state all assumptions you make.The most common assumptions are likely to regard irrelevant or derived data (Tasks 1 and 2) or the cardinality of relationships between entities (Tasks 3 and 4).If you are in CSI5135, the following additional requirements apply. If you are in CSG1207, you do not need to do this (but you are welcome and encouraged to do so if you want).Once you have normalised the table to 3NF and named your data sets, convert your results into a physical E-R diagram. Remember to indicate all cardinality, attributes, primary and foreign keys. Remember to state any assumptions that are relevant to the E-R diagram.