relational-model
Is there any DBMS that does not rely upon SQL?
This topic is somewhat related to this question. There my answer was motivated by the assumption that SQL is necessary to access data in every database I know.[详细]
2023-03-19 00:45 分类:问答Relational database theory and keys
I\'m designing a schema to hold player data within a browser based game. I have three relations. Two of them have at least two candidate keys, however the third has only three attributes: {playerId,[详细]
2023-03-15 08:50 分类:问答How to generate Relational Model from UML Class Model?
Does anyone know an application (Enterprise Architect, ...) that allows mapping from UML Class Model开发者_Python百科 to Database Relational Model automatically? How?[详细]
2023-02-19 00:47 分类:问答Conceptual to relational mappings
this is a homework question. I already have my own answer, but I am not sure if its correct, need your guys advise. Here is the conceptual diagram:[详细]
2023-02-09 13:01 分类:问答Unique key with NULLs
This question requires some hypothetical background. Let\'s consider an employee table that has columns name, date_of_birth, title, salary, using MySQL as the RDBMS. Since if any given person has the[详细]
2023-01-23 09:11 分类:问答Relational modelling question
We have three entities called Product, ProductType, and ProductCategory. Let\'s pretend we have three kinds of ProductType: Book, Music, and Video.[详细]
2023-01-22 21:37 分类:问答Does every table really need an auto-incrementing artificial primary key? [closed]
As it current开发者_运维技巧ly 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 so[详细]
2023-01-20 08:35 分类:问答Database mnemonics
I\'m looking for mnemonics to help me with databases, the relational model and transaction theory. For example I learned \"ACID\" to help me remember the properties of a transaction: atomicity, consis[详细]
2022-12-20 06:36 分类:问答