Distinguish Primary key and foreign key with a suitable example. What are the difference between cross product and national join? Give examples using two relations. If two relations, \( A \) and \( B \) have 3 and 5 attributes and 8 and 20 records, respectively, how many rows (with how many column) are generated as the result of cross product and natural join? For the department relation, write down the SQL statement to list all the departments whose building name contains a substring "ECE" or "ece" and has exactly six characters in it. department(dept_name, building, budget) Why is it crucial to have database redundancy? Explain with an example For the following banking database schema: branch(branch_name, branch_city, assets) customer (customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (customer_name, loan_number ) account (account_number, branch_name, balance) depositor (customer_name, account_number) Write down an expression in the relational algebra for each of the following queries: - Find the names and assets of all branches located in "Jessore" city. - Find the names of all borrowers who have a loan in "Paltan" branch and amount greater than one million. - Find the names of all depositors who have an account with a value greater than \( 60,000 \). What are the main differences between delete from table and drop table. Consider the banking database schema as shown for Question \# \( \mathbf{2 b} \). Construct the following SQL queries for this relational database. - Find all customers of the bank who have both an account (with minimum balance of 100,000 ) and a loan (of amount 40,000 ). - Find the names of all customers who live on the same street and in the same city as "John". - Find out the maximum balance and average balance of all the branches
Added by Tanzia H.
Close
Step 1
Primary key and foreign key: A primary key is a unique identifier for each record in a table. It must contain a unique value for each row and cannot be null. A foreign key is a field (or collection of fields) in a table that refers to the primary key of another Show moreā¦
Show all steps
Your feedback will help us improve your experience
Sanchit Jain and 98 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
Acclaim Inc. makes two styles of trophies, basic and deluxe, and operates at capacity. Acclaim does large custom orders. Acclaim budgets to produce 10,000 basic trophies and 5,000 deluxe trophies. Manufacturing takes place in two production departments: forming and assembly. In the forming department, indirect manufacturing costs are accumulated in two cost pools, setup and general overhead. In the assembly department, all indirect manufacturing costs are accumulated in one general overhead cost pool. The basic trophies are formed in batches of 200 but because of the more intricate detail of the deluxe trophies, they are formed in batches of 50 . The controller has asked you to compare plant-wide, department, and activity-based cost allocation. 1. Calculate the budgeted unit cost of basic and deluxe trophies based on a single plant-wide overhead rate, if total overhead is allocated based on total direct costs. (Don't forget to include direct material and direct manufacturing labor cost in your unit cost calculation.) 2. Calculate the budgeted unit cost of basic and deluxe trophies based on departmental overhead rates, where forming department overhead costs are allocated based on direct manufacturing labor costs of the forming department and assembly department overhead costs are allocated based on total direct manufacturing labor costs of the assembly department. 3. Calculate the budgeted unit cost of basic and deluxe trophies if Acclaim allocates overhead costs in each department using activity-based costing, where setup costs are allocated based on number of batches and general overhead costs for each department are allocated based on direct manufacturing labor costs of each department. 4. Explain briefly why plant-wide, department, and activity-based costing systems show different costs for the basic and deluxe trophies. Which system would you recommend and why?
The 3 -tuples in a 3 -ary relation represent the following attributes of a student database: student ID number, name, phone number. a) Is student ID number likely to be a primary key? b) Is name likely to be a primary key? c) Is phone number likely to be a primary key?
Relations
n-ary Relations and Their Applications
The 5 -tuples in a 5 -ary relation represent these attributes of all people in the United States: name, Social Security number, street address, city, state. a) Determine a primary key for this relation. b) Under what conditions would (name, street address) be a composite key? c) Under what conditions would (name, street address, city) be a composite key?
Recommended Textbooks
Horngrenās Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Watch the video solution with this free unlock.
EMAIL
PASSWORD