Question: I want ER - Digram ? Entities: User ( userID , username, password, email ) Admin ( adminID , username , password ) Payment (

I want ER-Digram ?
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
(one-to-many)
User Participates in Event
(many-to-many)
Admin Manages Apartment Listing
(one-to-many)
Apartment Listing Includes Apartment
(one-to-one)
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!