1,065 Topics
![]() | |
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 … | |
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 … | |
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 … | |
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 … ![]() | |
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 … | |
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] … | |
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, … ![]() | |
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 | |
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 … | |
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 … | |
![]() | 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 … |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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, … | |
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 … | |
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 … | |
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 … | |
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, … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
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 | |
[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 … | |
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 … | |
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. | |
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 … | |
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 … | |
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 … | |
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 … |
The End.