A level north west regional mock gce 2022 computer science 3
A level north west regional mock gce 2022 computer science 3
NOTE: From observation, we notice that the table above is not in INF, because the Name field is not atomic and there are
The repeating abovegroups table can of attributes be decomposed ^date assessed to two tables , Activity in INF code and , Description represented,in fee standard , Assessor notation Nameas , and shown Email below ). :
Member (MemberTD, Firstname, Lastname, phone)
Certificate (Memberld. ActivityCode, AssessmentDate, Description, AssessorName, AssessorEmail)
1. (a) Write SQL code to create the “COUNCIL” Database (I mark)
(b) Write SQL code to create the Member and Certificate Tables identifying the primary key of each (3, 3 marks)
(c) Draw an Entity Relationship (ER) diagram that shows the relationship (“Awarded”) between the
Member and Certificate tables.
2. A new member (MemberID=l54551, FirstName=Shu, LastName = Paul, Phone=674589346) has been awarded a
certificate. Write SQL code that will add the member in the Member table above. . ; *.
3. The Member and Certificate tables above are in INF. Evaluate the tables and decompose them to their Second and
Third Normal forms (2NF & 3NF). Include any useful explanations.
4. Using an appropriate DBMS, implement a relational database for the tables obtained in 4 above
5. Implement the relationship graph between Entities in 4 above and Print a copy
