The logical model and/or physical design of a database.

learn more… | top users | synonyms (4)

0
votes
1answer
52 views

Should I create a new table for store information of an associated object with object need to create

I'm not sure if topic can get you understand what I want to explain. Follow guide in my old question, now I have these tables and its columns: Course: name,... Topic: name, course_id Question: ...
0
votes
2answers
1k views

Keep total transaction in invoice application

I want to make an application called as Invoice Application with MySQL database. Now I have designed this database. Now I want to know is this database good for Invoice Application. I will use MySQL ...
0
votes
1answer
169 views

What MySQL storage engine and table schema should I use?

I am making a web project and I created necessary and the most important table, but I am not sure that I did it right. In this site users will post data like text, picture, text's category, etc. I ...
0
votes
1answer
74 views

How to design this kind of relations in a database

I have a conceptual problem and I would like to get your ideas on how I'll be able to do what I am aiming. My goal is to create a database with information of persons who work at a place depending on ...
0
votes
1answer
113 views

Is it acceptable to have a surrogate/primary key of one table be the primary/foreign key of another table?

For my purposes I'm trying to apply this to Microsoft SQL, but would like to know if there are restrictions for other DBMS regarding this. I don't know how to represent UML as ascii characters so if ...
0
votes
1answer
71 views

Several variants of a string in tables

I need: a table containing keyword phrases; a table containing URLs; a table (or maybe a view) with keyword-URL pairs (referring to IDs of the two previous tables); tables holding keywords/URLs for ...
0
votes
1answer
125 views

unenforced constraints/possible duplication in my database design?

I am trying to store information about a school and the class timetable in a database. The outline is as follows: 'A subject has ~20 lessons, each of which needs to have it's description stored in ...
0
votes
1answer
366 views

Users database to store access levels, can I move the non-essential information to another table?

I would like some advice on the best database structure for my system. I have different kinds of users with different access levels, and different information of course. I created a users table with ...
0
votes
1answer
269 views

Trouble in Multi-Language DB

I'm working on a DB design for medicines in many countries with different languages. I created a table for the different languages I want and link it to another table of chemicals. But I find that ...
0
votes
1answer
3k views

Db design for a quiz with variable number of answer choices, and each worth different score in a different category?

I'm working on a question/answer project and having a hard time coming up with a suitable database structure. Each question can have from 1 - "n" answers, and each answer is associated with one of ...
0
votes
1answer
265 views

How to simplify schema for multi database / hundreds of millions of rows data set

We currently have a MySQL data set that was started about 10 years ago that aggregates a log of data, and accumulates millions of rows each month. The people that developed our system started ...
0
votes
2answers
113 views

Tiered permissions to generate conditional data access

I am working to improve the confidentiality and access level of the information presented within a program interface over top of a MySQL database. My goal is to create a two tier system: one based on ...
0
votes
1answer
1k views

How to link data from a table to another table in sqlite database?

I need to link data from a table to another table. I'm not sure how to do this. I have never link a table to another table. Anyone can help me? Or maybe can give me examples or sample codes? Thanks =)
0
votes
1answer
163 views

Review my logical model for gaps

We need to centralize our ability to manage the various schedules that our banking centers keep since it is a manual nightmare right now. Do you see any obvious gaps in this? A schedule is ...
0
votes
2answers
5k views

How can primary keys in a Netezza table be indexed?

What is the best way to index a Netezza fact table with lots of primary keys. For now, let's suppose we have 10 primary keys. This table is mainly used to store meta data about our database. =====...
0
votes
1answer
508 views

SQL DB design to support user feeds (in application like facebook)

I have a social network server with a MySql DB. I want to show the users feeds like done in Facebook. Example - UserX now Friend with userY, userX did like on postX etc. Currently I have table: C1 : ...
0
votes
1answer
653 views

Data base structure of a subscriber list

I am building a application that allow different user to store the subscriber information To store the subscriber information , the user first create a list For each list, there is a ListID. ...
0
votes
1answer
668 views

MySQL table with multiple values in one field

I'm building a database for a real estate company. The real estate properties are managed by sales people using a CodeIgniter website. How should I proceed with the database design for this table? ...
0
votes
1answer
522 views

Database Design: What is the best structure for storing site offices and locations?

Background I am creating a database driven web application for the management team at the place I work. Part of this application requires fairly specific locations to be linked with where equipment ...
0
votes
2answers
283 views

How to implement Draft functionality, with attached files?

Should allow for: User can save an entity as a draft, that would normally not be valid in its table (ie some missing values) User can attach files to the draft User can find, sort, and discard their ...
0
votes
1answer
141 views

Help me to better design my query so I can gain more performance

I need to find so called first entry in database for items regarding their partners. I wrote query and it is giving me correct results but it sucks with performances. I suspect that I have missed ...
0
votes
2answers
86 views

Advice on choosing a primary key

I will have to do this process in EXCEL first before it is made into a database. I will have many files, but there is about 7 - 9 files that work all together as one e.g. X192AD1-test.docx X192AD1-...
0
votes
1answer
1k views

Database design : multiple category of users login into same system

In our new system we have three type of people Business owner Assistant of business owner Staff (a skilled employee) I am having following entity [Business] - include detail about business ...
0
votes
1answer
120 views

database normalization and optimization for postOffice DB

I am designing a web application for a post office. Performance in database is critical for them. I have designed the below structure for the post database, is there any flaw in my db structure which ...
0
votes
1answer
124 views

How should I model this data?

I have a need to model the following requirement for a web application (PHP/MySQL5): A user can compete in a distance-based challenge which consists of entering progress along a defined round-the-...
0
votes
1answer
500 views

