I am currently interning and one of my tasks is to design a relational database model for a wedding firm that plans and handles weddings.
There is a user log in, and the users will be bride, groom, vendors and guests. I am not exactly sure how I should architect the database as it is the first time I am making one.
USER (user_id, username, password, bride_id, vendor_id, guest_id)
BRIDE (bride_id, bride_fname, bride_lname)
VENDOR (vendor_id, vendor_fname_lname)
GUEST (guest_id, guest_fname, guest_lname)
This is a somewhat version of the schema I was designing, but I am unsure how I can have everything on the USER
table instead of repeating fname
, and other redundancies. Also, the reason I have not put everything in the USER
table is because I am not sure how it would work out. Can someone please explain this to me?