I'm attempting to figure out how to model a normalized database where a player may have multiple classes. What is the relationship between the player and the class objects? Each player will be able to have multiple classes and each class will then grant a player multiple skills as well. I'm familiar with normalized database and workin...
Here is the situation: I have a "user" , which have many attributes. For example, "name", "email", "password", "phone". There are some attributes that are open for public, for example, "name", "email". These information is open for evenbody who visit the site. But some, only for trust body in the system, for example "phone". These i...
I'm in the process of learning SAP BW at work. The SAP class material states that in InfoCubes, dimensions are denormalized. I understand the benefit of normalized tables, but don't understand why dimensions would be denormalized. ...
I am building a system that stores articles and tags that categorize the article. Standard stuff, similar to how this website does it. Now my question is whether I should store the tags on a separate table that just contains tags and article ids or store the tags on an extra column in the articles table. My first instinct would be to nor...
I am in middle of upgrading from a poorly designed legacy database to a new database. In the old database there is tableA with fields Id and Commodities. Id is the primary key and contains an int and Commodities contains a comma delimited list. TableA: id | commodities 1135 | fish,eggs,meat 1127 | flour,oil In the new datab...
How can one best represent this type of data in a relational database? There a variable number of a particular Machine each uniquely serialized by the manufacturer. Each Machine will be set up by the user to do variable number of the tasks that this type of machine is capable of. All the machines will select from the same task list whi...
I want to write a normalization function that will take a signed integer and normalize it to a double between -1 to +1. Is there a special name for this type of function, or is Normalize() what people normally call it? Also, is there a native iPhone function that does this? ...
I have a table named "Documents" containing a column as below: DocumentID I have data in the format - @DocID = 1,2,3,4 How do I insert these documentID's in separate rows using a single query? ...
I'm new to database design and I have been reading quite a bit about normalization. If I had three tables: Accommodation, Train Stations and Airports. Would I have address columns in each table or an address table that is referenced by the other tables? Is there such a thing as over-normalization? Thanks ...
Hi, I have a table in Oracle DB,say, Student table. StudentID is the primary key in the table.I have another column interested subjects,say columns name is interested_SUB. A student can have more than one interested subject. In this case, I have the following 2 options: 1) Having the StudentID and Interested_SUB columns as the composite...
I'm designing a game where a character has many items and those items can be of many types. There is a character table, and twelve different tables of possible items broken down by type (such as weapons, armors, and various other item types). I want to make a table to hold instances of these item types (basically a characters' items ta...
ok im new to database design, please give me advices about this. 1 http://stackoverflow.com/questions/1823685/database-when-should-i-use-a-composite-index im not sure what does index does, but i do know we should put it when it will be heavly loaded like for WHERE verified = 1 and in search like company.name = something. a...
I have seen in my past experience that most of the people don't use physical relationships in tables and they try to remember them and apply them through coding only. Here 'Physical Relationships' refer to Primary Key, Foreign Key, Check constraints, etc. While designing a database, people try to normalize the database on paper and kee...
Suppose you had the mySQL table describing if you can mix two substances Product A B C --------------------- A y n y B n y y C y y y The first step would be to transform it like P1 P2 ? ----------- A A y A B n A C y B A y B B y B C n C A y...
A database exists with two tables Data_t : DataID Primary Key that is Identity 1,1. Also has another field 'LEFT' TINYINT Data_Link_t : DataID PK and FK where DataID MUST exist in Data_t. Also has another field 'RIGHT' SMALLINT Coming from a microsoft access environment into C# and sql server I'm looking for a good method of import...
Hi, I would like to ask if there's any Java package or library that have the standard URL normalization? 5 Components of URL Representation http://www[dot]example[dot]com:8040/folder/exist?name=sky#head scheme: http authority: www.example.com:8040 path: /folder/exist query: ?name=sky fragment: #head The 3 types of standard URL n...
Hey Everyone, Let me explain my problem, and hopefully someone can offer some good advice. I am currently working on a web-app that stores information and meta-data for a large amount of applications. For each application there could be anywhere from 10 to 100's of comments that are tied to the application and an application version i...
I have a table for storing the postman coverage area. It has two fields postmanid covering_pincode What i am going to implement is, when a user enters a pincode in the textbox, the list of the postman covering that pincodes are displayed. My doubt is, how can i enter the values in the table 1. Multiple pincodes stored in single row l...
Which table structure is considered better normalized ? for example Note: idType tells on which thing the comment has taken place on, and the subjectid is the id of the item the comment has taken place on. useing idType the textually named identifier for the subjectid. commentid ---- subjectid ----- idType --------------------------...
Hi All, Can someone verify the integrity of this chunk of code? I want to decorate the controllers with it so that it will normalize the url to either https and/or www. This is my second rewrite of the code because the first one tossed itself into an infinite redirect, but somehow I still think it's not quite there... public class Norm...