Depicting permissions to access table via E -R diagram

I am designing a database schema for a web application. Its a first time I am designing a database with a commercial aim. I have started with drawing E-R diagrams after going through requirements ...
0
votes
1answer
1k views

Database design for head to head sports

I am trying to create a database to store details relating to darts matches. Im relatively new to this so was wondering if the design I've come up with below would work. It seems I have lots of places ...
0
votes
0answers
9 views

When to add a new table or new column

I have looked at previous questions dealing with New table or new column and When should I use a new table? and a few others. I'm a little confused, not sure if my problem has a different need/...
0
votes
0answers
33 views

Paging through data that is frequently changing

When users are browsing pages of data where the data keeps changing, what is the best way to control this so the user experience is not impacted. If I browse catalog of 100 records with 10 per page, ...
0
votes
0answers
24 views

Structure a database for a Blog

I built a database for a blog. I am a student yet, so my knowledge is limited in this area. I post this question to get a briefly description of what I do wrong, why, and how I can fix it. I'm not a ...
0
votes
0answers
13 views

Database design settings issue

I have a problem designing reminders for invoice database. Reminders should be pre set up to a number, and also varying upon consumer or business. For example #1 (B2C) a 10$, and #2 a 25$ etc. Draft: ...
0
votes
2answers
23 views

Find changes made in the table in sql server 2012

I am using a SQL Server.I have more 1000 tables in a database which i want to track for data changes.I have read about CDC(Change Data Capture) and will enable it on all the 1000 tables.It creates ...
0
votes
0answers
10 views

MongoDB design schema

Objective Get a good schema capable of making searches easy depending on the hierarchy. Background I am coding a database for a webervice that will return information about items for a game called ...
0
votes
0answers
26 views

How to delete data which violates the DB design

I am searching for tool/utility or a way to clear database of parasite information. The database is of over 250 tables so manual fixing is not acceptable. The database was running over the years with ...
0
votes
1answer
23 views

Make MongoDB close open files

I am currently trialing numerous database designs (to solve this problem: Large (>22 trillion items) geospatial dataset with rapid (<1s) read query performance), and my latest design in Mongo ...
0
votes
0answers
19 views

Database design for user info [on hold]

I am working on a django app and would love so help on a design issue I cant seem to wrap my head around. Basic Info The landing page of my app will show a table of all registered users which will ...
0
votes
0answers
15 views

Confusion of Time Stamping Protocol and Two Phase Locking Protocol in schedule

I'm wondering if someone helps me. Actually, I have a little confusion in Concurrency Control Time stamping protocol and Two-Phase locking protocol in a transaction schedule. I have found this ...
0
votes
2answers
38 views

Financial Statement table

I want to ask about database design for financial statement. I want to combine balance sheet, profit loss, cash flow,and ratio into one big table since each statement is dependent each other. Here ...
0
votes
1answer
18 views

Modeling Optional Column

I've got an optional column (residential) in one of my tables that is giving me trouble. If a Licensee intends to work w/ residential customers, they need to take an additional course (...
0
votes
1answer
52 views

Database design considerations for unused columns with every table has same schema

I am a web developer so I don't know a lot about databases. The company I joined recently has a very mature Desktop ERP built in .NET and SQL Server, they are providing services to huge corporate ...
0
votes
1answer
23 views

Is a meta table useful

Lets say a lot of my tables will have the same few columns for example a name, description, created timestamp, last updated timestamp. When is it appropriate to put these common columns in a separate ...
0
votes
0answers
13 views

Design: Available domain database

I'm building website and service that will allow user to check if given domain is available. Right now I'm thinking about good way to store result from whois, but i dont want to store whole response ...
0
votes
2answers
24 views

Design: Multiple Values in One Column or Many Columns?

I am designing a database based on NBA stats. For a particular part, I have: Game: [ Id, HomeTeam, AwayTeam, Date, GameTime … ] GameScore: [ Id, GameId(FK), QuarterOne, QuarterTwo … ] For game ...
0
votes
0answers
17 views

English Dictionary Database Design

English words can have the same spelling but different meaning. If I design a database table for an English word what is the best way to different words that have the same spelling but different ...
0
votes
0answers
13 views

Access 2013 and VBA

Guys just joined and i have the problem and i hope you guys can help me. I have two tables one called File Cabinet Table and Request Table, and three forms In-Take Re-retrieve and request. Basically ...
0
votes
0answers
18 views

visualize sqlite database schemas

Is there a way to genarate a visualisation of a large database? I want to visualize the database structure of matrix-synapse somehow, maybe there is a way to get an overview over the database somehow?...
0
votes
0answers
37 views

pros and cons of partition or not-partition this sql server table that is highly hit?

I have a table that is highly hit on my database. this table has 370,370 records. when I run the following select: select [ImageSize] , the_num = count(*) from [dbo].[ProductImages] group by [...
0
votes
0answers
19 views

Database design for login statistic over few years on AWS

Actually on a project I'm working on we are using MongoDB for statistics but it's not working like we want. It's too slow and we have to make too many aggregate tasks to get fast results. Login ...
0
votes
0answers
18 views

Super polymorphic event schema

I want to be able to track every action a user takes on my site. An action can originate from a visitor or a user (both of which are human). An action can affect a subject (visitor or a user) An ...
0
votes
3answers
33 views

Person-Address = 1-1 or N-1 (In this context)?

I have 4 tables: Province (province_id, name) City (city_id, name, province_fk) Another Smaller subset under city say... City_sub (sub_id, name, city_fk) Address table (address_1, address_2, sub_fk, ...