Business Rules Implicitly Indicated
11 Pages1347 Words269 Views
Added on 2019-09-16
Business Rules Implicitly Indicated
Added on 2019-09-16
ShareRelated Documents
Chapter - 225(a). Business Rules Explicitly stated1.A university have more than one college. 2.Each college has 4 terms.3.Each term can have one or more than one course.4.Instructor can teaches one or more than one course. Business Rules Implicitly indicated1.Course# and course name should be unique.2.Instructor teaches in 0 to 4 terms.3.In a term the combination of instructor and course should be unique.25(b). To complete this data model there should be module of student, which contain studentID, student name, student address and college that isbeing chosen by him. 26. There are two users that are client and agent and relation between them is policy. A client buys the policy from the agent and can buy many policy with different agent and relation between client and policy is one to many. A agent can sell the policy to a client and can sell many policy and relation between aget and policy is zero to many that an agent is related to any policy is not mandatory
.
Chapter - 36. The business rule that is missing is the the customer module. There should be entity of customer who can book a reservation. A customer can book a flight reservation but the combination of reservation and flight for a particular customer should be unique.7. (a) Weak Entity - ServiceStrong Entity - AIRCRAFT, TECHNICIAN, TRUCK, FLIGHT, RESERVATIONUnique identifier of entityAIRCRAFT - TailTECHNICIAN - SSTRUCK - License PlateFLIGHT - FlightIDRESERVATION - Reserv ID(b) Partial key - Tail in entity AIRCRAFT.(c) Optional attributes Hours in Entity SERVICE Tenure in Entity TECHNICIANMulti- valued attributeSpeciality in entity TECHNICIAN(d) Derived attributes - SERVICE is derived from AIRCRAFT RESERVATION is derived from flight(e) Recursive relationship is in FLIGHT entityBinary relationship is between FLIGHT and RESERVATION, And SERVICE and TECHNICIAN
(f) Partial participations among entities are AIRCRAFT and SERVICE FLIGHT and RESERVATIONTotal participation among entities are AIRCRAFT and FLIGHT SERVICE and TECHNICIANTECHNICIAN and TRUCK(g) 1:1 cardinality ratio means there should be unique foreign key in both entity1:n cardinality ratio means in one entity there should be unique foreign key and in other there can be repetition of foreign key.N:m cardinality ratio means there can be many number of foreign keyin both entity.(h) Diamond has a single line, the relationship only includes strong entity sets.Diamond has double lines, the relationship includes a weak entity set.(j) It is the optional clause.
End of preview
Want to access all the pages? Upload your documents or become a member.