365体育足球滚球比分

Questions tagged [database-design]

Database design is the process of specifying the structure and thus the logical aspects of a database. The goal of database design is to make a representation of some "universe of discourse" - the types of facts, business rules and other requirements that the database is intended to model.

Filter by
Sorted by
Tagged with
0
votes
1answer
4 views

Designing table for historical data from multiple tables

I have different kind of fields in different tables that needs to be versioned as historical data . what is the best way to approach this ? what I did is to capture one level of grouping fields. I ...
0
votes
1answer
18 views

When to use composite key instead of auto increment

I am creating a database and I am not sure about one of my tables. This table stores the users that are in each game, so one entry per user per game. The user is identified by their user_id which is a ...
0
votes
0answers
15 views

REST APIs: Hiding surrogate keys and only exposing natural keys to the user

Suppose we're working with a database that has the following relation: CREATE TABLE Author ( first_name VARCHAR NOT NULL, last_name VARCHAR NOT NULL, birth_date DATE NOT NULL, death_date DATE,...
1
vote
0answers
20 views

I'm having a lot of trouble understanding this article on modeling Relational Data in DynamoDB. Can someone breakdown the example queries?

http://docs.amazonaws.cn/en_us/amazondynamodb/latest/developerguide/bp-modeling-nosql-B.html specifically I don't get the bottom table outlining the different types of queries. for example, to ...
0
votes
0answers
6 views

How can I view the .edmx diagram on visual studio for Mac?

I want to view the edmx diagram like below an example of how it is viewed on windows visual studio I have tried looking at Microsofts documentations regarding this issue, but it still doesn't seem ...
-2
votes
1answer
20 views

Primary key in sqlite3 [closed]

I'm designing a new Python application to store historical and realtime stock trades using Sqlite3. The database will store many stock symbols with varying amount of data. Some symbols would have ...
0
votes
0answers
12 views

Good Schema for DynamoDB and Quantitative Equities Time Series

Problem Statement What is the most sensible DynamoDB schema (e.g. choosing the composite index and attribute representation) for the following data subject the expected query patterns described below:...
-1
votes
0answers
15 views

Why do We need Details table?

why does details table generally exists on transactional database design, for example: transaction_details belongs to transactions table. Why don't we put the details of the transactions on the ...
-4
votes
0answers
24 views

Design Idea for School Management [closed]

I am trying to make a school management software and I want to make the whole software myself. Though this is for my learning purpose, I want to do this project as if I have to deliver the project to ...
0
votes
1answer
25 views

What should be the data type of field 'email' in Postgresql database in pgadmin 4?

You can see that I am getting 'No results found' when searching for varchar. I need to know the data type that I should select for 'email' in postgresql database.
-1
votes
0answers
10 views

What is the best way to store chat logs with mongoDB? [closed]

I'm building a simple chat application (which also happens to be my first application) with React Native, Node.js, and MongoDB. My problem is that i don't know how to design the mongodb database to ...
0
votes
0answers
10 views

How to store a queue of people in mongodb?

I am building a Hospital management system which has a booking/appointment feature. I need to store a queue of people waiting to see the same doctor. How do I implement and store this in mongodb? This ...
0
votes
2answers
20 views

How to get rid of redundancy in a mysql table with lists in an efficient way

Some time ago I made a fast MVP that now has become a more realistic project. Now I'm refactoring and improving it. I have a table like this CREATE TABLE `records` ( `id` int(11) NOT NULL, `type` ...
-1
votes
0answers
14 views

How do foreign keys affect partial and transitive dependencies (databases) [migrated]

I'm struggling to work out how foreign keys can affect partial and transitive dependencies when normalising databases. I have multiple tables, two of which are job offer and accepted job. in job offer,...
0
votes
0answers
18 views

Database design: How should I handle product deletion for e-commerce site?

I'm sure the delete vs flag debate has been asked to death everywhere but I'm finding it hard to find a satisfactory solution and I feel like I may have left out some issues. I have evaluated the 3 ...

15 30 50 per page
1
2 3 4 5
1486