the picture refers to UML class Digram...in other side i want to build a ERD and take
Question:
the picture refers to UML class Digram...in other side i want to build a ERD and take the picture and consider it to build an ERD
im not sure about this data so check it please and build it
Entities:
User userID ?username, password, email
Admin adminID ?username, password
Payment paymentID ?amount, paymentMethod, date
Event eventID ?eventName, eventDate, location
Apartment Listing listingID ?description, availability, apartmentID
Apartment apartmentID ?location, price, isAvailable
Relationships:
User Makes Payment onetomany
User Participates in Event manytomany
Admin Manages Apartment Listing onetomany
Apartment Listing Includes Apartment onetoone
Constraints:
Primary keys: userID, adminID, paymentID, eventID, listingID, apartmentID
Foreign keys: paymentID references User, listingID references Apartment
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill