Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

A company wants to store their invoices in a database. They
already have their customers and articles in that database.
Both customer and article are each identified by an unique
integer value. Please create the SQL statements for
creating the necessary table(s) for storing the invoices in
a MySQL database. An invoice should hold information like
invoice number, customer, date, article(s) and quantity
etc.

Question Posted / pranab


A company wants to store their invoices in a database. They already have their customers and artic..

Answer / frank

Assume existing tables for customer and article are:
customers
+------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+------------+----------+------+-----+---------+----------------+
| customerId | int(11) | NO | PRI | NULL |
auto_increment |
| customer | char(50) | NO | | NULL |
|
+------------+----------+------+-----+---------+----------------+

article:
+-----------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+----------------+
| articleId | int(11) | NO | PRI | NULL | auto_increment |
| article | char(50) | NO | | NULL | |
+-----------+----------+------+-----+---------+----------------+

CREATE TABLE invoices (invoiceId INT AUTO_INCREMENT PRIMARY
KEY,customerId INT NOT NULL,articleId INT NOT
NULL,invoiceNumber CHAR(20) NOT NULL UNIQUE,invoiceDate DATE
NOT NULL,quantity INT NOT
NULL,INDEX(customerId),INDEX(articleId));

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More MySQL Interview Questions

Is there a way to see the files which are stored?

0 Answers  

Is mysql same as sql?

0 Answers  

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,

What are the steps required to view your mysql database?

0 Answers  

Is microsoft sql same as mysql?

0 Answers  

What is mvcc in mysql?

0 Answers  

How can you filter the duplicate data while retrieving records from the table?

0 Answers  

What is mysql and how it works?

0 Answers  

How many types of indexes are there in mysql?

0 Answers  

How triggers can be used in mysql?

0 Answers  

ru compare the 2 null values?

2 Answers   ACC,

What is a trigger in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories