Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [data-modeling]

Elaborating passive data structures based on the analysis of data requirements for the purpose of designing and implementing standardised data formats, databases and data processing systems.

Data modeling consist of gathering requirements and knowledge about the data needed to solve a given problem, and elaborating abstract data structures for the purpose of designing and implementing standardised data formats, databases and data processing systems.

Data-modeling is a specialized kind of modeling solely focused on passive data structures, and independent of the description of the processing of that data.

105 questions
37
votes
7 answers

Modeling first and lastname separately

Which arguments should someone consider when designing a new system and has to either store the name of a person as one field or separately as first/last name? Pros for single field: Simpler UI No ambiguity when trying to enter the name of a…
Istvan Devai
  • 495
  • 1
  • 4
  • 7
29
votes
4 answers

Is there an industry standard for gender model other than male and female?

I am modeling a database that should be used as generic non-functional requisite for all services of the startup company, like persons, users, services and commercial data like coupons, signature packages, etc. I am thinking about the gender model.…
NaN
  • 549
  • 4
  • 10
22
votes
4 answers

ERD: "many" vs "zero or many"/"one or many" crowfoot notation?

Background I saw this figure describing the different crowfoot notations used in ERD: I'm not able to find the difference between the "many" notation and the "zero or many. However I was able to find an example (see bottom left for the "many"…
KingBoomie
  • 545
  • 2
  • 5
  • 11
16
votes
2 answers

How should I design an ordered list resource in a restful service?

I've run into this same problem over and over again and I haven't found a solution that I really felt was optimal. Say in an app, you have an ordered list and you let the user change that order by drag and drop or something. You want the changes in…
Rico Kahler
  • 240
  • 2
  • 10
12
votes
6 answers

How to model more than one 'last name'?

In Spanish-speaking countries we use more than one last name, like: First name ↘                           ↙ Last name                 Pedro Arturo Rodríguez Loyola         Middle name ↗                               ↖ (?) I'm trying to model…
Pablo Olmos de Aguilera C.
  • 231
  • 2
  • 6
9
votes
2 answers

Database Design for Inventory

I am starting to design a typical product based MySQL database but I keep running in circles on how to design the tables. I have many types of products Jeans Tshirts Dresses Which have many of the same attributes Size Price Colour But some of…
Berry Bonds 3
  • 101
  • 1
  • 4
6
votes
1 answer

Should an entity id contain information about entity?

If an Entity doesn't have an unique ID, we usually use auto increment number to distinguish entities. But sometimes, we have to hand that ID over to people so that they can use it. So using auto incremented numbers is not a good fit for this. Think…
ramazan polat
  • 199
  • 5
6
votes
2 answers

In an MVC, should models use libraries, or should libraries use models?

When I build a RESTful API, I use an MVC pattern. And in order to make controllers skinny and code reusable outside of the API (e.g. in Cron tasks), I put much of my code into services (commonly known as libraries). My routers delegate to…
Chad Johnson
  • 491
  • 4
  • 13
5
votes
3 answers

Rebuilding a legacy application : What about the data model?

I am currently rebuilding from scratch a product catalogue (to feed a shopping website). The existing legacy system is heterogenous, Long story short : The some products are stored in a FileMaker database (with a big spaghetti data model) and other…
user15083369
  • 75
  • 3
5
votes
2 answers

How multi-valued and derived attributes are denoted in crow foot's notation of ERD?

In Chen notation multi-valued attributes are denoted by double eclipse(oval) and derived attributes are denoted by dotted eclipse(oval), but how they are denoted in crow foot notation? Also how associative entities are denoted in crow foot?
Saif Ullah
5
votes
3 answers

Is an enterprise-wide data model truly feasible?

I've consulted for a number of Fortune 500 and 100 companies all of whom have made some kind of effort at creating a "Master" data model even to the point that they'd attempt to have all applications work with a shared database (Imagine the change…
Michael Brown
  • 21,684
  • 3
  • 46
  • 83
5
votes
1 answer

Data Model for selling groups of products as one product

Say I have an e-commerce with a data model like the following, which allows a Sale to describe how a single Product is sold. This division allows a product to be sold multiple times in different ways (different pricing, or offered at a different…
Alex Wayne
  • 421
  • 2
  • 5
  • 9
4
votes
2 answers

Applying Domain Driven Design to an analysis driven domain

I am currently working on a domain that is fundamentally driven by analytics. I'll use a fictitious example to illustrate my question. Suppose the application is a service based on House Prices. The goal is to use predictions generated by a data…
Cosmica
  • 87
  • 4
4
votes
3 answers

ER diagram - feasibility of a requirement

I need to model the following requirement in an Entity-Relationship diagram. "Customers place orders, which contain a list of products with their quantity and prices. A shipment is made when products are ready to be delivered to a customer. A…
holy_el
  • 49
  • 1
4
votes
1 answer

What is an example giving the difference between Domain Model and Data Model?

I've seen many articles describing differences between Domain Model and Data Model. However none of the articles have picture representations showing…
CarSpeed87
  • 351
  • 4
  • 11
1
2 3 4 5 6 7