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, even though both of these values can be derived from the BatchDate and using another column in the table. I'm considering doing this because I'm thinking it would be easier to work with queries where someone doesn't have to pull the date from the table first, compute the period they …

Member Avatar
Member Avatar
+0 forum 3

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, next_kin_name, next_kin_phone, emergency_doctor, nurse_in_charge, medications. The "nurse" has distinct information than others; working days, shift, patients, qualifications, etc. The "general-staff" has; department identifier (clinic, store location) I have put common attributes in one table ("user_table"), such as; id(pk), name, phone no, date of birth, address. *My question is, how do …

Member Avatar
Member Avatar
+0 forum 3

**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 on once they have completed the necessary amount of hours at their facility. So I'm trying to set up an online application signup and management system for our jobs and employees. So basically we have many employees and many jobs and I'd like to store information about each employee and …

Member Avatar
Member Avatar
+0 forum 5

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 1 4 Radio 2 2

Member Avatar
Member Avatar
+0 forum 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 a maximum number of 10 cars that can be serviced at any one time. If a customer arrives and the shop is full, they are told to return later. Each type of car repair costs the same amount per hour, but different repairs take differing amounts of time. Owners will …

Member Avatar
+0 forum 0

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
Member Avatar
+0 forum 4

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 a specialist analyst based on their expertise, who will endeavour to provide a solution. This process is overseen by a support manager. Problems are allocated in order of severity followed by date and time of submission (i.e. first in, first out). During its lifetime, a call is classified as:- i. …

Member Avatar
Member Avatar
+0 forum 1

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 up and have my Table java read from my class with the arraylist or should I just fill up the table directly from the returned queries. I really dont know to do the last part, but i have done various little projects with Arraylist<Type> and things like that. Do you'll …

Member Avatar
Member Avatar
+0 forum 5

Can anyone help me with the database structure of a personal finance application?

Member Avatar
Member Avatar
+0 forum 5

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 = 5 R2 b > 6 R3 c < 7 R4 d = 0 ------------------------------------------ Rule Group -------------------------------------- RuleGroupId | RuleGroupDescrip -------------------------------------- G1 R1 or R2 G2 R3 or R4 G3 (R1 or R2) and (R3 or R4) ---------------------------------------- Rule Group Relation_1 -------------------------------------------------------------- RuleGrRelId |RuleGroupId|RuleId|RuleJoinOperator|RuleSeqNo -------------------------------------------------------------- 1 G1 R1 or …

Member Avatar
Member Avatar
+0 forum 2

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 to define an appropriate class structure/business logic to represent a soccer match. On every match 2 teams commonly play, and each team has different attributes (e.g. numbers of red cards, yellow cards and goals it receives), My question is how could you or would you define that business rule in …

Member Avatar
+0 forum 0

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

Member Avatar
+0 forum 0

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

Member Avatar
Member Avatar
+0 forum 2

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 will support a price list system for determining the price for a given article with there specific properties and suppliers. The article group defines the set of properties for there underlying articles. Here is my biggest problem. Each article group contains a other set of properties. The properties are the …

Member Avatar
Member Avatar
+0 forum 2

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 select from drop down menu's each part in each category for a complete computer system. [URL="http://i53.tinypic.com/a0e4o3.png"]http://i53.tinypic.com/a0e4o3.png[/URL] There is a screenshot of my first shot at designing the database in SQL Server 2008. I'm a little bit confused as to what to do with the associative table and what to do …

Member Avatar
Member Avatar
+0 forum 3

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) Price VatID(fk) [B][U]Part[/U][/B] PartID(pk) PartName PartDescription SupplierID(fk) [B][U]Vat Table[/U][/B] VatID(pk) VatRate [B][U]Inventory[/U][/B] InventoryID(pk) Inventory Quantity PartID(fk) [B][U]Supplier[/U][/B] SupplierID(pk) Supplier Name Supplier Address Supplier PostCode Supplier TelNo Supplier VatNo [B][U]Delivery Table[/U][/B] DeliveryID(pk) DeliveryDate Help would be gratefully appreciated!

Member Avatar
Member Avatar
+0 forum 2

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
Member Avatar
+0 forum 3

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 , date and the speech. Thus i build a search engine to search for the document in database by cluster it into a speaker. Anyone got any idea for clustering the document in Oracle database and how i should associated with my .jsp page. I am using java programming, .jsp as …

Member Avatar
+0 forum 0

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 Database Connection. I've designed a view and the Sql string validated OK. But, when I execute sql, no data shows in the table, either at design time or runtime. Have I neglected something?

Member Avatar
Member Avatar
+0 forum 4

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 and critical answers on what am I doing wrong. Here is the scenario: A cruise company has an existing database system to deal with bookings, but in the light of security issues around some of the ports at which it calls, it needs to record and track more details of …

Member Avatar
+0 forum 0

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 have to have SQL or SQL Express installed? I ask because I'd rather go with a SQL simply because the potential for exceeding the 4GB limitation of Access is a remote possibility. However, I know if I require my mates to install SQL or SQL Express ... many will pass …

Member Avatar
Member Avatar
+0 forum 2

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 for searching for particular contacts and their information or pulling together lists for sending out e-mails and snail-mail. For example, we might want to pull a list of all of the contributors to send them an email about a new project. Do you know of any good example databases I …

Member Avatar
Member Avatar
+0 forum 1

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 how do i structure this dates so that i don't have to many lines in tables and redundancy. As i made it for now i would have to many lines in Products table, a row for each component_id of a product_id; maybe a can reduce this with some db structure …

Member Avatar
Member Avatar
+0 forum 1

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 be two tables in the database : "countries" and "users," with "users.country_id" being a foreign key to the "countries" table (one-to-many). The initial database will be empty. Users from all over the world will submit their names and the countries they live in and eventually the "countries" table will get …

Member Avatar
Member Avatar
+0 forum 3

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 dealer; ABC services and repairs only SILENT cars. Three ABC Car Service & Repair Centers provide service and repair for the entire state. Each of the three centers is independently managed and operated by a shop manager, a receptionist, and at least eight mechanics. Each center maintains a fully stocked …

Member Avatar
Member Avatar
+0 forum 7

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 use DDL statements to CREATE a Database TABLE for every new form created? Or Is there any other solution to allow user to design the schema (edit) using the website? Or should I opt for using schema-less database (to which am not familiar with)? Thanks in advance.. waiting for your …

Member Avatar
Member Avatar
+0 forum 3

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

Member Avatar
+0 forum 0

The End.