29 Topics

Member Avatar for
Member Avatar for peol
Member Avatar for Layla_4

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 …

Member Avatar for Dani
0
161
Member Avatar for zachattack05

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, …

Member Avatar for Dani
0
661
Member Avatar for ikel

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, …

Member Avatar for ikel
0
384
Member Avatar for ScottieF

**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 …

Member Avatar for JOSheaIV
0
232
Member Avatar for zooferic

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 …

Member Avatar for scarcella
0
273
Member Avatar for reighlo

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 …

0
91
Member Avatar for moneypro

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.

Member Avatar for moneypro
0
197
Member Avatar for gunnerone

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 …

Member Avatar for BitBlt
0
140
Member Avatar for pxndx

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 …

Member Avatar for Paul Norris
0
177
Member Avatar for magochi
Member Avatar for magochi
0
282
Member Avatar for contact_hk

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 …

Member Avatar for contact_hk
0
195
Member Avatar for amyiee

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 …

0
115
Member Avatar for kevin88

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

0
140
Member Avatar for kevin88

Hello Can someone please help me with getting a better understanding of dependency theory using Armstrong's Axioms? Thank you

Member Avatar for kevin88
0
145
Member Avatar for heinzel

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 …

Member Avatar for heinzel
0
131
Member Avatar for thejman82

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 …

Member Avatar for debasisdas
0
218
Member Avatar for carebear23

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) …

Member Avatar for Web Dev Rob
0
122
Member Avatar for ajuv_001

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....

Member Avatar for debasisdas
0
226
Member Avatar for javanerd21

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 , …

0
89
Member Avatar for ggbard

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 …

Member Avatar for ggbard
0
155
Member Avatar for Lennyrogal

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 …

0
120
Member Avatar for Zinderin

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 …

Member Avatar for Zinderin
0
165
Member Avatar for wes_solar

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 …

Member Avatar for griswolf
0
327
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
148
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
157
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 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
129
Member Avatar for yehiasalam

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

0
143

The End.