1,065 Topics

Member Avatar for
Member Avatar for BeEasy

Hi I'am doing an online cinema ticket reservation system and i have face a problem with the database design i have these entities: Movie, Branch, Hall, Seat, Admin and customer there is a relationship between the admin and all other entities except the customer which is the admin can add …

Member Avatar for timothybard
0
132
Member Avatar for jsully1

I am taking a web design and development class and we have been thrown into MySQL along with java without much knowledge beforehand. Was wondering if anyone could help me with understanding how to query the database and update entries, as I am confused on how to accomplish this. I …

Member Avatar for jsully1
0
105
Member Avatar for EnderX

I'm having to redesign a web-based data-entry page; as I had the original set up, it would have caused a high degree of duplicated information in the database I am working with. The original design called for a single form, in which a given set of data would be specified. …

Member Avatar for dsrtprwlr
0
143
Member Avatar for suej68

Hi I have been looking after my companies intranet and internet for 12mths now, and have managed to wrangle most of the everyday problems - through dedication and search functions on internet, even managed the most basic of web design courses (focussed mainly on CSS). I was employed as a …

Member Avatar for peter_budo
0
158
Member Avatar for crprajan

I am new to layered architecture design. I need to implement a record navigation form in c# windows. It will contain three textboxes one for entering the empname and another for entering empage and another for entering his dateofbirth. I have buttons for adding, deleting and editing the current record. …

Member Avatar for dickersonka
0
117
Member Avatar for jemagee

I'm trying to wrap my head around a database that will maintain 'box scores' for sporting events and be searchable on a various amount of fields including how a player performs home and away and in wins losses. I can't figure out how to design the tables properly for the …

Member Avatar for timothybard
0
156
Member Avatar for csgraham74

im in the process of looking at a reporting tool for my database system - can anyone point me in the right direction for the best product available. i previously used crystal a very long time ago (it may be called something else by now) but ive read alot about …

0
62
Member Avatar for dreamer_0244

I am currently working on this table. It will contain the transactions made. But the transaction varies, it may be a purchase order, transfer from inventory, rental, etc. I have different IDs for each type of transaction (e.g POID, TFID, RENTALID). My question is, should I place all of this …

Member Avatar for dreamer_0244
0
112
Member Avatar for nish88

hi all, i am doing my school project where the user can upload picture and store it in the database. actually like on web page when you are uploading picture you get a window with a browse button. i want to do something similar in ms access 2003. i have …

Member Avatar for debasisdas
0
94
Member Avatar for cosmicfool

Hello, I've just migrated a website built with asp and MsSQL to a new server. The old server used MsSQL 2000 nd the new one uses MsSQL 2005. I know the database became slightly corrupted when it was uploaded. I was just wondering if anyone could tell whether the varchar …

Member Avatar for cosmicfool
0
256
Member Avatar for goodmuyis

hello my dear am sorry to give this disturbance, i need a full cup of help am thirsty. i design a database application with c++ and access, when i test on my PC it work fine but on others PC it can find settings of ODBC what can do to …

Member Avatar for mcriscolo
0
81
Member Avatar for Anthraxnz

sorry if this is a dumb FAQ type question, but i have been searching all morning for a answer. Heres the setup. I have an Oracle 10g DB outputting Relational Tables into XML. heres an example out some output. [code]<?xml version = '1.0' encoding="ISO-8859-1"?> <?xml-stylesheet href="blog.xsl" type="text/xsl"?> <ROWSET> <ROW num="1"> …

0
64
Member Avatar for hbmarar

I had written a algorithm, that gets executed daily. it does the following. Make use of 4 auxillary tables , A,B,C,D. Reads from the other database tables, using few rates and updates or populates ranks and order in A,B,C, D. Once this is done, it enters a fixed iteration loop. …

0
65
Member Avatar for martingavin21

Hi all, I'm an absolute newbie on the site, first ever post! I have been scratching my head for a while now so hopefully one of you DB pro's will be ableto help me :) I have a friend that has asked me to design a database for his small …

Member Avatar for darkagn
0
95
Member Avatar for ashamsa

We are working on an application that caters to a group of institutes. With the current database architecture each institute has its own database, with the same structure but data is different. But there has to be a common database that has some data which need not be repeated in …

Member Avatar for timothybard
0
142
Member Avatar for choc.ohloic

I have an ER model which i need to convert into a relational database design. Can someone please let me know if i am on the right track? Also how do i represent a foriegn Key, do i use italics, and for prinary key underline? I have attached the ER …

Member Avatar for timothybard
0
184
Member Avatar for namratashukla

