bigakis

Hi All, I am going to write a small inventory tracking app for a small company. What they need is only to keep track goods in, goods out, supplier, customer, and purchase price and sell price so we are able to calculate purchase price, sales price, and stock value. [LIST=1] …

Dear Friends I have created the attached database for hotel reservation system and I don’t know if it is correct or there is something wrong with it. I would be very grateful if someone could have a look at it and give me some feedback on it. If there is …

Hello, i am just a beginner,i have no idea on what system should i have to start. Right now, i only think as Hotel Management System, will anybody help on how to start it?Thank you ahead.

Hi all, i have a table, it will store millions of rows, corresponding to raw byte sequences from many sources. I´m thinking on using for primary key two options: 1- Columns: (source_id, date, data) and PK = (source_id, date) 2- Columns: (id, date, data) and PK = (id) The sources …

hi friends i do organization schema for my company. i make a simple design of org. sch. like ; organization_schema=> org_job_ıd ,bigger_org_job_id,job_id(for example more than one department have computer enginner) job=>job_id,job_name and also employees have relation with organization_schema than my problem is i need to history of organization_schema for it …

Hi I am designing a database for a local garage which sales and repair cars, I have come up with attached ERD diagram could anyone give me any advice on it and let me know if there is something wrong with it. Thanks for your help. Kind Regards HB 25

Hello, I am trying to run my tables in the Sql Workshop using the Sql Commands option in Oracle, and I get this error - "ORA-00922: missing or invalid option". I read that this is somehow related to the NOT NULL option, but I think this is how my table …

I'm trying to create a simple advertisment booking system for a community newspaper. The paper is published (printed) every two weeks and relies on local small businesses taking out small ads. We want to keep track of all of our customers, and their bookings both past and future. Each issue …

Hello everybody, I am designing a table for products. The products belong to one of three classes a, b and c. Each class specifies a price (for products). I need to design the tables such that changing the price of products will only require changing the price in the class …

Hi there, I need to normalize the following structure: Wall covering wood (category) (Product)-----(Models)-----(Prices)(Measurement) Log Cabin-----5/4 x 6------1.85$/square foot-----0.80$/linear foot Log Cabin-----2 x 8--------3.00$/square foot-----1.50$/linear foot Log Cabin-----2 1/2 x 8----6.50$/square foot-----3.50$/linear foot Doors (category) (Product)------(Models)-----(Prices) Panel Door------18"----------85$ Panel Door------24"----------90$ Panel Door------26"----------95$ Panel Door------28"----------100$ Panel Door------30"----------105$ Tables (category) (Product)-------(Models)--------Not peinted-----Waxed----Lacquered …