My table book PK ID INT pfK langID INT title VARCHAR description MEDIUMTEXT releaseYear YEAR chaptersPrice DOUBLE thumbnail BLOB Where pfk – Primary-Foreign Key; {ID, langID} – PK; chaptersPrice – price of each chapter of book. Example: BookName1: chaptersPrice=2 BookName2: chaptersPrice=3 I think in this table some attributes are functionally dependent on the part of primary key (ID): {ID} ->
Tag: database-normalization
Have I normalized this database to a 3NF level the right way? [closed]
I had a lecture at college recently about normalizing databases, but since we are online I can’t really ask a lot of questions, so here I am. Can someone tell me if I’m doing the conversion right, if …
How to structure limited voting system design
I have 3 types of tables. Categories, Candidates, Voters. To be describing the problem as short as possible, Candidates can belong to only 1 category. Voters can vote for each category and only one …
What’s best practice for normalisation of DB where a domain table has an “Other” option for free text?
I’m currently in the process of normalising a database for my company and one pattern I’m seeing a lot in this database is using a domain lookup table for a value but also allowing “Other” and storing the results in a separate column. My question is just whether there is perhaps a cleaner way of representing this? For context I’m
How do you normalize a table with a multi-valued field?
I want to normalize a staging table into two tables. One of the fields of input data contains multiple values delimited by a semicolon. DATETIME | FILENAME | MULTIVALUEDFIELD 7-22-18 | somefile.txt |…
How to Set Customer Table with Multiple Phone Numbers? – Relational Database Design
A customer can have multiple phone numbers e.g. Cell, Work, etc. phoneID in Customer table is unique and points to PhoneID in Phone table. If customer record is deleted, phoneID in Phone table should also be deleted. Do you have any concerns on my design? Is this designed properly? My problem is phoneID in Customer table is a child and
Database design for monitoring status of applications’ functionalities
I’m creating the database for monitoring status of applications’ functionalities. The logic is following: Each application has its own, specific list of functionalities that I’m monitoring. Each …