-
as seen on Stack Overflow
- Search for 'Stack Overflow'
UNF:
(Customer-name, Customer-id, Customer-address,
(Unit-price, Order-id, Quantity, Product-id, Delivery-date)
(Supplier-name, Supplier-id, Supplier-Address)
3NF:
CUSTOMER
(Customer-id, Order-id, Customer-name, Customer-address)
ORDER
(Order-id, Customer-id)
ORDER/PRODUCT
(Order-id,…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Given that state information is implicit in the zip code aren't storing both of them some violaiton of third normal form? Can or should you simply combine them into one field?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm storing data on baseball statistics and would like to do so with three tables: players, battingStats, and pitchingStats. For the purpose of the question, each player will have batting stats or pitching stats, but not both.
How would I normalize such a relationship in 3NF?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am building a system, mostly for consolidating learning but will be used in practice.
I will try and verbally explain the part of the E-R diagram I am focusing on:
Each cadet can have many uniformID's
Each Uniform ID is a new entry in table uniform, so cadets (table) may look like:
id | name…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
I've been playing around with Active Record a bit, and I have noticed that A.C./ORM always uses the following database model when creating a one-to-one relationship
Person
id | country_id | name | ...
Country
id | tld | name | ...
No I wondered, isn't this a violiation of the…
>>> More