Search code examples
mysqldatabase-normalization

MySQL Normalized Database Design

I have the following table structure. The requirements are that it needs to be normalized to 3rd normal.

I am not sure about the subscriberAddress is that needs to be in a new table or it can just go under subscribers? What do you think? Is the rest fine?

users(userName, userFirstName, userLastName, password, image)
userRole(userRole)
subscribers(email, firstName, lastName)
subscriberAddress(geoLocationLatitude, geoLocationLongtitude)
products(productName,productPrice, productQuantity, productImage)
Solution

  • I cannot see any reference between tables. How subscribers and subscriberAddress are related? If a subscriber has only one address, you can put it into subscribers. If a subscriber can present many addresses, put them into another table with a reference to that subscriber .