Assignment 4 Repeating Groups for MIS208 Data Analysis

MIS208 Data Analysis

Assignment 4  Repeating Groups

Set: 28 March 2014                                                    Due:  4 April 2014

Assignments 1 and 2 from Page 51 of the Howe text.

1.       The following table contains two repeating groups.

Dept (deptNo, deptName, Employee (employeeNo, employeeName),

Machine (machineType, quantity))

The table contains details of the employees and machines which belong to each

department; it is not intended to show any other connection between employees and

machines, such as which employees operate which machines. The quantity attribute

refers to the number of machines of a given machineType within a given department

(e.g. 6 lathes, 4 drills). Write down a table occurrence for Dept. Invent your own data.

Discuss whether this table structure is a satisfactory way of representing the data.

Answer :

I think that, DeptNo is representing data of Departrment table's,  EmployeeNo is representing data of Employee table's and MachineNo is representing data of Machine table's. 

Regular table should be as follows.

2. Discuss whether there are any significant differences between the table type Dept

in assignment 1, and the table type:

Dept (deptNo, deptName, Employee (employeeNo, employeeName,

Machine (machineType, quantity)))

Assignment 1 is as follows.

Dept (deptNo, deptName, Employee (employeeNo, employeeName),

Machine (machineType, quantity))

Dept                                     

deptNo	deptName	employeeNo	MachineType
D001	Accounting	E223	Computer
D002	Information Technology	E211	Smart Phone

Machine                                                               Employee

machineType	quantity		employeeNo	employeeName
Computer	10		E223	Freddy KRUEGER
Smart Phone	50		E221	Jane BROWN

 But Assignment 2 is as follows.

Dept (deptNo, deptName, Employee (employeeNo, employeeName,

Machine (machineType, quantity)))

Dept

deptNo	deptName	employeeNo
D001	Accounting	E223
D002	Information Technology	E211

Employee                                                                                           Machine

employeeNo	employeeName	MachineType		machineType	quantity
E223	Freddy KRUEGER	Computer		Computer	10
E221	Jane BROWN	Computer		Smart Phone	50