SLSREP_FNAMESLSREP_INITIALSLSREP_EMAILCUSTOMERPK CUST NUMCUST_LNAMECUST_FNAMECUST_AREACODECUST_PHONECUST_E-MAILCUST_SHIP_ADDRESSCUST_SHIP_CITYCUST_SHIP_STATECUST_ZIP_CODEPK,FK1PKFK2HESALESREPINVOICEPK SLSREP NUMPKINV_NUMSLSREP_LNAME-It writes OFK1 CUST_NUMFK2 SLSREP_NUMINV_DATEINV_SUBTOTALIgeneratesINV_TAXINV_TOTALcontainsINV_LINEINV_NUMINV_LINE_NUMPROD_CODEINV_LINE_PRICEINV_LINE_QUANTINV_LINE_TOTALVENDORPK VEND_CODEVEND_NAMEVEND_CONTACTVEND_EMAILIsuppliesPRODUCTPK PROD_CODEis written in +1-FK1 VEND_CODEPROD_DESCRIPTIONPROD_PRICEPROD_QOH Q2. Add INSERT INTO statements to populate your database. Include at least 4 representativetuples in each table.

SQL stands for Structured Query Language. It can be used to create database schema, insert records…

SLSREP_FNAME SLSREP_INITIAL SLSREP_EMAIL CUSTOMER PK CUST NUM CUST_LNAME CUST_FNAME CUST_AREACODE CUST_PHONE CUST E-MAIL CUST_SHIP_ADDRESS CUST_SHIP_CITY CUST_SHIP_STATE CUST_ZIP_CODE SALESREP INVOICE PK SLSREP NUM PK INV_NUM SLSREP_LNAME-It writes OFK1 CUST_NUM FK2 SLSREP_NUM INV_DATE PK,FK1 PK FK2 I generates I INV SUBTOTAL INV_TAX INV_TOTAL contains INV_LINE INV_NUM INV_LINE NUM PROD_CODE INV_LINE_PRICE INV_LINE_QUANT INV_LINE_TOTAL VENDOR PK VEND_CODE VEND_NAME VEND_CONTACT VEND_EMAIL I supplies I PRODUCT PK PROD_CODE is written in +1-FK1 VEND_CODE PROD_DESCRIPTION PROD_PRICE PROD_QOH

