30 Topics
 | |
 | A script that was working fine on 100 records per batch choked when I fed it 1,000 records. It gave: mysql.connector.errors.OperationalError: 1040 (08004): Too many connections So I went ahead and made sure to connect.close() everywhere that I opened a connection, and the script made it much further but eventually …  |
| | Project Preparation. Business Blueprint. Realization  |
| | An equipment company wishes to create a database to support the hiring of tools and machinery to clients. The company has three types of equipment: power tools, such as drills and vacuum cleaners, plants such as excavators and scaffolding. Each piece of equipment is identified by a number. Power tools …  |
 | I am working on a table that will hold batch data. The table will have a BatchDate column as a DateTime type. I'm considering adding a column for BatchYear as an integer and BatchPeriod (which could be a week number, a month number or a quarter number) as an integer, … |
| | Hi, I am developing a mobile app for a health care institution. I'd like to get a suggestion on how to approach my database design. There are many user types of this app; residents, nurse, and general-staff. The "resident" has many information that other types don't have; unit_number, food_allergy, emergency_contact, … |
| | **Bold Text Here**Hi there I'm just wondering what the best or a good table layout would be for a little project I'm trying to do at work. I work at a temp to perm agency where companies use us for the probationary peroid of employement and then hire the workers …  |
| | Hi everybodies! How increase ProductId inside Product_Table when insert a new product according to following approach? Language_Table: Id Code --------- --------- 1 ka 2 en Product_Table: ProductId ------------- 1 2 Product_Translation_Table: TranslationId Title ProductId LanguageId -------------- ------------------- ------------- ------------ 1 Kompiuteruli 1 1 2 Computer 1 2 3 Radio 2 …  |
| | Hi there, I am a bit lost right now and would like to get some advice/direction on how to proceed. I have to design an implement a database for a Car Repair shop and the specs are listed below: An owner may have more than one car. The business has … |
| | Hi, I am Shoaib. I have an project for my database course. I have chosen Dmoz directory listing(easiest project). I have to design the database first. [B]Please can someone tell me where I will start? [/B] I will appreciate any clue or hints. |
| | Hi, I am just trying to normalize these data here: An initial call is logged by a first line support analyst who assesses the severity of the problem and places the call in a pool. The call is picked up by a problem analyst who in turn allocates it to …  |
| | Hey guys, Well I had a few questions, so I have an employee Database with id,fname,lname,dep and I wasn't sure if I should do and Employee class whit constructor and what not, and make the class read the information form the Database and then create and ArrayList<employee> and fill it …  |
| | Can anyone help me with the database structure of a personal finance application? |
| | Hey Guys, Iam John and a newbie.. Iam building a database to store the business rules in the database. For example the following expression Expression=(a=5 or b>6) and (c<7 or d=0) will be stored in the database as follows: Rule ----------------------------------------- RuleId |LHSCode | Operator | RHSValue ------------------------------------------ R1 a … |
| | Hi Guys, I'm new to ASP.NET MVC, so please pardon me if I mentioned wrong terminology on my question I'm trying to create an application for a soccer related application. Right now I'm trying to design database/class structure for my application. However I run into a problem when I'm trying … |
| | Hello would anyone be able to help me to understand how the following answer is derived? Given R < A= {V,W,X,Y,Z}, [CODE]Gamma = {V -> Y, YW -> Z Y -> W}> [/CODE] RTP VWY -> Z and VXY ->Z Answer: augment 3 by Y Y -> W Thank you |
| | Hello Can someone please help me with getting a better understanding of dependency theory using Armstrong's Axioms? Thank you |
| | Hi All, After searching the web and this specific forum I can't seem to find a suitable solution to my problem and after hours of thinking I wasn't able to come up with a solution that will fit the problem. This is the case: I need a database model that … |
| | I would like some help on this database design I need to have completed by next week. Here's the specs: I'm creating a custom PC builder application. I've been getting stuck on trying to create the database for it. I would like to be able to enter customer details then …  |
| | Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have: [B][U]Customer Table[/U][/B] CustId(pk) Cust Name Cust Address Cust Postcode Cust Email [B][U]Order Table [/U][/B] OrderID (pk) Order Date_Time CustID(fk) [B][U]OrderDetails[/U][/B] DetailsID(pk) Quantity OrderNo(fk) DeliveryID(fk) [B][U]Product[/U][/B] ProductID(pk) ProductType ProductDescription DetailsID(fk) PartID(fk) … |
| | Guys... i need a database design on hotel search engine.....can anybody help me???? only searching for hotel(not restaurants) no hotel booking. its like justdial.com just a find hotel near u......please help me...... thanks.... |
| | hi guys, thanks for viewing my thread. Being in oracle for database administration is something awesome. I would like to know on how a bulk of documents in .txt file could be cluster using oracle 10g. The documents all are report which are contain Speaker Name , Report ID , … |
| | I'm building a local database with VS.Net, using C#. I have constructed the database and filled it with data. I've already been through the process of connecting to the \bin copy of the Db and setting the file to "Do Not Copy". Now, I want to design Views in the … |
| | Hi! I do have this assignment I have been working on for a while. My lecturer told us that we can produce few different EER models for this assignment and I would like to share with you my point of view at this problem and get as many other ideas … |
| | So, a single user application, all data is local, no remote access .... If a go with an Access file (DB), from the user's perspective, they simply install the app and they are good to go. Is it the same if I go with a SQL DB, or do they … |
| | I'm designing a new database and I'm hoping for some advice or recommended reading...basically just where you think I should go from here. The database is for holding contact information. The contacts are of various sorts for our business: customers, friends, colleagues, contributors, etc. We want to use the database … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | Hi, I designed this ERD for a small social networking website (1-2 million user), and I would love to get experts feedback on the initial design [url]http://www.seegh.com/erd.png[/url] Thanks In Advance Regards. Yehia A.Salam |
The End.