Assignment 7: Skeleton Entity-Relationship Models

Assignment 7: Skeleton Entity-Relationship Models

Set: 25 April 2014                                       Due: 2 May 2014

Answer Question 6 from page 139.

6. A shoe manufacturer identifies a style by a styleNo and a shoe by {styleNo, shoeSize}.

How would you represent the relationship between entity types Style and Shoe in terms of skeleton table types?

Answer : It is represented by the styleNo.

Assignment 6: Determinacy Diagrams for MIS208 Data Analysis

Assignment 6: Determinacy Diagrams 
Set: 25 April 2014 Due: 2 May 2014
 p.62-63
Q.1. For each of the following determinancy diagrams, identify each determinant and the attribute(s) it directly determines. Omit any transitive dependencies. Questions a, c, e, h, j, o, q

ANSWERS 

orderNo and itemNo are determinants for above figure(a) and orderDate and quantity are attributes determine.

orderNo and customerNo are determinants for above figure(c) and customerNo and adress are attributes determine.

branchNo and customerSerialNo are determinants for above figure(e) and creditLimit and adress are attributes determine.

A is determinant for above figure(h) B and C are attributes determine.

J, K and L are determinants for above figure(j) L,M and N are attributes determine.

H, J and K are determinants and attributes determine for above figure(o).

P,Q and R are determinants for above figure(q) P and R are attributes determine.

Youtube Giriş Yasaklandıysa Adım Adım Youtubeye Giriş

1. ultrasurf proksi programını bilgisayarınıza Buradan indirin.

2. İndirdiğiniz programı çalıştırdıktan hemen sonra ekranın sağ alt köşesinde kilit işareti gördüğünüzde artık istediğiniz engelli siteye rahatça girebilirsiniz.

3. Programı deaktif etmek için kapatmanız yeterli olacaktır. kapatırken aşağıdaki gibi bir ekran gelecek. 

Close IE and exit : açık Internet Explorer sayfanızı kapatır ve arkasından programı kapatır. 

Keep IE and Exit : açık İnternet Explorer sayfanızı kapatmadan programı kapatır.

İyi Surfler...

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

 

Assignment 5 Decomposition of many:many relationships for MIS208 Data Analysis

MIS208 Data Analysis

Assignment 5   Decomposition of many:many relationships

Set: 28 March 2014                                                    Due:  4 April 2014

p.111, Q1, Q2

Questions

1. The following table shows which suppliers supply which parts.

supplierNo	partNo
S1	P15
S1	P29
S1	P32
S2	P12
S2	P15
S3	P12
S3	P32

(a) Draw an entity-relationship type diagram showing a single relationship between

entity types Supplier and Part.

(b) Decompose your diagram into an equivalent diagram containing only 1:many

relationship types.

(c) Draw an entity-relationship occurrence diagram showing the above data as two

1:many relationships.

2. A college runs many evening classes (e.g. metalwork, pottery, art, local history).

Each class may be taught by several teachers, and a teacher may teach several classes.

A particular class always uses the same room (e.g. pottery always uses room R12).

Because classes may meet at different times or on different evenings it is possible for

different classes to share a room (e.g. pottery and art both use room R12).

(a) Draw an entity-relationship type diagram showing the entity types Teacher,

Class, Room and the relationship types TeacherClass and RoomClass.

(b) Re-draw your type diagram, decomposing any many:many relationship into

1:many relationships. 

Assignment 3 Duplication and Redundancy for MIS208 Data Analysis

MIS208 Data Analysis

Assignment 3 Duplicated and Redundant Data

Set: 21 March 2014                 Due: 28 March 2014

Duplicated and Redundant Data

TeacherCourse

	teacherNo	teacherName	courseTaught	courseName
	P111	Susan	ENGL101	English 1
	P221	Adam	ENGL101	English 1
	P223	Ben	ENGL101	English 1
	P227	Milly	ENGL101	English 1
	P300	Tom	ENGL101	English 1
	P111	Susan	ENGL200	Translation
	P221	Adam	ENGL200	Translation
	E114	Tom	MATH107	Basic Maths I
	E222	Kevin	MATH107	Basic Maths I
	E114	Tom	MATH108	Basic Maths II

Figure 1

Q: Which attribute values are duplicated in the table Figure 1 above?

A: Same colour cells are repeated in the table Figure 1.

teacherNo	teacherName	courseTaught	courseName
P111	Susan	ENGL101	English 1
P221	Adam	ENGL101	English 1
P223	Ben	ENGL101	English 1
P227	Milly	ENGL101	English 1
P300	Tom	ENGL101	English 1
P111	Susan	ENGL200	Translation
P221	Adam	ENGL200	Translation
E114	Tom	MATH107	Basic Maths I
E222	Kevin	MATH107	Basic Maths I
E114	Tom	MATH108	Basic Maths II

Q: Which attribute values are redundant in the table in Figure 1?

A: I think, both teacherName and courseName values are unnecessary, because you can find teacherName with teacherNo and you can find courseName with courseNo. 

Q: Draw a diagram to show how redundancy can be eliminated by splitting the table into two or more pieces.

A: ideal database can be like the following.

informationTeachers

teacherNo	teacherName	teacherSurname
P111	Susan	Brown
P221	Adam	Smith
P223	Ben	Demon
P227	Milly	Obama
P300	Tom	Ronaldo
E114	Tom	Gates
E222	Kevin	Jelly
E114	Tom	Greedy

informationCourses

courseTaught	courseName
ENGL101	English1
ENGL200	Translation
MATH107	Basic Maths I
MATH108	Basic Maths II

TeacherCourse

teacherNo	courseTaught
P111	ENGL101
P221	ENGL101
P223	ENGL101
P227	ENGL101
P300	ENGL101
P111	ENGL200