[normalize] Forum Topics

Hello all, I need to make a simple database, and then some windows application (possibly C#) connecting to it... but first... First I need to design and model a good and functional database, right? So I am stuck in it now :) and please help if you can. I dont …

Hi, I am just trying to normalize these data here: An initial call is logged by a first line support analyst who assesses the severity of the problem and places the call in a pool. The call is picked up by a problem analyst who in turn allocates it to …

I have an existing database design which I would like to normalize. Essentially, the table causing me problems is one with about 150 columns. The table holds live data for a natural gas well. So, there are columns for the various temperatures, pressures, etc. The data types of these columns …

Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have: [B][U]Customer Table[/U][/B] CustId(pk) Cust Name Cust Address Cust Postcode Cust Email [B][U]Order Table [/U][/B] OrderID (pk) Order Date_Time CustID(fk) [B][U]OrderDetails[/U][/B] DetailsID(pk) Quantity OrderNo(fk) DeliveryID(fk) [B][U]Product[/U][/B] ProductID(pk) ProductType ProductDescription DetailsID(fk) PartID(fk) …

I can find a lot of information about the concepts of normalization, but I don't really see documentation for how to actually bring a table, for example, from first normal form to second normal form. I'm using SQLite through Python to automate some data processing, and I have three input …

Hello Dani Webbers, So I've been given this old-as-hell database, it was designed in 1993 under pick, and it isn't at all normalized, in a good effort I've migrated all the data into MSSQL 2008 server and I have some several to several relations between tables, on of these relations …

Hello All, I seem to be having an issue with a many to many relationship database or how I like to call it a many to many to many...... j/k. I am wondering if I can get some input for this very long problem. I work for a direct mail …

I run a small database for a very small business. I am normalizing our database which keeps track of our orders for repairs. I have one of the tables in 2NF but I am not sure how to normalize it further. Here is an example of how it looks: [code] …