database-design

相关标签：javascript jquery android 多少钱 iPhone

Database design of Railway reservation system

I am designing Railway reservation system. I am having below tables. StationTable(Contails all the stations to which i can provide the railway service.)[详细]

2023-04-11 03:41 分类：问答
Should Foreign Keys be used in a structure where multiple options can be selected by a user? If so, how so?

In MySQL, I was advised to store the multiple choice options for \"Drugs\" as a separate table user_drug where each row is one of the options selected by a particular user.I was also advised to create[详细]

2023-04-11 03:26 分类：问答
SQL Database Design Best Practice (Addresses)

Of course I realize that there\'s no one \"right way\" to design a SQL database, but I wanted to get some opinions on what is better or worse in my particular scenario.[详细]

2023-04-11 00:07 分类：问答
How to create a "dynamic" database structure (EF Code-First)

I\'m trying to implement web application using Entity Framework Code-First. I\'ll explain the problem on such example:[详细]

2023-04-10 23:50 分类：问答
optional foreign keys one of which must be mandatory - how?

I have a table that has two optional foreign keys, each to a different table and one of which HAS to be filled in, but it doesn\'t matter which one.I was thinking about using a trigger to enforce this[详细]

2023-04-10 23:09 分类：问答
Database design - Lookup table

how do you label your \"code\", se开发者_如何学Cquencial number (1,2,3,4...n)? Example My DeviceType lookup table holds mobile devices, and has the following attributes[详细]

2023-04-10 21:30 分类：问答
Which normal form does this table violate?

Consider this table: +-------+-------+-------+-------+ name|hobby1 |hobby2 |hobby3 | +-------+-------+-------+-------+[详细]

2023-04-10 20:18 分类：问答
How to present a data model without using ER notation

I have an interesting problem on hand. I have a large model in Erwin - My logical data model is almost at the level of physical model. Hence, to present the model to the business analysts and programm[详细]

2023-04-10 20:02 分类：问答
How to model Friendship relationships

I have been trying to figure out how to do this, and even with looking at other examples, I can\'t get it figured out, so maybe I can get some personalized help.[详细]

2023-04-10 19:50 分类：问答
When not to use MySQL or other relational DBs? [closed]

开发者_如何学JAVA As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely[详细]

2023-04-10 19:21 分类：问答