1,065 Topics

Member Avatar for
Member Avatar for cchris

I'm in the beginning stages of writing (and learning as I go) a Python database app using SQLite. I have the db structure planned on paper, and I have the queries I'll need in mind, but before I start coding I want to fully test the db design to make …

Member Avatar for griswolf
0
298
Member Avatar for megaleagues

Hello, I'm new to the forum and have a question about a database design and the resulting relationships. I'm creating a database which (amongst other things) will hold fixtures for a sports league. I have the following two important tables: [B]FIXTURES[/B] fixture_id (KEY) home_team_id (FOREIGN) away_team_id (FOREIGN) [I]etc...[/I] [B]Teams[/B] team_id …

Member Avatar for megaleagues
0
88
Member Avatar for dyladalyla

hi all i have some confusion about actors in use case. im doing my final year project and now i have to write my thesis/documentation. of course for system design i need a use case. im developing a web based file encryption application with usage of TPM specification. TPM stand …

Member Avatar for RobertGrabe
0
578
Member Avatar for manoncloud9

Hi everyone, I've been charged with creating a complex database that includes all kinds of entities with common data elements including customers, users, vendors, shops, organizations, etc.. I've worked on databases with separate tables for each primary entity like (customer table, lead table, vendor table, user table, organization table). My …

Member Avatar for pclfw
0
107
Member Avatar for sasha_3

Hi everybody, I have made my ER diagram for my DB, but i want it optimized. The db should store date for something like in attached images. I thought about a Products table with attributes: some_primary_Key, product_id, component_id,... The number of component is stored in another table; the question is …

Member Avatar for drjohn
0
151
Member Avatar for c++2ndLanguage

Hi everyone, I am working on a project that requires me to write a program which given a single word will search a database of thousands of songs and will return the artist, title, and the context in which the word appears in the song. Each song has a SongId …

0
41
Member Avatar for smagee12

Hello, I am new to these forums. My name is Sean. I am currently getting my CIS degree at Tulane University here in New Orleans. . I want to program, especially object oriented programming. The CIS degree at my college has two paths you can take. One is the "traditional …

Member Avatar for jephthah
0
866
Member Avatar for sivak
Member Avatar for sivak
Member Avatar for dmw

I have an issue. Database design is not at all my forte' but I am being fasked by my boss to learn how, asap. My boss owns 15 small business's, everything from a small weekly Newspaper to an Electrical Service to a Marina. We really dont have any real database …

Member Avatar for markcaldwell
0
198
Member Avatar for Vincent80

Hello, I'm working on a website that will be based on user contributed data, submitted using a regular HTML form. To simplify my question, let's say that there will be two fields in the form: "User Name" and "Country" (this is just an example, not the actual site). There will …

Member Avatar for urtrivedi
0
160
Member Avatar for izagaren123

ok i am currently having a problem with my shopping basket. it works fine when you go to a product and select to add it to the basket, it shows on there and you can go back to shop by clicking on the products link and add as many items …

0
72
Member Avatar for deven_a76

Hi all, I need to design a database for the below requirement. SuperAdmin [Myself - Final Approval] | Admin [Client User for Approval] | User [ Client User for data Entry] How can I implement the following requirement. Kindly help. Dev.

Member Avatar for debasisdas
0
72
Member Avatar for hawkoftheeye

Hello. Im wondering if anybody can help me out on a problem I am having for my SQL class. I have been going round in circles for the last three hours and am about ready to give up. The brief asks that I design a query that performs a division …

Member Avatar for hawkoftheeye
0
181
Member Avatar for sporti711

I know this may seem simple to some of you, but I really need help. I think I have part 1 correct for the most part but I really need help with the 2nd part. [B]Part 1[/B] The ABC Car Service & Repair Centers are owned by the SILENT car …

Member Avatar for rmart
0
1K
Member Avatar for superbt

anyone can me that I'm using VB.net 2003 and crystal Report 9. Here is my DB structure: Server = server123 Database 1: TestDB1 table :users Server= server123 Database 2: TestDB2 table :users In the design time in crystal report , i used the connection which connect to TestDB1.users but in …

Member Avatar for udith85
0
135
Member Avatar for mahdoum

Hello everyone, I currently manage hosting for a number of customers and started created a system to manage the customers and their hosting accounts / domains. I have the following setup currently: Tables -Customers (Customer name and contact info) -Customer Accounts (An account links domains + hosting in one account) …

Member Avatar for asaukani
0
125
Member Avatar for miraclebos

Hello ! I'm working on a project which allows user to design forms/questionnaires using asp.net website, and once done. The questions should be generated on a .net mobile web page to be filled up using mobile phone browser. The question is - when designing the form is done, should I …

Member Avatar for miraclebos
0
132
Member Avatar for jme0509

