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

1648

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

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

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

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

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

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

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

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

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics