1,065 Topics

Member Avatar for
Member Avatar for Maali

Hello, need help here. i did come up with something but i get confused. please help me out so that i can proof-read my solution. Thanks Malcolm A company called Street Order Ltd manages street parking in Kampala city. The company collects revenue by charging any vehicle that park on …

0
76
Member Avatar for fairchild

Hi there, My database contains two tables namely [B]Products[/B] and [B]Stocks[/B]. Product table consists of [B]ProductName(VARCHAR[100]), PackingStyles(VARCHAR[2000]) and Grades(VARCHAR[2000])[/B]. Primary Key is the combination of these three fields. The values of PackingStyles and Grades are entered using a listbox and so they are stored as comma separated values. The Stocks …

Member Avatar for fairchild
0
77
Member Avatar for samZin

Hi there i am just new to this forum and hoping to get some geeks to help us out Here is the problem We have a website on our own server (win 2003 sever) website [url]www.jpsequipment.com[/url] We decided to transfer all data including the database to a different webhosting company …

Member Avatar for SheSaidImaPregy
0
180
Member Avatar for jamez333

I am trying to use this script to enter data into my database from an html form. [code] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Item Entry - Opulentworx - Private</title> </head> <body> <form action="/php/itemENTRY.php" method="post" id="itemENTERdb"> <input type="text" id="itemNUM"/>Item #<br> <input type="text" id="quant"/>Quantity<br> <input type="text" id="date"/>Date<br> <input …

Member Avatar for fatihpiristine
0
116
Member Avatar for jamez333

I am using this html form page... [code] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Item Entry - Opulentworx - Private</title> </head> <body> <form action="/itemENTRY.php" method="post" id="itemENTERdb"> <input type="text" id="itemNUM"/>Item #<br> <input type="text" id="quant"/>Quantity<br> <input type="text" id="date"/>Date<br> <input type="text" id="cost"/>Cost<br> <input type="text" id="ground"/>UPS Ground<br> <input type="text" id="3day"/>3 Day …

Member Avatar for jamez333
0
97
Member Avatar for ray_broome

I posted a similar question in MySQL section before but i think this one might be more general/easier to understand (hopefully): I'm doing a database (in MySQL) of different plants which is gonna store various (somewhat detailed) information about them. Here's a sample of two tables: Families (Plant Family) [code] …

Member Avatar for ray_broome
0
111
Member Avatar for Holy_Assassin

