Questions tagged [schema-design]

Concerned with design of properties and their hierarchy to represent an entity in a specific format. It can be JSON Schema, XML Schema, SQL Schema etc. Usually used to discuss database schemas.

142 questions
0
votes
1 answer

Porting a MySQL app to MongoDB and accommodating the _id field

I have a PHP app which can hook into multiple backends (currently MySQL or XML) and which I'm trying to make work with MongoDB as well. One seemingly minor issue that I'm distinctly struggling with is that Mongo mandates '_id' is the name of the…
dimo414
  • 47,227
  • 18
  • 148
  • 244
0
votes
1 answer

Creting collection only on MongoDB

I want to create only the collections structure. i.e. Say Products collection contains a list of Categories. I want to specify this container structure by creating this dependencies, but I do not want to create any collection entry (say there is a…
Ayusman
  • 8,509
  • 21
  • 79
  • 132
-1
votes
1 answer

Find minimal key for relation scheme

I have a database for an investment firm: B (broker) O (office of broker) I (investor) S (stock) Q (quantity of stock owned by investor) D (dividend paid by stock) Functional dependencies S ⟶ D I ⟶ B IS ⟶ Q B ⟶ O I need to find minimal key for…
Jay Lee
  • 29
  • 2
  • 5
-1
votes
4 answers

Does SQL Server have native support for EAV

I love the flexible schema capabilities of CouchDB and MongoDB, but I also love the relational 'join' capability of SQL Server. What I really want is the ability to have tables such as PERSON, COMPANY and ORDER that are basically 'open-schema' where…
Journeyman
  • 10,011
  • 16
  • 81
  • 129
-1
votes
1 answer

DB Relationships

I would like to have relationships: users accounts cards banks credit_processors. The question is how to design the model in the db. I got into a confusion when these scenarios came across: A card can be issued by a bank and the bank would link…
Moshe Levi
  • 19
  • 3
-1
votes
1 answer

Is it bad design to have many tables representing one object in MySQL?

I have many objects of this structure: ~ PlaceID = Upvotes = Downvotes = Names - Title + Upvotes + Downvotes - Other names[] + Upvotes + Downvotes = Location - Lat - Long - Address = Images …
user
  • 3,388
  • 7
  • 33
  • 67
-2
votes
1 answer

XSD equivalent code to this DTD code?

Assume that my DTD code have this following listing: Can I write XSD code, which defines that a sequence of three element (one optional) can be repeated one or more? If it can, what's the…
1 2 3
9
10