Problems

1
Problems

• 7/27/02

2
3, p5
Student-Course Stu-ID Course-ID Grade
Student
Course
3
4, p5
Course CourseID InstrID
Teaches
Instructor InstrID
4
5, p5 (Weak Entity)
Weak Entity Has the key of another entity as
part of its key. Cannot exist in life without the
other one.
Course CourseID Name HoursCredit
Section CourseID SectionID Time Days Term
IsOneOf
0
MIS5113
MIS5113-980 CourseID-SectionID MIS5113-981
MIS5113 981
5
P6, 7SalesOffice, Employee, Property, Owner
Property PropertyID (PK) SOID (FK)
Listed by
SalesOffice
Works In
Property-Owner OwnerID (FK) (PK) PropertyID (FK)
(PK)
Employee ID Name SOID (FK) MGR?
Owner OwnerID
Assumes Property ID is unique across all offices.
6
P6, 7SalesOffice, Employee, Property, Owner
SalesOffice MGRID(FK)
Works In
Managed by
Employee ID Name SOID (FK)
7
Narrative

• List a property
• Assign to a sales office
• Record ownership information
• Record property data
• Record listing agent
• Hire an employee
• Record employee data
• Assign to an office
• Indicate manager
• Create sales office
• Assign manager
• Record data

8
P6, 7 Level 0 DFD
Listing Agent
Property Ownership Info
Ownership Data
List a property
Property Data
Office Info
Owner Data
Office Info
Create Sales Office
Hire an Employee
New Office Data
Management
9
P6, 7 Level 0 DFD
Listing Agent
Property Ownership Info
Ownership Data
List a property
Property Data
Office Info
Owner Data
Office Info
Create Sales Office
EmployeeData
Employee Table
New Office Data
ManagerID
Management
10
Narrative

• List a property
• Assign to a sales office
• Record ownership information
• Record property data
• Record listing agent
• Hire an employee
• Record employee data
• Assign to an office
• Indicate manager
• Create sales office
• Record data

11
Metadata

• Flows
• Analysis names of attributes or elements
• Design names design parameters