Hello everyone! I've been thinking to design a web-based database (in DB2 and PHP) for my father's company, but I need some help because I don't know where to start. Details: [LIST] [*]The database will be used to store Microsoft Office's files (Word, Excel, Powerpoint, Publisher) and Adobe files (Indesign, …

Member Avatar for fatihpiristine
0
54
Member Avatar for ahady515

I am Ahmad AbdelHady, 35 yrs old I have good knowledge in Database design, T-SQL, PL-SQL I have hands on experience in DBA activities on MS-SQL, Oracle, DB2 and SYBASE I will do my best to help anyway I can and looking forward to fruitful encouters Best Regards

Member Avatar for jbennet
0
42
Member Avatar for irajani

Hi, I'm designing a database for a company that retails computer products, phones, faxes and so on. As you can imagine, there are a number of different types of products, eg. hard drives, CPUs, routers, optical drives and so on. One of the requirements is that for each category there …

Member Avatar for betashruti
0
154
Member Avatar for v_ganeshraju

Hi, I need to send notification email on a specific change to a field in database table. I need to also track if the email was delivered or not. If the email is not delivered, it should be logged for a different process. Can someone please help me to architect …

0
58
Member Avatar for sakura_fujin

Hi. I'm new with Java's GUI Components and I'm having a hard time with my program design right now. My program deals with manipulating database elements (i.e. fields and records) and I'm stuck with asking the user to add a new record into the database. My program originally works in …

Member Avatar for Ezzaral
0
147
Member Avatar for Gofoe

Hi All, Am a newbie in VB.NET and i want to design mater/detail form. The detail form is linked to Datagrid however, i want to place an unbound field on the form to sum up one of the column of the detail form. Any help to achieve that? I have …

0
55
Member Avatar for atal

Dear All, I have a [project] table which includes Project name,Startdate,EndDate,Location.and [SubContractor] table which includes id,subContractor_name. each project has one SubContractor at time and one SubContractor may have many projects at time. There are cases in which the first SubContractor leaves the project for some reasons and the company give …

Member Avatar for xyte
0
111
Member Avatar for adeel.alvi

Iam working on a purchase managment system that manages the puchases and inventory of the company that sells pcs. i want to manage employees (pemant,consultants) , customers , supliers , business partners all will be the users in the application . what would be the right design of the database …

Member Avatar for Temmu
0
87
Member Avatar for apchidara

hi every one: today my supervisor asked me to choose a version of vb to start developing my project . honestly speaking I am so lost which version to choose" vb" or" vb.net 2005". honestly my oop programing is not good at all and I have one and half month …

Member Avatar for bka_k@Yahoo.com
0
172
Member Avatar for jiaenteo

hi all, we are in final stages of the hiring process for a developer to design a simple searchable database for an online marketplace. buyers and sellers will then connect and transact over our platform. there is also a simple community/social network component with ratings, reviews etc (not unlike dani …

Member Avatar for Salem
0
159
Member Avatar for long_vn

dear all. I am using php to design my website. I am vietnamese so i use font utf-8 in my database. But when i used php to connect to database, the display of the result has a problem. It was neither vietnamese to english. It had strange symbol. I think …

Member Avatar for MidiMagic
0
79
Member Avatar for GLT

Hi, I am a student on my year work placement and I have been asked to develop a web based database for a company. I think my design is ok but I am a bit confused in a part... The company wish to save emails in the database to and …

Member Avatar for GLT
0
122
Member Avatar for Saroja

I have about 20 small PDF files (business card design templates) that I want to be able to populate with data from a MySQL database (name, phone number, etc) and output to the browser/save to the server. When I am studying in British University then I visit site Download SNIPPED …

0
61
Member Avatar for danielgoehl

Hi everybody! I am Daniel and I am developing a Alumini Database right now using MySQL and Ruby On Rails. First of all, I must say this is an amazing forum. I really enjoy reading the posts. I hope you will be able to help me. I have the following …

Member Avatar for danielgoehl
0
107
Member Avatar for hughbedo

I am a looking for recomendations for a book on database design. I have tried searching this site, and not found any good answers though I am sure this has been asked before. My situation is that I start a new job in a couple of weeks and I want …

0
65
Member Avatar for atal

Hello All, I am working on a database, and have doubts in two fields (startpoint, and endpoint locations)therefor want your comments and suggestions, my database tables look like the following: [Projects table:] project_id project_name startpoint_location_id startpoint_latitude startpoint_longitue endpoint_location_id endpoint_latitude endpoint_longitude [Location table:] location_id location_name the startpoint_location_id and endpoint_location_id is linked …

Member Avatar for atal
0
107
Member Avatar for jread

I have an opportunity to move to a higher position at work and am facing a dilemma. Right now I do a little of both of these jobs, though I'm more focused on programming (which I really love doing). One of these jobs is more programming-oriented while the other is …

0
37
Member Avatar for timhysniu

Hi there, I am looking for a sharp database design tool. Take a look ad wikipedias db schema. Looks fantastically neat. Do you guys know what this tool is called? upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schema.png Visio has been good to me, but tables dont look look that sharp, doesnt export to sql scripts. mysql …

Member Avatar for timhysniu
0
118
Member Avatar for xen751

I have developed a database model for an organisation. This organisation has departments that do the same type of work so the schema I designed for one department is the same everywhere. But they are spread in different geographical locations. I have used PostgreSQL v8.2 as the back end and …

Member Avatar for debasisdas
0
66
Member Avatar for atal

Dear All, I have a [project] table which includes Project name,Startdate,EndDate,Location.and [SubContractor] table which includes id,subContractor_name. each project has one SubContractor at time and one SubContractor may have many projects at time. There are cases in which the first SubContractor leaves the project for some reasons and the company give …

Member Avatar for atal
0
126
Member Avatar for Jackson776688

Hey guys, I'm currently in the design stage of a database, and have a question of how the keys should be set up in two of my tables. I have an Orders table, which is related to a Customers table, and also to an Images table. The orders table has …

Member Avatar for debasisdas
0
89
Member Avatar for Falzz

Hi all, im fairly new to database design and would just like a few tips if this is done correctly or if i can improve it.. Im mainly designing a 'leave' application and have an issue with regards to design of two linking tables.. First Table - [Request] Username, DateStart, …

0
60
Member Avatar for doodad

Hey everybody, I just joined Dani because I am taking a database design course and I found this site on Google. I hope that I can find database design advice here because I am not sure what all I need to have as far as entities go. As a class …

Member Avatar for christina>you
0
46
Member Avatar for Caled

Hello, I'm developing a small, web-based music sharing application. I used to create static HTML contents. But now, I need a dynamic site that retrieve information from databases (also write data to database). As a beginner in PHP and MySQL, I hope someone from here can help me out.. Here …

Member Avatar for atplerry
0
95
Member Avatar for technobum

Hello all, I will be creating a mySQL database to store telemetry that will be grabbed from an instrument at a rate of once per second. Are there design considerations that I should take into account in order to achieve this insertion rate? The database will eventually grow to about …

0
48
Member Avatar for Juwar

I was wondering if anyone could offer a solution to this database design problem. I have very little experience with relational databases in Access. I have only used databases just to get easy data, but now it is starting to get complicated. I read a little on relational database design, …

Member Avatar for dhassen
0
99
Member Avatar for quintoncoert

is it possible to have global level methods in c#? I have several forms and they are going to use roughly similar logic. i can design methods which can work with them all depending on what parameters are passed to them but how do i make these methods global so …

Member Avatar for quintoncoert
0
138
Member Avatar for md_salman

Hello, my question is: Why do we have separate layers of classes when developing a web application. For example a DAO layer, DTO layer, business services layer etc.I mean why do we follow this approach. What's the purpose of having DTO layer, if its just transfer ot data we can …

Member Avatar for jwenting
0
80
Member Avatar for simward

Hi everyone, this is my first post here! I am making a small application that helps manage merchandise returns in a computer store I work for. I am currently designing the database for it and an issue has arose which is probably obvious but is eluding me right now. I …

Member Avatar for simward
0
174
Member Avatar for vijayoracle

Currently i am designing database for Portal. On Portal screen, There are some fields which are having multiselection facility e.g 1) professional is one of the field having 1)photographer 2)skydiving 3)painter 4)modeling are values, User can have more then one profession. Same type of 30 fields are available on single …

