Tagged Questions

Database design is the process of specifying the logical and/or physical parts 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.

Let's say I have two schemas (HR and Finance for example), in each schema I have a table with information about document types this department works with. Tables have the same structure:
HR.doc_type ...

I want to query in a database like :
Let us consider a student table with the following attributes: (Id, Age, CGPA, Address, Gender). Our table
contains record for all the student in the world (so my ...

I will preface this by saying I am a relative novice to Access but I have managed to develop some basic databases. I have some working knowledge of expressions and macros but VBA is still a bit of a ...

Good day,
Our db professor at the univeristy always said that one-to-many relationships with (0, M) in one side MUST have a third table to relate them. I did not ask him back then and now I cannot, ...

I'm having trouble designing a database for a project I was working on recently. It's to do with a garage management system.
So I've realised I need to store multiple types of parts (Tyres, engines, ...

Say I wish to store when staff are on holiday (FromDate, ToDate) and then I wish to find all staff that are on holiday between two given dates (QFromDate, QToDate).
Now assume that I have many such ...

This is a related with IBM datastage 9.1, when I try to test oracle connector. Show error massage like as a below
"Error loading connector library ccora11g.dll %1 is not valid win32 application",
PLs ...

I'm not sure if this is the right place for this, so please feel free to tell me if it is off-topic or there is a better place to post.
I am working on a fantasy sports based project, and the number ...

I have a bunch of questions and answers and total votes of those questions and answers. My requirement that I always show how many votes for a question or a answer (and user doesn't often click to who ...

I want to create simple conversation module on my site. So I need a list of users who had conversation with current user. I need to show amount of new messages in each conversation.
I think about next ...

I am working for a mortgage company in migrating a legacy application to new application for managing claims, means lender fore close a loan and request for a claim to get its funds from government or ...

I'm working on a database in SQL Server for a project. My background is in data analysis and although I'm familiar with database design I don't have a lot of experience.
The project revolves around ...

Help for design DB, I have user, order, scratch_card and transaction tables. When user place an order, one record will add to order and another one to transaction as withdraw and when user recharge ...

I am designing a datamart using the basic principles of Kimball for use in SSAS. I have a many many to many attribute relationships (multi-valued dimension objects), however I have a few questions:
...

I am looking to implement a generic comment and file attachment facility within a web application which would be used across various parts and allow users to provide comments and add attachments to ...

Using stored procedures as part of an ETL process to populate tables in another database, which method would be considered a best practice (if any) in terms of deployment, maintenance, visibility and ...

I am working on preparing an SSIS job where I am importing a .CVSV file to OLE DB destination (sql database). We are going to get these files on daily basis. The .CSV file contains records of doctors. ...

I realise this question may have be answered in some form but I would like to gather the thoughts and opinions of actual users with experience in this field of Database design and development. I have ...

I am going to build and flight ticket booking system.
My client has own planes. Under is basic concept of engine.
Admin will add flights.
Passengers,agents,franchises or admin will book the tickets.
...

I have following objects:
(Rooms) which are (available in a certain period of time [in days]).
During the time of availability they can be (booked) by (users). There are basically these four tables. I ...

I've got tired of using notepad / excel to manage my tasks at work.
Since tasks may sometimes contain sensitive data, my boss will not allow us to use an online task management system, so I've decided ...

I am trying to model a courses structure and dependencies of a university.
For example, in the Computer Engineering department you need to do Data Structures before doing Artificial Intelligence. But ...

I'm designing a database that is used to track an inventory item through its lifecycle. I'm currently relating my tables using the previous lifecycle event's ID (for example, a shipment contains the ...

Our team is working for a while now with Azure SQL. After a lot of trying , we managed to add a sync group between the main DB and the backup one. Of course, this means that for every change in the ...