My name is Jan and I'm new to the forum. I have a BBA in Management Information Systems and I currently work in IT within the Healthcare Industry. My specialties include Web application development, database design and development, and the financial side of Medical information systems. I also write code …

Member Avatar for Danielperez1
0
80
Member Avatar for griswolf

I'm re-designing a database that will facilitate registration at various events. One column in the event_person table describes the current status of the registrant. The forces that apply here are: - Various events may have different sets of status values - We may ship this as a framework to various …

0
91
Member Avatar for katties

I've got a situation with minibus repair database design, where it looks like in the Repair table I could do with a 3-composite primary key: jobID from the JobType table (types of maintenance with price and time), mechanicID (Mechanic table), minibusID(minibus table). This way, I've got type of job performed …

Member Avatar for katties
0
390
Member Avatar for octavia

Hi everyone, i'm new in VB.NET. I tried some sample program using Visual Studio .NET 2005. I just add new data source (which is MS Access file) to my VB Windows program. I used Data Source Windows to create database objects on the form. But after i debug, i can't …

Member Avatar for y2_sub
0
176
Member Avatar for Probose

I'm modeling a database for a competition website. Each tournament will have a even number of contestants, and they will be randomly assigned to a one vs one match. Each match winner will go for the next phase and compete against another match winner, until the tournament ends. I'm thinking …

0
48
Member Avatar for achalmehra

hi friends...i am developing a small windows application in vb.net using visual studio 2005. i want to design a form where user can enter multiple records.like we want to design a "bill" form where user can create the bill for any no of items.there are 4 colmns in it : …

Member Avatar for achalmehra
0
149
Member Avatar for Neo1969

Hi all, I'm new to PHP and am doing a project with a php generator called PHPRunner and I have a design of the database in which the first table is the master of the second, the second of the third and the third of the quarter as follows: Categories …

Member Avatar for Neo1969
0
1K
Member Avatar for Latent12

Hello all, I am trying to create a database using Microsoft Access based on the folowing scenario. However, before doing this, I am trying to figure out the logic and draw an ERD. The scenario is as follows: "The Meantime agency manages properties for rent in South East London. Clients …

Member Avatar for Latent12
0
139
Member Avatar for whitestream6

I've been trying to create a specialised CMS, as none of the current open-source ones fit my needs for this project. I'm trying to create a CMS for a TV/episode guide which is similar to this: [url]http://library.digiguide.com/lib/programmenextshowing/Police%2C+Camera%2C+Action!-12578[/url] (one such example) - where records expire and delete from the database after …

Member Avatar for whitestream6
0
123
Member Avatar for fingers25

Hi everyone, I'm trying to write an application in java, hibernate and struts...or maybe I might do it using PHP. I haven't decided yet. Btw, the application is to track communications I have with employment agencies and individuals relating to job applications I make. That's the easy bit :-) The …

0
66
Member Avatar for jascook

Hi all, I've uploaded my asp.net site to my ISP. It works fine locally on VWDE 2005, in that I can create users, assign them to roles, and control role access to website folders etc. Obviously this is all with SQL 2005 Express on my PC. When I upload it …

0
87
Member Avatar for andydeans

hi, i had a post in php re display a countdown for policy, it got side tracked to inserting the date properly into mysql database. that is now resolved. what i have is a database setup like this, and if anyone could tell me if this is wrong design before …

Member Avatar for andydeans
0
286
Member Avatar for Nazir Hussain

Hi, I have created a local SQL database using Visual Studio 2005 (not by SQL Server Management Studio), and located it in the same VB project folder: "E:\MyProject\MyDB.mdf". Now I'm trying to design reports using Crystal Reports 2008, but for SQL Server, it doesn't browse this DB created by visual …

Member Avatar for kvprajapati
0
105
Member Avatar for ero100@live.com

Hi every body, i really need to understand and get the answer for this question, can any one help me PLEASE?? In database design world, it is so common to find binary relationships of type 1:M. How is this implemented when relational schema is translated into relational data model? Also, …

0
57
Member Avatar for Hypermommy

Hi all, I'm stumped...everything on my page is happening twice. Every method is getting called twice. Any idea why something like this would happen? Markup of page: [CODE] <%@ Page Language="VB" AutoEventWireup="false" CodeFile="MatchActivitiesToReqs.aspx.vb" Inherits="ScoutingWithTheMouse.WebBrowser.Admin_MatchActivitiesToReqs" %> <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> <%@ Register Assembly="Telerik.Web.Design" Namespace="Telerik.Web.Design" TagPrefix="telerik" %> <!DOCTYPE html PUBLIC …

Member Avatar for Hypermommy
0
261
Member Avatar for ah.MirZan

