Help for DB creation.

Bob Bedford

Taken this example for a web site (like eBay) Don't care about analyze, it's
just for the example.

- table article, is a general table containing the article description.
- table seller, all the datas about a seller.
- table announce, all the datas concerning an announce
- table bill, concerning the billing process

the entities:
- the seller may have 0 or N articles (0:n)
- the annouce has (and must have) only 1 article (1:1)
- the announce belong to 1 and must belong to 1 seller. (1:1)
- the article has (and must have) only 1 announce (1:1)
- every announce must have 1 or N bills (1:n)
- every bill belong (and must belong) to 1 announce (1:1)
- any other possible reference.

May somebody give me the script for creating this database with referential
integriry (MySql 4.0)

I've no tool to create this and don't know the syntax.

Please help.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Jul 19 '05 #1

Subscribe Post Reply

1649

by: James Hong | last post by:

Help please, I try to sending an email from my html page using the java applet. but it give error on most of the PC only very few work, what is the error i make the java applet show as below ...

Java

Online help creation for .NET app

by: | ov | last post by:

Hi, I have a .NET application and would like to create online help (maybe ..CHM file) from the XML documentation inside the sources. Does anyone knows how to do this ? Thanks,

.NET Framework

Help system for an Access 2000 app.

by: dixie | last post by:

I was wondering if there is a way of doing a simple help system with either viewing a page in a browser or looking at a definite page in a .pdf file when a help button was pushed on an Access...

Microsoft Access / VBA

Help creation

by: DBC User | last post by:

Hi Sharpies, I would like to create help screen like ms office, where the helps comeout as right panel. Can some help me point me to any documentation on C# to do this? Also I heard MS is...

C# / C Sharp

Help Creation

by: Dragon | last post by:

Hi, Could someone please recommend a good software to create help files? Also, if it possible to embed other files i.e. Excel, PDF etc, into CHM or HLP files? Thank you.

Visual Basic .NET

setup creation

by: Ankit Aneja | last post by:

Hi I have made a windows service in C#.Net Now I want to create a setup of this service http://www.codeproject.com/dotnet/simplewindowsservice.asp I read this article Now my service is also using...

C# / C Sharp

Help Creation in VS 2005

by: vul | last post by:

I'm using HTML Work Shop along with FrontPage for Help development for VB6 application. What is used for Help System creation for VB2005 application? The same tool, or there is something newer? ...

.NET Framework

Help Tool

by: vovan | last post by:

What tool is used for Help creation for VB 2005 application? Is still HTML Help Workshop? Or there is something newer? Thank you vovan

Visual Basic .NET

Help files

by: steve | last post by:

I would like to create help docs for an app I am writing. Is there any good information on how to do this somewhere? I searched on the Internet but not come up with much. I am not very keen on the...

C# / C Sharp

Help needed with Javascript Hide/Unhide

by: atencorps | last post by:

Hello I have the following code but need some help on it. The idea of the code is the main sections ie Service Management are viewable when the page is loaded and by clicking on the main...

Javascript

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Similar topics