Guys, can you assist with a database I am creating please. A bit of background... I need to create a database that records customer complaints relating to telephone call recording failures. When a call is picked up, it records directly to a channel. However, some of the calls are routed via a preprogrammed ID which then maps to an extension - how would I relate these tables?
Best example I can give is…
Mobile/cell #346573 - calls recorded on channel 1
Landline #7653453 - calls recorded on channel 2
SkypeID JohnT linked to landline extension #875343 - calls recorded on channel 3
I assume relationships will be…
Skype > Landline > Channel
Landline > Channel
Mobile/Cell > Channel
Does the above make sense? If yes, are my tables below correct?
tblIssue: IssueID, IssueType, IssueDetails, CustomerID, UserImpactedName, DateofIssue, TimeofIssue, LandlineID, Mobile/CellID, SkypeID
tblFollowup: FollowupID, FollowupType, FollowUpDetails
tblCustomer: CustomerID, CustomerName, CustomerInfo
tblRecordChannel: ChannelID, ChannelNumber
tblLandline: LandlineID, LandlineNumber, ChannelID
tblMobile/Cell: Mobile/CellID, Mobile/CellNumber, ChannelID
tblSkype: SkypeID, SkypeName, LandlineID
tblTeam: TeamMemberID, MemberName, EmailAddress, TelephoneNumber, SiteID
tblSite: SiteID, SiteName
Best example I can give is…
Mobile/cell #346573 - calls recorded on channel 1
Landline #7653453 - calls recorded on channel 2
SkypeID JohnT linked to landline extension #875343 - calls recorded on channel 3
I assume relationships will be…
Skype > Landline > Channel
Landline > Channel
Mobile/Cell > Channel
Does the above make sense? If yes, are my tables below correct?
tblIssue: IssueID, IssueType, IssueDetails, CustomerID, UserImpactedName, DateofIssue, TimeofIssue, LandlineID, Mobile/CellID, SkypeID
tblFollowup: FollowupID, FollowupType, FollowUpDetails
tblCustomer: CustomerID, CustomerName, CustomerInfo
tblRecordChannel: ChannelID, ChannelNumber
tblLandline: LandlineID, LandlineNumber, ChannelID
tblMobile/Cell: Mobile/CellID, Mobile/CellNumber, ChannelID
tblSkype: SkypeID, SkypeName, LandlineID
tblTeam: TeamMemberID, MemberName, EmailAddress, TelephoneNumber, SiteID
tblSite: SiteID, SiteName
Last edited: