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

learn more… | top users | synonyms (4)

0
votes
1answer
78 views

How to design a table for reconciliation

A Bank B sends a set of transactions to Bank C every few minutes. Same transactions could be sent multiple times (Bank C should recognize those transactions and should not process them). At the end ...
0
votes
1answer
79 views

CALCULATE TOTAL NUMBER OF ESTIMATED HOURS [closed]

I had a question regarding a small task I've been assigned. Below I have pasted the question and a screenshot of the database layout. Now I just don't understand what exactly I'm meant to create, a ...
0
votes
1answer
40 views

MySQL - how to store “other”?

How to store "other" text? In summary, I have too many of these kinds of fields (like hundreds?): http://i.stack.imgur.com/0H81O.png I don't know an appropriate way to handle this. If I store only ...
0
votes
1answer
128 views

How would you design a table for approval system between User and Sports Club

I am currently learning database modelling and struggling to model the following requirement. I have a user and sports_club table. User can only join a sports_club if three existing users of the club ...
0
votes
1answer
76 views

SET or VARCHAR for list of tags in a MySQL photos table?

I just discovered the SET column type for MySQL tables. I have a photos table with ARIA engine where I want to store tags/keywords for each photo. Now I use a VARCHAR type and then find the photos ...
0
votes
1answer
99 views

Normalization from UNF to 3NF

I keep getting confused trying to normalize this data. A company makes and sells a product online. There are ten types of Products, each having a code and price. Their Sales Order department takes ...
0
votes
1answer
22 views

Should i separate ContactInfo (sub-entity) from MyTable (main-entity) or Not?

I am designing a database of a school management system. I have one to one relationship of MyTable with ContactInfo table. I am confused whether I separate contactinfo from MyTable or not. ContactInfo ...
0
votes
1answer
38 views

Data model Reference and schema

I just started to learn MongoDB database and for my project. I am trying to implement a MongoDB reference schema. In my Menu table I would have a food ingredients attributes where it will store the ...
0
votes
1answer
115 views

Derived classes with same base class and class specific ids

I have three classes in my project. One base class and two derived classes. public class Animal { public long Id { get; set; } public DateTime Created { get; set; } public string Name { ...
0
votes
1answer
49 views

Storing shipping details in orders table

Have orders table and among columns the following: shipping type, shipping service provider, delivery type and shipping address. Let me explain what these are. User can choose between two shipping ...
0
votes
1answer
80 views

Database modelling : Creating a model for restaurant application which gives statistics

I am working on a server-side application in which users will be able to give ratings and comments to different factors of a 'Restaurant'. What the webapp does is takes all the ratings and creates ...
0
votes
1answer
115 views

How can I re-structure my activities table?

I've created a feed but I'm not sure whether it's okay or not, hopefully will get some answers to correct it if there's anything wrong. I'm using MySQL. When a user does something, his activity is ...
0
votes
1answer
41 views

What is the best way to create tables for email campaigns?

I have table email_sent with fields: id user_id template_name sent_at opened clicks And now I need to save data which was send for each email. I have several campaigns with differnt data. For ...
0
votes
1answer
55 views

Flexibility vs Performance question

I'm in the middle of designing a database, and have a question for the veterans in regards to scalability. Currently, I have table A, which represents some object, and table B, which contains ...
0
votes
1answer
202 views

Database-design for a small filter / search tag function

I'm building a search function in php for a database with 1k to 4k articles. It's going to be built on a tag system. I've been reading some tutorials, blog posts, q&a etc about it. Most important ...
0
votes
1answer
32 views

Table with low selectivity ratio

I have one table now with million rows.. Table-1 Name, Age, Sex, Dept Tom 25 M Finance . . . Now, The "Finance" is reptitive...Currently, there is only one dept "Finance".. Is it good to ...
0
votes
1answer
134 views

Split table vs. same values in multiple rows

I have a table products: #products ID | category | type | criteria1 | criteria2 , with category and type being foreign keys of other tables. Should I split this table up into ...
0
votes
1answer
123 views

Web application for Software as a Service - Shared database or Multiple Databases?

(I am not sure if this is the best place to post this question. If not, please redirect me to the appropriate stack exchange site.) I am looking to deploy a web application for multiple clients. The ...
0
votes
1answer
63 views

Database design help required

Need help designing in my database tables. I have a set of table which are being populated on every execution, like wise this executions are user specific if user executes an execution data at that ...
0
votes
1answer
42 views

A form including content from two tables

I am working to create a database of all the places or administrative entities of one country. Most work will be about adding new districts. I have to detail which region every district belongs to. ...
0
votes
2answers
2k views

How to export Oracle database without data

I want export my Oracle database with its structure such as tables, schema, users, tablespaces, datafiles and everything but without the contained data.
0
votes
1answer
49 views

How to get last messge between two friends in the messge table having id in descending order?

Hi friends help me to solve this problem ," display all last messages of a user from all his/her friends" My sample message table is --------------------------------------------------- | id | msg ...
0
votes
1answer
42 views

I am designing a database for a game and the only option I can see a multiple table solution. Is there an option that I'm not seeing?

I searched but could find a similar situation, if I missed it please let me know. In this game there are approx 14,000 items which have their own table. The players will want to build multiple ...
0
votes
1answer
86 views

How to track changes to a record that spans multipe tables

I have the challenge to design a new database using a RDBMS, Oracle, to be precise. In this database there will be one specific record/document which may span multiple tables. With as little ...
0
votes
2answers
48 views

Approach to take regarding a field that is frequently re-computed

I have a few fields with text data in a main table which is processed in a certain way to produce a processed version of that piece of text. Now, the way in which this text is processed is expected ...
0
votes
1answer
90 views

Database design: handling time

I am developing a weekly timetable which ideally would allow teachers pick what subjects they teach. While most of this is fairly straightforward, from a conceptual point of view I am unsure how to ...
0
votes
1answer
99 views

Working on a blog creation website; should I be creating a new table for each blog, or keep everything on the same table?

So I'm working on this blog creation website as a side project. I don't actually expect it to become anything, but I want to make it as efficient as possible, even if just for practice. The idea is ...
0
votes
3answers
105 views

Which of these database designs is normalized?

I have two possible database designs. A) a many-to-many relationship between Branches and FiscalYears via a dedicated join table FiscalYearsBranches B) two (or more) many-to-many relationships ...
0
votes
1answer
143 views

Can I have more than one relationship between two tables? [closed]

I want to make database for report maintenance. I have 3 tables: employees header_maintenance_report detail_maintenance_report employees table I have employee_id and then in the ...
0
votes
1answer
35 views

DB Recommendation While Minimizing Size

I apologize if this question is too specific, if it is, please let me know! I have searched around both on here and the web on selecting the best project-specific engine to fit your needs, and have ...
0
votes
1answer
60 views

How is time stored in the FireFox sqlite database “places.sqlite”?

How is time stored in the FireFox sqlite database "places.sqlite" ? Looking to modify the stored visit time on a few entries but I can't seem to figure out how to, is it encrypted?
0
votes
1answer
378 views

Social file sharing database schema

I have a project called social media file sharing. I have this database schema and I need your opinion about what I should remove or add or edit on my database schema. Every user can upload media ...
0
votes
2answers
807 views

No suitable driver found Orientdb jdbc driver

I have some problems with Orientdb driver for jdbc. i´m using Netbeans, i have include the library JDBC+OrientDB libraries (orientdb-jdbc-2.0.8-all.jar) in the directory and in netbeans, i have also ...
0
votes
1answer
98 views

How to design a main list and sublists schema

I am finding it difficult to design a database schema for a list feature. there would be a master list which then can be subsectioned into further lists. each user is able to mark a candidate as a ...
0
votes
1answer
211 views

Find the functional dependencies that hold in a relation

There is a question in my book that asks the following: Suppose we have relation R ( A ,B ,C ,D ,E ) , with some set of FD’s, and we wish to project those FD’s onto relation S(A, B, C). Give the ...
0
votes
1answer
53 views

how big of a role does hardware play? [closed]

I'm the developer, not the DBA. I don't know much about setting up databases but i'm concern of the setup at my current work. The server is installed on desktop PC hardware(i7, 16GB RAM, 1 TB SATA ...
0
votes
1answer
49 views

improve database design for monitoring application

I need assistance with my DB design, I have a monitoring script that produce the following data every minute , and produce stats about virtual machine performance. Array ( [timestamp] => ...
0
votes
1answer
310 views

Database Design For Social Network apps

I'm going to build a social network app. Each user will have photos, videos, details, posts etc. My question is when a new user registers, should I generate many new tables for that user or have one ...
0
votes
1answer
45 views

Inbound Outbound Shipping Database

should we combine both inbound and outbound shipping into a single table (then create an additional column to identify the direction) or to split them into separate table? What's the pros and cons?
0
votes
2answers
58 views

Is following way is right Database model for following problem?

I am new to the database design so I have to check my data model is correct way to handle the problem or not. Problem Statement: I am designing the database for student portal which have following ...
0
votes
1answer
68 views

Database design: Is there a much better way on this current relationships?

I have a facultyand studenttable to store each information, respectively. I made a contacttable to store the contacts of either faculty or student. I would like to use the contact table as a generic ...
0
votes
3answers
110 views

Schema Design with “Seasonal” Data

I am developing a SaaS web application for School Management. What I need help is this: The whole application is purposed for the current year that the School is in. However, some data and ...
0
votes
1answer
50 views

How to segment account info and profile info?

I am putting a rough SQL database design together and have gotten stuck on how to segment information about the users. (Note before I get into anything, stored passwords are salted and hashed, I just ...
0
votes
1answer
37 views

Big lists in a relational DB

I need to store a list of items and that list belongs to a single user. The lists are going to be huge, so this has to be done as efficiently as possible. The lists also have to be modifiable to a ...
0
votes
1answer
44 views

Finding the same value in a column and only returning rows without the same value

I have a query that i have to find the DiscountPercent that are the same and not show the rows with the same DiscountPercent. I have tryd this and it brings back the values that are the same SELECT ...
0
votes
1answer
317 views

Store data of feedback form

I am a novice at database management and doing a small project on Feedback System. My question is that I want to know that how i should store the data of feedback form. Suppose i have different ...
0
votes
1answer
109 views

Most efficient way to set up a database handling millions of links? [closed]

I'm looking at making a site that will potentially have up to a million users, and each user will have hundreds/thousands of links connected to a set of sites, as well as other info. I'm using mysql ...
0
votes
1answer
80 views

EAV table question

What's the best design for taxonomies in EAV tables? taxonomy id autoincrement name unique terms id autoincrement tax_id references taxonomy(id) name text unique value text ...
0
votes
2answers
55 views

ERD Design for Campground and Campsite

I am designing erd for campground and campsite. In general, a campground has many campsites in it. that lead to one to many relationships. but sometimes campsite has no campground, it appears as the ...
0
votes
1answer
59 views

Should I have a parent table with only one field?

My database has multiple tables that all rely on dates. I was wondering if it would be smarter for me to take the date attribute and throw it in a parent table, rather than give each table a date ...