Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer all the following questions: Explain the meaning of data Model? Differentiate between the types of data model? Differentiate some of the advantages and disadvantages

Answer all the following questions:
Explain the meaning of data Model?
Differentiate between the types of data model?
Differentiate some of the advantages and disadvantages of file processing systems?
Explain three of the advantages of the database approach?
Write a SQL statement to prepare a list with salesman name, customer name and their cities for the salesmen and customer who belongs to the same city.
salesman_id
name
city
commission
5001
Ahmed
Amman
0.15
5002
Ali
Cairo
0.13
5005
Kamel
Algeria
0.11
5006
Seko
Nigeria
0.14
5007
Ruzaima
Kuala lumpur
0.13
5003
Putri
Shah alam
0.12
customer_id cust_name city grade salesman_id
3002 Nick Rimando New York 1005001
3007 Brad Davis New York 2005001
3005 Graham Zusi California 2005002
3008 Julian Green London 3005002

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Please make it fast 5 5 1 .

Answered: 1 week ago