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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

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

Post 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply