swenning

Hi, I am working on a Inventory & Billing Management System. I am having some problem with the design of some tables. The problems are as follows 1. I have a product table. Where I am storing the product details, but the problem is that each product have an unique …

Here is my code. INSERT INTO employees (1.Last_Name,2.First_Name,3.Title,4.Title_of_Courtesy5.,BD,6.Hire_Date,7.Address,8.City,9.State,10.Zip,11.Country,12.Extension,13.Notes,14. Reports_to,15.Photo); VALUES (1, 'Smith', 'Janet', 'Sales Manager', 'Mrs.', '12-30-1974', '08/05/2000', '123 My Street', 'canton', 'OH', '44720', 'USA', '4632', 'MBA from Ashland University', 'Andrew Fuller', 'No Photo Available Yet'); Here is error message...Msg 102, Level 15, State 1, Line 2 Incorrect syntax near …

Hi! I need help to design an structure and the relationship. I need to create 4 tables: REGION, SUBREGION, CITIES and COUNTRY and do the relationships I have this: Table: REGION [CODE]CREATE TABLE REGION( REGION VARCHAR(2), REGION_NAME VARCHAR(200), );[/CODE] Values: REGION REGION_NAME 1 Africa 2 Americas Table: SUBREGION [CODE]CREATE TABLE …

i need to start designing a hospital database ,where it includes the administration block,accounts,employeers,patients ,which software should i use