Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 4510 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the date format in mysql?
what is constraints?
How many columns can a table have?
What does it mean to be case sensitive?
Is primary key auto increment?
What, if a table has one column defined as TIMESTAMP?
How can you plan the logshipping before processing?
What is procedure in mysql?
How do I start mysql in ubuntu?
What are the ways in which you can retrieve data in the result set of mysql using php?
How to include comments in sql statements?
Is mysql distributed?
How can we run batch mode in mysql?
What is a trigger in mysql?
If you wish to encrypt the username and password using php, how will you do that?
