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?