Designing SQL Database for Museum Membership System .NET Facing Issues with Visitor Data

[denis_the_thief]

How about…

MUSEUMS

MusemID

MuseumName

MuseumAddress

VISITORS

VisitorID

First Name

Last Name

VISITLOG

VisitLogID

MuseumID

VisitorID

EntryDate

ExitDate

Cost

MEMBERSHIPS

MembershipID

MuseumID

VisitorID

EffectiveDate

TerminationDate

Cost