SLSREP_FNAME SLSREP_INITIAL SLSREP_EMAIL CUSTOMER PK CUST NUM CUST_LNAME CUST_FNAME CUST_AREACODE CUST_PHONE CUST E-MAIL CUST_SHIP_ADDRESS CUST_SHIP_CITY CUST_SHIP_STATE CUST_ZIP_CODE SALESREP INVOICE PK SLSREP NUM PK INV_NUM SLSREP_LNAME-It writes OFK1 CUST_NUM FK2 SLSREP_NUM INV_DATE PK,FK1 PK FK2 I generates I INV SUBTOTAL INV_TAX INV_TOTAL contains INV_LINE INV_NUM INV_LINE NUM PROD_CODE INV_LINE_PRICE INV_LINE_QUANT INV_LINE_TOTAL VENDOR PK VEND_CODE VEND_NAME VEND_CONTACT VEND_EMAIL I supplies I PRODUCT PK PROD_CODE is written in +1-FK1 VEND_CODE PROD_DESCRIPTION PROD_PRICE PROD_QOH

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Downloads/ E ID-21201491;NAME-Nuzhat Taba x + English O localhost:8888/notebooks/Downloads/ID-21201491%3BNAME-Nuzhat%20Tabassum%20%3Bsec-17%20%3B%20CSE110.ipynb Cjupyter ID-21201491;NAME-Nuzhat Tabassum ;sec-17 ; CSE110 Last Checkpoint: 6 minutes ago (autosaved) Logout File Edit View Insert Cell Kernel Widgets Help Trusted Python 3 O + > Run с Markdown Write a Python program that takes a dictionary as an input from the user and then prints the average of all the values in the dictionary. [You are not allowed to use len() and sum()] Hint (1): For taking dictionary input Approach(1): For taking dictionary as an input from the user, you may take the whole dictionary as a string using the input() function. Then you can use the split(), strip() functions and conditions to get the keys and values from the string. Finally, you can make the dictionary using the obtained data. Approach(2): If the first approach seems too difficult you can create an empty dictionary and then just run a simple…
Downloads/ E ID-21201491;name-Nuzhat Taba: X + English O localhost:8888/notebooks/Downloads/ID-21201491%3Bname-Nuzhat%20Tabassum%3B%20sec%20-%2017%3B%20CSE110%3B%20Lab%20assignment%2004.ipynb Cjupyter ID-21201491;name-Nuzhat Tabassum; sec - 17; CSE110;... Last Checkpoint: Last Tuesday at 10:45 PM (unsaved changes) Logout File Edit View Insert Cell Kernel Widgets Help Trusted Python 3 O + > Run Code ========= ===== ===== == In [7]: #to do Task 13 Write a Python program that reads 5 numbers into a list and prints the smallest and largest number and their locations in the list. [You are not allowed to use the max(), min(), sort(), sorted() functions here] Hint: You may assume the first input to be the largest value initially and the largest value's location to be 0. Similarly, you can assume the first input to be the smallest value initially and the smallest value's location to be 0. Note: You may need to be careful while printing the output. Depending on your code, you might need data…
Estem.org/courses/64525/assignments/9460783?module_item_id=18078917 The following information can help you get started: • Invitation Details: it boils down to when and where o When: Time and date • Where: Address • Invitee List: Name and email • Name: First Name, or First Name and Last Name Email: Email address . Other considerations: After you complete your invitation, answer the following questions: 1. What type of data are time, date, and place? How are they different from the other data types on the invite and guest list? F4 A Additional information worth including: dress code, directions, gifting, how to contact you. . How will you know who is showing up? RSVP? . Is there a theme to your invitation/design? x F5 % F6 F7 DELL F8 F9 ROMNA F10 F11 PrtScr
PK Cus CODE PK INV NUMBER PK,FK1 INV NUMBER LINE NUMBER HEDenerates contains PK CUS LNAME CUs FNAME CUs INITIAL CUS AREACODE CUS PHONE CUS BALANCE FK1 CUS CODE INV DATE P CODE LINE UNITS LINE PRICE FK2 is found in VENDOR PRODUCT PK V CODE PK P CODE V NAME v CONTACT V AREACODE V PHONE V_STATE V ORDER P DESCRIPT P INDATE P_QOH P MIN P PRICE DISCOUNT FK1 V CODE upplies Write a SQL query to list the product code, vendor code, and vendor name for all products and includes those vendors with no matching products. Y CODE- PRODUCTY CODE
DATA: myBytes BYTE 10h,20h,30h,40hmyWords WORD 8Ah,3Bh,72h,44h,66hmyDoubles DWORD 1,2,3,4,5myPointer DWORD myDoubles Questtion: mov ax,[esi] ; AX = ?
SUPPLIER PRODUCT ProductCode ProductnName unitPrice SupCode supCode (Number, 3) SupName (text, 20) АВC LLC (Number, 10) [Char(10)] (>0) 1111111 Calculator 10 111 111 2222222 Notebook 2.5 777 222 ХҮX LLC 3333333 Book-AI 20 222 3333 PQR LLC 4444444 Pen -2.0 222 222 AXL LLC 5555555 Pencil .500 111 Eraser .500 222
Downloads/ ID-21201491;NAME-Nuzhat Taba X + English O localhost:8888/notebooks/Downloads/ID-21201491%3BNAME-Nuzhat%20Tabassum%20%3Bsec-17%20%3B%20CSE110%3B%20lab%20assignment%205.ipynb Cjupyter ID-21201491;NAME-Nuzhat Tabassum ;sec-17 ; CSE110; lab assignm... Last Checkpoint: 2 minutes ago (autosaved) Logout File Edit View Insert Cell Kernel Widgets Help Trusted Python 3 O + > Run Code In [13]: dict={'A': [1, 2, 3], 'b': ['1', '2', '3'], "c": [4, 5, 6, 7, 8, 9]} count=0 for values in dict.values(): for i in values: count+=1 print(count) 12 Task 13 Suppose you have been given the following list of tuples. list = [("a", 1), ("b", 2), ("a", 3), ("b", 1), ("a", 2), ("c", 1)] Write a Python program that converts this list of tuples into a dictionary and then prints the dictionary. [You are not allowed to use set] Hint: Think of membership operators (in and not in). ======== %3=D=== ====== Output: {'a': [1, 3, 2], 'b': [2, 1], 'c': [1]} ========= === !%====================== ============ In…
Downloads/ ID-21201491;NAME-Nuzhat Taba X + English O localhost:8888/notebooks/Downloads/ID-21201491%3BNAME-Nuzhat%20Tabassum%20%3Bsec-17%20%3B%20CSE110%3B%20lab%20assignment%205.ipynb Cjupyter ID-21201491;NAME-Nuzhat Tabassum ;sec-17 ; CSE110; lab assign... Last Checkpoint: 37 minutes ago (autosaved) Logout File Edit View Insert Cell Kernel Widgets Help Trusted Python 3 O • Run Code Task 12 Suppose you are given the following dictionary where the values are lists. dict = {'A': [1, 2, 3], 'b': ['1', '2'], "c": [4, 5, 6, 7]} Write a Python program that counts the total number of items in a dictionary's values and prints it. [without using sum(), len(), count() ction Note: Make changes to the above dictionary and see if your code works properly for other dictionaries as well. ========= ============ ================ Output: 9. ========: ===D== ==== === In [ ]: | Task 13 Suppose you have been given the following list of tuples. list %3D[("а", 1), ("Ь", 2), ("а", 3), ("Ь", 1), ("а", 2),…
Downloads/ assum_sec X + English localhost:8888/notebooks/Downloads/21201491_Nuzhat%20Tabassum_sec-17_CSE110_assignment-06.ipynb C jupyter 21201491_Nuzhat Tabassum_sec-17_CSE110_assignment-06 Last Checkpoint: 8 hours ago (unsaved changes) Logout File Edit View Insert Cell Kernel Widgets Help Trusted Python 3 O + • Run с Markdown Task 15 You have been hired as an app developer for the company. The company plans to make an app for a grocery store where the user can order groceries and see the total amount to be paid in the cart section. To build this feature, you have to write a function that takes 2 arguments. They are: order_items (must be a list) • location (default value should be set to "Dhanmondi") Your first task is to take a list of items from the user. Pass the list into the function parameter along with the optional location (Use default argument technique). (Also, no need to take location as input, pass this any value you want.) Your second task is to implement the function.…
Downloads/ assum_sec X + English localhost:8888/notebooks/Downloads/21201491_Nuzhat%20Tabassum_sec-17_CSE110_assignment-06.ipynb C jupyter 21201491_Nuzhat Tabassum_sec-17_CSE110_assignment-06 Last Checkpoint: 8 hours ago (unsaved changes) Logout File Edit View Insert Cell Kernel Widgets Help Trusted Python 3 O + > Run Code print(rem_duplicate(('Hi',1,2,3,3, 'Hi','a','a',[1,2]))) ("Hi', 1, 2, 3, 'а', [1, 2]) Task 12 Write a python function that takes a list as an argument. Your task is to create a new list where each element can be present at max 2 times. Inside the function, print the number of elements removed from the given list. Finally, return the new list and print the result. ========: ======= Hint: You may use list_name.count(element) to count the total number of times an element is in a list. list_name is your new list for this problem. Function Call: function_name([1, 2, 3, 3, 3, 3, 4, 5, 8, 8]) Output: Removed: 2 [1, 2, 3, 3, 4, 5, 8, 8] Function Call: function_name([10, 10,…
DATA: myBytes BYTE 10h,20h,30h,40hmyWords WORD 8Ah,3Bh,72h,44h,66hmyDoubles DWORD 1,2,3,4,5myPointer DWORD myDoubles QUESTION: mov eax,[ebx+4] ; EAX =?
What is the code to create a data frame name data_eng that would only contain females from the data frame shown below: 1 data2.head (5) salary ape year a company wex Fax M pealtion Accountant peation Developer peation Engineer pation Financial pean Secretary D 119778BBDD 54 1 2 54434.7200 54 215 3 05217.1300 30 4 74220.8800 4 11 10 210 D D 1 1 1 1 D D D O data gen = data2[(data2.eng 1)] data_gen= loc[(data2.position_Engineer == 1)] O data_gen = data2.loc[(data2.position_Engineer== 1)] data_gen = data2.loc(position_Engineer 1)]