DUMMYAssignment 2 INFORMATION SHEET School: IT and Business Name of Unit: ICT105 Data...

Question

DUMMYAssignment 2 INFORMATION SHEET    School: IT and Business    Name of Unit:    ICT105 Data Modelling and Database Systems  Unit Code:   ICT105  Assessment Type    Assignment 2  Due Date   (Including  Time):  2 December 2020   23:59hrs No. of Pages in Exam:  (including cover page)  2  NOT INCLUDING INFORMATION  SHEET  Name of Academic: Yancong (Ray) XIE (RX)    Assessor: Dr Aaron Bere Moderator: Yancong (Ray) XIE (RX)  STATIONERY and AIDS    Number of answer  books per student: Textbooks and notes:  (please mark x) Yes x No   Textbooks only:  (please mark x) Yes  No           Materials allowed:  (graph paper, mathematical and  statistical tables, graphics  calculator) None  Special requirements:  (special instructions, list of  formulae, show video, listen to  audio tapes, printer required,  access to particular software,  access to other IT requirements  etc.) This is an open book assignment. Students may refer to their textbooks.  Other:        None       1   Assignment 2    UNIT CODE: ICT105  UNIT NAME: Data Modelling & Database Systems UNIT LECTURER’S NAME:  Yancong (Ray) XIE (RX) UNIT COORDINATOR’S NAME:  Dr Aaron Bere Due Date:      2 December  2020 at 23:59hrs MARKS ALLOCATION:     20 Marks RESOURCES:   None      INSTRUCTIONS:    1. Each question must be clearly labelled  2. Due Date and time : 2 December 2020 at 23:59hrs    3. The assessment must be typed Arial 12 font, 1.5 spaced  4. Marks will be deducted for late submission; 10% of the total marks will be deducted for  each day after due date  5. Use this Turnitin link to submit “ Assignment 2- ICT 105 Submission  Link” by the due  date  6. All assignment submissions must be accompanied by a completed SISTC student  assignment Cover Page  7. You can resubmit your assignment several time to check your plagiarism percentage   8.  It is recommended to plan time appropriately and start the assessment early; this will give  you time to research and do well       SUBMISSION DETAILS:    1. Please name your file as follows: studentIDFirstnameLastname before uploading it into  Turnitin (e.g. 2222222SandeepSandoo)    2   Question 1. (10 Marks)   The EmpProjData table below is in first normal form. Study the table and answer the following questions.  Table: EmpProjData Apply the principles of normalization and convert the EmpProjData to third normal form. Your tables in  third normal form should include all the appropriate data from the EmpProjData.        Question 2. (10 Marks)   (i) Identify and explain three major types of database concurrency problems that may affect the  consistency of an enterprise database management systems.     (6) (ii) Paul is a database administrator for Topics. Topics is a modern clothing online store. Paul is  responsible for maintaining data concurrency for Topics database. Explain to sales staff using non- jargon terminology how Topics shopping carts support data concurrency and consistency.   (4)     [End of Paper]

Preety · Accepted Answer

Solutions:
Solution 1:
Table: EmpProjData
Conversion of 1NF to Second Normal Form
1. To convert 1NF to 2NF first step is to remove all the partial dependencies. It means we have to start with 1NF table and find out the composite key. So in new table, each component will become key value.
2. The second one step is to allocate dependent attributes and this is done through 1NF table given above. Here we have to find out those type of attributes that are dependent on key attributes.
3. Finally, the third step is to naming the tables so that it can be verify its function.
        
2NF Conversion Output:	
For conversion to 2NF:
· First rule for conversion to 2NF is there is not any such attribute that is dependent on only portion of primary key. 
· Second point should be keep in mind that is 2NF table will be only when there will not be any partial dependencies.
· And the last important point is that every key element forms an original table. 
· 
 Conversion from 2NF to 3NF
1. To convert 2Nf to 3NF is first remove all transitive dependencies. Find out all the primary keys also. 
2. Reallocate the equivalent dependent attributes. To find out attributes which are dependent on each determinant that are recognised in Step 1. 
3. Finally assign name to the new tables which shows its functionality.
3NF Table Output (no transitive dependencies):
Solution Q2. (i). In case of multiple transactions execution, these are executed  simultaneously and in an unrestrained  environment.

Assignment 2 INFORMATION SHEET School: IT and Business Name of Unit: ICT105 Data Modelling and Database Systems Unit Code: ICT105 Assessment Type Assignment 2 Due Date (Including Time): 2 December...

Answer To: Assignment 2 INFORMATION SHEET School: IT and Business Name of Unit: ICT105 Data Modelling and...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment