Question: I want ER - Digram ? Entities: User ( userID , username, password, email ) Admin ( adminID , username , password ) Payment (
I want ERDigram
Entities:
User
userIDusername, password, email
Admin
adminIDusername password
Payment
paymentID amount, paymentMethod, date
Event
eventIDeventName, eventDate, location
Apartment Listing
listingIDdescription, availability, apartmentID
Apartment
apartmentIDlocation, 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
