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
- 4591 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 are the differences between mysql vs sql server?
How does mysql store data?
What is view in mysql?
How can you import tables from a sql file into a database by using the mysql client?
What is mysql port?
How to returns the columns and column information pertaining to the designated table.
What is mysql community edition?
How do you rename a table?
What is mysql database used for?
What are the advantages of mysql in comparison to oracle?
What is ibdata1?
How to show all tables with 'mysql'?
What is federated tables in mysql?
What is the difference between myisam dynamic and myisam static in mysql?
What mysql means?