Member Avatar for sibir1us
0
100
Member Avatar for chris.jurado

There are some things that I am in a dilemna with about general database/table design issues. Each has its pros and cons. What do you think are the best practices? Here are some problems. 1. You have 2 tables (or sets of tables) that are exactly/almost exactly the same (in …

Member Avatar for pty
0
169
Member Avatar for debasisdas

Its really funny to introduce my self here in the forum. Even though I am a member of the forum for quiet a long time, I hardly post here in the forum. By the was I am Mr. Debasis Das . I work as an Sr. Software engineer in a …

Member Avatar for joshSCH
2
255
Member Avatar for claptrap

I am trying to learn about databases and at the moment starting to read general stuff about multidimensional database design. The trouble is, I don't even know the basics about databases, like what is natural key (same as primary key made of single components?) or surrogate key... Could anyone explain …

Member Avatar for claptrap
0
127
Member Avatar for kinggarden

Hi everybody: I'm trying to do the practices on the top of forum. I started from beginner's level. This time I will show you my solution to implement a simple database in C++. If you could give some advice on the following aspects or other, it would be so nice …

Member Avatar for Narue
0
207
Member Avatar for OzeTigerman

I'm an amateur web designer using Frontpage. I have a golf professional friend who wants me to design a web site for him and he wants a members area. Each member would have to login using their own user name and password and would then be able to access certain …

Member Avatar for GiorgosK
0
154
Member Avatar for kc0arf

Below are the thoughts from a computer professional who has spent the last 10 years supporting Mac, Windows, and Linux computers in a variety of network applications. By no means will this general tips section be exhaustive -- that is what a good book is all about. I am also …

Member Avatar for dragonlady9947
1
633
Member Avatar for cybuster

hi im just starting to design a database using adodc but I have a problem... can someone give me tip on how to create a search code for ADODC... thx in advance

Member Avatar for PVBert
0
2K
Member Avatar for modiagag

[COLOR=#000000]Good morning[/COLOR] [COLOR=#000000]In messages system i have table to store messages and another table to contain the links which the message is posted through [/COLOR] [COLOR=#000000]Now i want to delete a link but i don't want to delete the message sent through this link[/COLOR] [COLOR=#000000]The problem:[/COLOR] [COLOR=#000000]When displaying the message …

Member Avatar for matale
0
68
Member Avatar for gaurav1146

I want to create a database design where I want to keep all changes made to a database and the user could revert back to earlier versions. Let say there is a table user which has following values initially [code] Userid(Primary Key) FirstName LastUpdated 111 abc 17/05/'07 [/code] Now if …

Member Avatar for gaurav1146
0
141
Member Avatar for matale

Hi everyone, I am an IS student at The University of Cape Town, after completing my Course projects for the semester I have decided to do a small project just for fun and to teach myself new things. So I stumbled into this forum when looking for Database Design stuff.

Member Avatar for eXceed69
2
66
Member Avatar for Mef0

Hi - I am using Access 2002 (Office XP) I am trying to design a database to use in my business. I have created the following tables: Suppliers, Products, Salespersons, Locations(where the products are sold). I now want to input sales info. I need to input Daily Sales for each …

Member Avatar for DenisOxon
0
226
Member Avatar for mybellame

Could not create; no modify design permission for table or query. I recently added user and group accounts to my database. I set my account with admin priviledges. I have full permissions on all tables, queries, forms and reports. I get the above stated error when I try to create …

0
64
Member Avatar for DangerM0use

Hey all, I'm really struggling with the first part of my database design assignment for uni and I don't know why as I am repeating the year and did well in the subject last year and also did it at college. But enough of the background, let me explain my …

Member Avatar for matale
0
73
Member Avatar for octogon

Hello everyone, I am currently developing an excursion booking system and I am looking for some advice on some matters of database design. At the moment I have the following tables in my system : a table 'user' which holds information such as : login,password,firstname,lastname,address,... Q: is it better design …

Member Avatar for jbennet
0
84

The End.