Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Kndily your support Answer all the following questions: Explain the meaning of data Model? Differentiate between the types of data model? Differentiate some of the

Kndily your support 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.
\table[[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,\table[[Kuala],[lumpur],[Shah alam]],0.12],[5003,Putri,0.13,]]
\table[[customer_id,cust_name,city,grade,salesman_id],[3002,Nick Rimando,New York,100,5001],[3007,Brad Davis,New York,200,5001],[3005,Graham Zusi,California,200,5002],[3008,Julian Green,London,300,5002]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Beginning Apache Cassandra Development

Authors: Vivek Mishra

1st Edition

1484201426, 9781484201428

More Books

Students also viewed these Databases questions

Question

Explain the need for remedial basic skills training programs

Answered: 1 week ago

Question

Describe a typical interpersonal skills training program

Answered: 1 week ago