Please prove detailly answers for the questions blew, thank you very much. 1. Co
ID: 3741877 • Letter: P
Question
Please prove detailly answers for the questions blew, thank you very much.
1. Consider these types of local businesses, and their individual system needs, that could be near or in your area of residence.
• Inez’s Imports: inventory management system
• Madison Marketing and Merchandise: sales ordering system
• Vermont Venues: concert ticket reservation system
Choose one of these business and comment on how that particular business would benefit by using a database system for their particular needs? What data tables do you think would be important for their database? What analytics can be performed with the database?
(2) The general tasks that are required to form an RDBMS solution include:
• preliminary consultancy
• requirements analysis
• system specification
• database design
• programming procedures
• testing
• implementation
• training
• continual maintenance
Consider being given the task of designing and implementing a database system that would track business credit memos, which are issued by the seller of goods or services to the buyer, reducing the amount that the buyer owes to the seller due perhaps to a change of terms for a prior invoice. A sample credit memo follows.
Choose one of the above tasks and comment on what occurs during the achievement of the task as far as the contribution of the task to the completion of the database project.
Credit Memo
Damen Delivery Services ( DDS )
Job
[Job description]
TO
Customer ID [ABC12345]
Date: [Enter date]
CREDIT NO. [100]
[Name]
[Company Name]
[Street Address]
[City, ST ZIP Code]
[Phone]
Quantity
Item #
Description
Unit Price
Line Total
Subtotal
Sales Tax
Total
Credit Memo
Damen Delivery Services ( DDS )
Job
[Job description]
TO
Customer ID [ABC12345]
Date: [Enter date]
CREDIT NO. [100]
[Name]
[Company Name]
[Street Address]
[City, ST ZIP Code]
[Phone]
Explanation / Answer
1-
Let us take the case of Vermont Venues: concert ticket reservation system-
Business uses database system as it helps to maintain-
Table that are important for there databases includes-
1.Table:Customer
id int(5) primary key auto-increment
name varchar(40)
email varchar(40)
pass varchar(12)
mobileno char(10)
address varchar(60)
2.Table:Concert_name
id int(5) primary key auto-increment
category char(4)
name varchar(100)
3.Table:Reservation
id int(4) primary key auto-increment
reservedDate date
reservedTime time
customer_id int(5) foreign key
show_id int(5) foreign key
4.Table:Show
id int(4) primary key auto-increment
showTime time
showDate date
concertId int(5) foreign key
Note- For other questions tobe answered please provide as seprate question.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.