Search DaniWeb - db-design

DB design capturing mergers and acquisitions 14 Years Ago by NewJoizey …some feedback and some discussion from other DB pros about the viability of a DB design I came up with. The goal is… to create the DB back end to an application…org/Docs/AliasConsolidation.gif[/url] What bothers me about my design: It relies on a trigger to keep data integrity. … DB design for learning english words 13 Years Ago by jayanandan I am designing my own site to learn English words. Attached is the image of my DB design. Can some one suggest/direct me to design the DB more perfectly? High Performance DB design 12 Years Ago by VanHackman … hear your suggestions and advice regarding a problem of DB design in MySQL. The situation is that I need to… develop a DB design which brings High Performance under the following conditions: + …OF THE MAIN TABLE So, the question is what design/tuning strategies would work in order to generate the … Facility Booking System DB Design 14 Years Ago by S8831679G …'am having great trouble with the db design (MS SQL Express 2005)of a Facility Booking System DB Design and its urgent. Please help… Student marks systems DB design 13 Years Ago by tamsoft … to code student marks management so i came across to db i was confused. Please give idea to create such thing… reg number submitted. totally confused please help me to create DB design. if register number entered means marks should be entered after… Library Management System DB design 11 Years Ago by scratchwiz … is this, When user add to New Book to the DB, it stores with a qnuiqe Bookid which is going to… unique only for a one copy. Anu sugeestions for this DB design. Any reply will be warmly welcomed. :) need feedback on db design 16 Years Ago by drtanz Hi I have made a tentative db design for my system and would like some feedback on whether you think it is well constructed, it can be found here: [url]www.jpgalea.com/design.jpg[/url] Thanks Table design 6 Years Ago by ddanbe …](/attachments/small/1/ea03b9085fe045894414a3101f2d6b4b.png "align-left") My DB design skills are very low, I only know Mr. Codd is… Re: Database design 11 Years Ago by azareth i think it is more precise to say that DB Design is actually based from ER, but the number of DB that you are going to use/create must match with the number of DB indicated in your DFD .. this is as far as i can remember Re: Database design 11 Years Ago by rotten69 Since the DB Design is based on DFD, then it is true that the ER is based on DFD because the DB design is dependent on ER. Typical DB tamplate 13 Years Ago by 54uydf Hey, I think my DB has very standard parts and I don't …I wonder if there are some ready and widely used DB templates for what I need - My database is … add ALL the users of my web application in the DB design. I've got 4 types of users- Admin, manager… forums work, but I don't know what a forum DB looks like.. Should I do it like this? : tables… Testing of db schema 13 Years Ago by 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 sure it's right and ready. What's the best free software to use to test the structure quickly? Database design - subtypes and instances of an entity 17 Years Ago by temp12345 Right i have a problem or two with my db design which i will try to explain: 1 Player can have … that type field should not be there according to database design principles, correct. Is there a correct way of implementing subtypes… Question about how to design a parts location database 14 Years Ago by incomer First off, I am kind of new to database design, so please take that into account. I have a project … small by the way) to come up with a good db design for the locations of parts, considering that the parts are… how to Design this ERD right? 13 Years Ago by 54uydf I have 2 places I'm stuck on with my DB design.. 1************************************************************************** how to translate ERD that looks like this into … Re: Need suggestion on Inventory System database design 15 Years Ago by dotyell Though this ain't db design question I will help u out. When u make a transaction, subtract the transacted stock from the product. When doin' a stock take, simply, the product table will have the stock on hand. Re: Basic database design question 9 Years Ago by Benjamin_11 The best wsy to start your DB design is by answering two question: 1. How will the data … Re: Product DB 16 Years Ago by John_Blaze Yeah it's web application in which this is a small part. I'm just trying to think for a good DB design that is generic enough to be used in the future for many products. For example: Shirt red XL 1000 shirts 200 red 100 XL I want to break it out for max flexibility. Re: Help with database design? 15 Years Ago by almostbob I've only learned one thing about DB design store date and time as timestamps its a lot faster to compare numeric timestamps than text date/time stings Re: Database Design Question 7 Years Ago by TheFearful … something from your explanation? I'm not the best with DB design so discussions like this help me out a lot. Re: Insert to DB & View Results on Different Page 16 Years Ago by SheSaidImaPregy oh hmm, let me look at the db design again. I'll get back to you in a second. Re: Database Design 16 Years Ago by mcox2005 … easily ... but I know no way of doing that in DB Design Re: Best design for Many to Many relationship referencing a single table 15 Years Ago by pclfw No Ramy, just my comments on the DB design in this thread. Re: Inventory System Design? 12 Years Ago by andrew_onsite I have developed a DB design . Please have a look and let me know any questions.… Re: Direction requested 16 Years Ago by Taffd … a state or a country, so I might as well design the whole thing from the top down. I knew very… used a peachpit tutorial to learn about DB design & normalization and then planned the DB on paper. I needed tables for users… Re: how to get the tree structure from db 10 Years Ago by chaitu11 thanks for your response db design is ok.can you give me business logic for this example if u have..pl Re: Database design - two tables or one? 10 Years Ago by Stuugie If it were me I would create 2 tables and go with your second option. Normalization is important with regards to relational db design. Also, I really dont see how speed will be an issue with your example regarding 2 tables, I wouldnt be worried about that! My 2 pennies! working or not?need help 14 Years Ago by jingo1126 … to the operating system tmsg db ' ' ;design top most of the screen msg db 'Rodriguez File Manager Version 0….1.1 ' ;design second to the top followed by the rest cmsg db '__________________________C h o … One Huge Database vs. Many Identical Databases 15 Years Ago by gregrobbins … At this point we are at the database / application design phase. We are debating the following essential question: [B…[LIST] [*]Only one database to backup [*]simplifies application design in that queries to the database are always the same… [/LIST] We have had a fair bit of DB design experience for individual shops but have never had to do… Problems with a many-to-many insert 15 Years Ago by filch … receiving some great help and education as to how to design a relational database, I went on to try and create… trying ;-) So I have attached the dB design we had come up with during our previous design sessions, but I decided to simplify… out the many-to-many insert thing. So, the second dB diagram is what I am currently using. I have also…