Show the records of depositor tables

Assignment Help Database Management System

Reference no: EM13821846

DATABASE MANAGEMENT SYSTEM

Create 2 tables customer with fields customer_id, customer_name, customer_street, customer_city and depositor customer_id, account_number, balance Set relation between the two tables:
Perform the following query:
1) Show the records of depositor tables?
2) Show customer_id, customer_street, account_number, balance whose customer_id is between c00001 and c00002?
3) Show depositor table whose customer_street is 'mg-road'?

Reference no: EM13821846

Questions Cloud

Type of production layout formats suitable for small batches : The type of production layout formats suitable for small batches and large variety of products is which of the following? finally the computer is safely packed and labeled for shipping. Time taken = 1 hour. If there are 8 available work hours each da..

Create a culture that thrives on team building : Imagine you have just been promoted to be the president of your company. You are tasked to create a culture that thrives on team building

Risk management and quality management in health care : Decision-making process document. Summary of how the scenario might apply to your chosen organization. Information needed and the most appropriate tools for responding to the scenario

Company opted to pursue strategy of related diversification : If your company opted to pursue a strategy of related diversification, what industries or product categories could it diversify into that would allow it to achieve economies of scope? Name at least two or three such industries or product categories, ..

Show the records of depositor tables : Create 2 tables customer with fields customer_id, customer_name, customer_street, customer_city and depositor customer_id, account_number, balance Set relation between the two tables: Perform the following query: 1) Show the records of depositor tabl..

How the governments response to this crisis : Prepare a two page response on how the governments response to this crisis and your thoughts on Mr. Gettridge and the various crisis he has to overcome.

Write research paper about music : Write research paper about music. How does the repertoire you've chosen relate to issues of race, class, gender, sexuality, or other definers of identity

Role played by operations manager-addressing service quality : Which of the following is not a role played by an operations manager when addressing service quality?

Identify the principles of cross-cultural communication : Identify the principles of cross-cultural communication.

User Account

All Pages