Page 1 of 1

Entity Attributes CustomersNo(PK), FirstName, LastName, AddressNo, Gender, TypeOfWork, ServiceNo NextOfKinNo(PK), FirstN

Posted: Fri May 20, 2022 11:15 am
by answerhappygod
Entity
Attributes
CustomersNo(PK), FirstName, LastName,
AddressNo, Gender, TypeOfWork, ServiceNo
NextOfKinNo(PK), FirstName, LastName,
TelephoneNumber, AddressNo, CustomerNo
AddressNo(PK), StreetNumber, StreetName,
Suburb, Post-Code, City, State
ServiceNo(PK), ServiceName, ServiceType,
ServicePrice, CustomerNo
StaffNo(PK), FirstName, LastName, Position,
Gender, DOB, SectionNo, TelephoneNumber, OfficeNumber)
CWGSectionNo(PK), InformationNo,
ServiceRepairNo, CustomerSupport, CustomerFeedback, Account,
StaffNo)
InformationNo(PK), SectionName, EmailAddress,
Location, SeveralTelephone, FaxNumbers)
EmailNo(PK), SectionNo, EmailAddress
TelephoneNo(PK), SectionNo)
AppointmentNo(PK), CustomerNo,
ClassNo,InformationNo
(InvoiceNo(PK), CourseNo, RepairServiceNo,
CourseStartDate, CourseEndDate, PaymentDueDate, AmountToBePaid,
CustomerNo,StaffNo
(CourseNo(PK), CourseName)
PaymentNo(PK), InvoiceNo, AmountPaid,
DateOfPaid
NoticeNo(PK), CustomerNo, InvoiceNo,
DateOfIssue
RecieptNo(PK), CustomerNo, AmountPaid,
PaymentNo, InvoiceNo)
JobNo(PK), CustomerNo, RepairNo, RepairName,
DateOfJob, StaffNo
RepairCustomerNo, FirstName, LastName,
TelephoneNo, PostalAddress, TimeOfAppointment,
DateOfAppointment
RepairNo(PK), CustomerNo,
CustomerPropertyAddress, StaffNo
RepairNo(PK), RepairCustomerNo,
TimeOfRepair, DateOfRepair, StaffNo
RepairInvoiceNo(PK), RepairNo, PaymentDueDate,
AmountToBePaid, CustomerNo, StaffNo
RepairPaymentNo(PK), RepairCustomerNo,
RepairInvoiceNo, AmountPaid, DateOfPaid
RepairRecieptNo(PK), RepairCustomerNo,
AmountPaidDate, RepairInvoiceNo
Branchno(PK), BranchAddress, CustomerNo
SeminarCustomerNo(PK), CustomerNo,
SeminarRoomNo, BookNo
BookNo(PK), DateOfBooking, TimeOfBooking
SeminarStaffNo(PK), StaffNo, BookNo
The above is my entities and attributes. Can some
one please help me with ER diagram for the above
table