normalization
Couple of normalization questions
My questions are: 1) If I have the relation R(A,B,C), being AB the primary key, and F = {}, may I assume C depends on AB? I\'d say no, but I\'m asking just to make sure.[详细]
2023-03-21 10:26 分类:问答Must apply database normalization when have a lot more insertions than queries?
I did a webcrawler and it inserts various pages and links in the database. At the moment, the domain of the URL crawled is a attribute in the page and i开发者_开发百科n the links table.[详细]
2023-03-20 16:17 分类:问答How to Map Database Lookup Tables Automatically on Insert (Oracle)
I have existing tables that are pretty much denormalized. There are no lookup tables for things list status, type, country, etc... This original design was done just to simplify the application\'s acc[详细]
2023-03-20 10:41 分类:问答What is the best way to set this data in the database?
I have a table of cites and zip codes. As it happens one city can have multiple zip codes so how should i set the db that i may be able to pull the correct zips when i enter a city name or get the cor[详细]
2023-03-19 06:06 分类:问答Normalized CSS, option in JSFiddle, how to add it to document
We have had an applet built for us in JSFiddle. It only works though when o开发者_JS百科ne ticks the box that says normalized CSS. How do we activate that on our website. I have never heard of it.[详细]
2023-03-18 02:11 分类:问答What is the level of database normalization that is "practically" enough?
I am designing a database and I reached (as per my little knowledge) the Third Normal Form (3NF) Some of开发者_如何学JAVA my colleagues told me about a Sixth Normal Form!! I was wondering how to know[详细]
2023-03-18 02:05 分类:问答Change special characters in array Delphi
Some string that I am getting is UTF-8 encoded, and contains some special characters like Å¡, Ä‘, Ä etc. I am using StringReplace() to convert it to some normal text, but I can only convert one[详细]
2023-03-17 13:56 分类:问答Filter wrong database records in a DataGridView control (Visual Studio 2005)(Visual Basic) (Normalization)
I have this database and I need to load it with a visual basic form in Visual Studio 2005. The database has 6 tables and they contain wrong data that I must filter when loading the database in the fo[详细]
2023-03-17 13:28 分类:问答Primary and foreign keys
Simple question, can\'t seem t开发者_如何学编程o find an answer on Google. I\'m normalizing a database and I\'m converting one of the tables to 2nd Normal Form. Question is: can the primary key of a t[详细]
2023-03-17 04:41 分类:问答Junction Table & Normalization Question
I am having a hard time trying to figure out if the following design pattern is acceptable. I have the following requirements (and some other more) for a relational model:[详细]
2023-03-17 02:48 分类:问答