Hello, currently I'm working on my institute project. i've got some problem with me float data, when i enter the basic salary at the time of adding new employee, its not saving into my output file [data.txt] also not shown up when i search. also i got same problem in …

Member Avatar for WaltP
0
241
Member Avatar for GowriJai

I have created a Cryatal Report and set its Access database(.mdb) during design time. I have imported the crystal report into VB.NET. now i want to know how can we set the database path during runtime. The database to which i've linked will change its path and name every year. …

Member Avatar for kacebaza
0
130
Member Avatar for Travel Tech

Howdy! I'm trying to get my head wrapped around normalization and it's not working out to well. I'm using datasheets from the general and primary election results of 2008. The data sheets have a lot of duplicate info in them and I understand that is what normalization is supposed to …

Member Avatar for drjohn
0
95
Member Avatar for mphanikanth

Hi There I'm wondering if anyone has examples of desigining a database for exams/etc? What I'm finding difficult is the need for multiple types of questions: 1. Multiple choice, one correct answer 2. Multiple choice, multiple correct answer 3. Text answer 4. Put items in the correct order answer I've …

0
62
Member Avatar for shbbys@live.com

I design A wed page in html. and An Access database. please show me how do I link them

0
67
Member Avatar for drakkar

hello everyone... i`m totally new to vb actually.now using vb express 2008.i`m currently trying to create log in function.basically, i`m already create database (database in vb 2008 itself) for login,which the login table contain 3 columns, Username, Password and Designation.example : [B][U]Username[/U][/B] -- [B][U]Password[/U][/B] -- [B][U]Designation[/U][/B] jack -- 123abc -- …

Member Avatar for drakkar
0
94
Member Avatar for awo

i am trying to simulate an alert for transaction being done on a bank account as my project but the person i asked to help me told me that using flexcube all i need is to execute the code below it would create a table OUTMESG which my own code. …

Member Avatar for debasisdas
0
307
Member Avatar for ukshir

Hi, I have a project developed in VB.NET 1.1 (using VS 2003). The project has forms developed using the DataForm wizard (Connecting to Access Database, having a dataset and couple of adapter as automatically generated through the wizard - See attached screenprint "Original Form In VS 2003.PNG"). I converted the …

Member Avatar for ukshir
0
346
Member Avatar for ronaldpaul

Friends, in my project(i'm using php and mysql & i'll be getting all the detail from th user) I've to create a seperate ID for each family. For each family I've to maintain the family members details and the contact details.Now wats the problem is how can I add or …

Member Avatar for urtrivedi
0
168
Member Avatar for Benzino

Hey, I'm totally new at database design, and can't for the life of me decide how to design my system. I have categories, which contain sub-categories, and in these sub-categories are items. For example: Wedding Music (category) ---> Bands(sub-category) ---> Awesome Band (item) What I'm trying to do is achieve …

Member Avatar for vee_liang
0
126
Member Avatar for divyakprabh

how to use database tags.?? what exactly is the use of it.?? In my database design i have a table called project_details which consists of many fields like its projectID, title, domain and technology. Each project can have many technologies involve in it.. so how do i make use of …

Member Avatar for divyakprabh
0
77
Member Avatar for VibhorG

I have made a window application using Visual Studio2008,C#,MS Access database. In my application there are three tables "country","state","person" .On the form,there are 2 comboboxes one for "country" and other is for selecting "state" , also a textbox for entering the name of a person for each country-state pair. Now …

Member Avatar for VibhorG
0
103
Member Avatar for Argo54325

Hello, I've been looking for information on creating a chat server and client application, just the basics that would include: 1. Connecting to the server. 2. Displaying a "friends list" (like windows live). 3. Open a private conversation with a friend on the list. 4. Send messages from users to …

Member Avatar for csmgsarma
0
168
Member Avatar for jateshs1007

Create a computer application to maintain the product inventory of a T-shirt distributor using a database. Each record will contain a T-shirt name, a price, and the quantity on hand. The inventory can manage a maximum of 30 different shirts. The database you implement should allow a user to add …

Member Avatar for WaltP
-1
245
Member Avatar for Satal Keto

Hi, I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends. I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea …

Member Avatar for kvprajapati
0
159
Member Avatar for Roivas

Hello, I've recently encountered the Antivirus Plus malware and have had trouble getting rid of it completely. Here's what I've done so far: First I did a system restore to a date before the malware appeared. The only remaining symptoms I could see were that IE and Firefox were still …

Member Avatar for jholland1964
0
281
Member Avatar for awo

I have a poor background in database design. i have only heard of distributed database once now i am meant to write a project on it(managing distributed database system) and also to create a sample application that manages a database for an organisation with distributed branches (making use of distributed …

Member Avatar for slyzius
-1
744

The End.