i want to design a database for cricket game where players will be selecting their players and while live cricket is goin on i want all user data base to get updated when the specefic player in his team hits.so i just want to know how to do this updation …

Member Avatar for nikesh.yadav
0
110
Member Avatar for RockabillyJim

I have two tables with foreign keys to the same parent table and a junction table between them to map a many to many relationship. I want to know how best to enforce data integrity in the junction table so that both parents' parent is the same. Example: [code=sql] CREATE …

Member Avatar for dickersonka
0
116
Member Avatar for asdengler

I'm working with Visual Studio.net and Access 2002 to build an interface to add, edit and delete records in the database. Eventually, I'd like to build a web page to be able to view the data. Currently, I'm trying to search for a particular record in the database using a …

Member Avatar for asdengler
0
296
Member Avatar for bdicasa

Hello all, I have a fairly good grasp on how to design a database (took a couple courses on it) but I'm not sure how to set up a database for use with a website. My plan is to develop the website with ASP.NET and MySQL. The website will have …

Member Avatar for dickersonka
0
116
Member Avatar for dharam_05

Hi i want need to fetch sec highest marks from given tables. my database design is like: My database design: Table 1: Student table (PK)Stud_id, Stud_name Table 2: Subject table (pk)Sub_id, Sub_name, Marks. Table 3: Stud_Sub table Stud_id, Sub_id And i come up with the query: Select Student.stud_id, Student.stud_name Max( …

Member Avatar for dharam_05
0
370
Member Avatar for InterLude

Just wanted to say hello. I live in Sugar Hill, Georgia (USA). I have about 15 years of IT experience in the areas of Project Management, Technical Support and Database Management. I have formal training and certifications from/in Oracle, Microsoft, CIW, Sun Microsystems, Dale Carnagie and CompTIA. With all that …

Member Avatar for sittas87
0
85
Member Avatar for spud49

I've just joined Dani Web - I work in the computer industery but all my knowledge is hardware based. i am, Secretary of a Cricket league and I want to arrange/design a database for Player Registration to ensure that each player for each team will have a unique ID number …

Member Avatar for sittas87
0
62
Member Avatar for Grimslaw

Hi All Thanks in advance for any advice. In the data centric application that I am currently working on, I have a requirement to create a database on the client machine. I understand the whole process of creating the database (tables, sprocs etc), but what I cant seem to figure …

0
45
Member Avatar for JeremyNZ

Hi There. I'm just hoping someone can answer a question for me, as although i have been a IT Network Administrator for a long time, I know very little about web design/database design. I'm currently in the process of setting up a website to will contain a very large amount …

Member Avatar for whatanidea
0
96
Member Avatar for peter_budo

After spending some time on JSP section of this forum as many before me, I come to the conclusion that we are in need of "proper" tutorial on this topic. This tutorial is not intended to teach you everything from top to bottom, it is just a starting point to …

16
8K
Member Avatar for palavi

hi all,can anybody point out wats wrong in my database design, guide me right database ,i ve 4 tables i type all its attributes its for hospital database patient table pid, pfname, plname, pcontactno, page, pplace ,pdocname, pprob ,ptype(this is for out patient,inpatient), pbill. doctor table docid ,docname, docplace ,doccontactno …

Member Avatar for palavi
0
105
Member Avatar for Traicey

Guys Im not sure If I should post this in this forum but anyways If it shouldnt be here please pardon me I have a problem here, I have to design and develop a software for Clothing company which sells clothes, either use account, cash, credit exchange, returns and so …

Member Avatar for mike_g
0
112
Member Avatar for acchao

Hey, So I'm about to drop a bombshell. I pretty much know that most of this content is fairly findable on the forums or just through google, but I'm having trouble finding consolidated and current info about where web dev/design is going. I'm basically building a website for a student …

Member Avatar for buddylee17
0
326
Member Avatar for MDGM

Hi all, I wasnt sure wether to put this in the web design forums or here because it contains a bit of both - im not sure if the concept is even possible but its very interesting, possibly difficult and longwinded but potentially very rewarding [B]First a bit of background …

0
72
Member Avatar for architact

Hello, I have designed a website which let the users create account and use our services, my client asked me to design a page which will show all the online members at that time, the solution i have figured out is that i have create a column in my user …

Member Avatar for scru
0
81
Member Avatar for iamlevicious

Hello, I am a graphic designer who does some web design on the side. The store I work at had a website that the boss wanted transferred to a different host. So I downloaded it off the server and uploaded it onto a new one. I knew that I was …

Member Avatar for pritaeas
0
106
Member Avatar for sammyboo85

Hi, my names are Samuel Ikumoinein, i am writing my final year project on Database Management System for Healthcare Solutions. I am now in the system design stage and i have no idea on what software i am going to use or a concrete structural design even though i already …

Member Avatar for sarehu
0
61
Member Avatar for dcahan

I'm working on what i consider to be one of the hardest DB designs i've ever had to do in my 10+ years of programming/design/architecture. I really need to bounce my ideas off on other experts but i'm having trouble finding the right forums. 1) is this a good forum? …

Member Avatar for kb.net
0
80
Member Avatar for Elmo_loves_you

Hi. I have previously designed an ASP.NET system that interacted with SQL Server 2005. I now want to design a desktop application using Visual Studio 2008 that interacts with an SQL database. I had planned to use the same sort of coding to implement this new system. For example - …

Member Avatar for Ramy Mahrous
0
163
Member Avatar for atplerry

Hello ! I am a student of a university i and we are group into different categories in executing a project. The Template of the project was design by our lecturer and they want us to read , interprete and edit a website written in php and was givien to …

Member Avatar for newbiecoderguy
0
584
Member Avatar for jynx_o7
Member Avatar for langsor
0
75
Member Avatar for dharam_05

I have to create database of student having different subjects and marks in respective subjects. Now many students will many subjects so there is many to many relationship. My database design: Table 1: Student table (PK)Stud_id, Stud_name Table 2: Subject table (FK)Stud_id, Sub_id, Sub_name, Marks. Table 3: Stud_Sub table Stud_id, …

Member Avatar for dharam_05
0
112
Member Avatar for andrew13d

hello people. I am extremely new to web design, I have read html quite alot I need yo help however to design a database for an inventory that is accessible over the internet. Can I use MS Excel or Access for the inventory database? Which scripting language of php and …

Member Avatar for langsor
0
136
Member Avatar for 2eXtreme

Hey Guys, I was hoping someone could help me with designing a database? Basically, I want to design a database that will hold a bunch of test cases. For those of you that don't know, a test case simply documents a test that is to be executed on an application. …

Member Avatar for 2eXtreme
0
133
Member Avatar for rich_m

My team( all freshers) are developing a project that will involve many Modules. I want to know if it is a good practice to have different databases for a single project!!! I know that this could lead to a bad design, if you make the wrong decisions of placing the …

Member Avatar for rich_m
0
101
Member Avatar for gmgfarrand

Well, A client brought in a PC LOADED with Viruses and Spyware. Anyhow after numerous scans with Avast! and Ad-Aware, I came here and ran the suggested apps. The problem that still lingers is that whenever I goto the Screensaver Tab, I get the DLL as an App error. Prior …

Member Avatar for gmgfarrand
0
310
Member Avatar for Draygon

I am not a expert in sql or php and I took this project on with some knowledge of both. I am having some trouble designing a database for a campaign I am working on for a game (a mod to a mod basically). In this database I have 5 …

Member Avatar for chaosprime
0
89
Member Avatar for Paua

Help me please; I want to create and insert a simple (manual) dropdownlist in gridview (visual studio 2008 +sql server 2005), ddl to read 1,2,3,4,5 etc. new to asp.net and nothing I've looked at makes sense so far. ps, not to sharp with c# either. if more detail required please …

Member Avatar for memafiaso
0
754
Member Avatar for chentiangemalc

Hi There Normally I'm not designing database but have the need to implement an internal questionaire system. 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, …

Member Avatar for peter_budo
0
90
Member Avatar for max2me99

I'm new to the scripting and database stuff, and am trying to learn the right way to do things. I've taken some video courses through SNIPPED, and have some background with html and css. I've seen some great help here, and thought I'd join up. Most of my background is …

Member Avatar for MakeMoneyOnline
0
39
Member Avatar for Lavendor

how do i access the database? i am using dreamweaver as my design interface. and using php for script / coding. thanku.

Member Avatar for Shanti C
0
90
Member Avatar for sindhu_dixit

I have a form which displays data retrieved from database in suppose first 10 feilds.There is an update button at the end of the 10th feild. My user can change the data in the feilds and update them.When user clicks the update button i want all the info to go …

0
68
Member Avatar for diyerxa

Hello, I'm an application developer (still in college though). I'm working on a little web project. I've thought over and researched how this could be done, and this is what I plan to do (however, I don't know if this goes against web programming best practices or if it's completely …

Member Avatar for diyerxa
0
195
Member Avatar for sushantlikhar

Hi , I have designed a database that is to create a application simlar to microsoft money The database erd is aattched with this post. The database has following table Invoice Amount Account Profit_center Customer A invoice can sometimes split in to 3 parts therefore i have create table invoice …

Member Avatar for sushantlikhar
0
143

The End.