database-normalization
Moving to second form
Guys, how would you create second form of th开发者_JS百科is table (primary key is: {isbn,copy}):[详细]
2023-02-18 09:30 分类:问答Recording how many times a user failed login
How would you design you database if say you had a table called user: User_Table : id, username, password, password_salt, email, email_salt[详细]
2023-02-10 16:03 分类:问答Can anyone explain me 1NF, 2NF, 3NF, BCNF rules with a proper example?
开发者_JS百科This is a common interview question. I faced one interview where the interviewer gave me one table and asked me tell him which normal form the table is in? If it\'s in ##NF, then normaliz[详细]
2023-02-04 01:17 分类:问答any practices ,samples for ERD?
Q: I want any web sites or books just for training on ERD and normalization. I want a lot of sample, practices, and case studies with recommended answers, 开发者_开发问答to strengthen my skill in dat[详细]
2023-02-02 16:38 分类:问答-
When to Denormalize a Database Design
I know that normalization has been extensively discussed on Stack Overflow. I\'ve read many of the previous discussions. I\'ve got some additional questions though.[详细]
2023-01-28 11:11 分类:问答 Lossless Join Decomposition
I am studying for a test, and this is on the study guide sheet.This is not homework, and will not be graded.[详细]
2023-01-28 10:18 分类:问答Database "supertable" vs more tables vs generic table
I\'m trying to decide on a database design.More specifically, this is a sub-part of a larger design.Basically, there are \"Locations\" - each location can have any number of sensors associated with it[详细]
2023-01-27 16:43 分类:问答Is this database schema practical?
As sort of a follow up to this previous question: Normalizing a variety of properties with similar data types[详细]
2023-01-27 12:23 分类:问答Problems while designing a database to manage all kind of products like Amazon
first of all sorry for my bad english hehehe I need some help, I want to design a database for a website, like a mini Amazon. This database will manage every kind of products (TV, cars, computers, boo[详细]
2023-01-27 01:10 分类:问答Is this table in 2NF?
In trying to learn about database normalization, I am confused by the following table: NameDateOrganisms[详细]
2023-01-26 12:39 分类:问答