Customer Purchase id phone PK Pk id made_by product Fname Fk cid FK Pid Lname street_Code street _name city district pincode country FK Pid FK material_id type price details name Payment PK,FK id payment_for %3 amount FK Pay_id Pid data FK profit_amount Employee Profit manages_by PK id county_code phone PK,Fk id raw materials FK profit_id Emanaged fk m_id Fk Eid street_Code street_name city pincode country start_date date Price Name Details Avalable Quant Fk Eid amount キ
Q: Supplies Clerk Purchasing Computer Receiving start Vendor Dinplay tems below reorder Onine Report…
A: Entities Activities Computer : Displays items below reorder point Fetches the information of…
Q: E deptname E fax phone H location offers employs hod Student AcademicStaff studentid staffid A…
A: Required: We have to develop Sql queries according to the given database schema.
Q: Branch branchNo street city postcode BO05 22 Deer Rd London SWI 4EH BO07 16 Argyll St Aberdeen AB2…
A: Tuple: Tuples means rows. Degree: Degree of relation means number of attributes in a table.…
Q: supcity supstatus purchase price deliv_period SUPNR | 0..M PRODNR supname prod-po po-prod SUPPLIER…
A: Given ER diagram contains 3 entities and each entity contains some attributes, that are: Supplier…
Q: 2) In EXCEL display a descriptive statistic on Units Sold (using Store and Regional Sales Database)…
A: Descriptive statistical analysis: To instruct Method to calculate statistical analysis, press the…
Q: Many-to-Many ERD CUSTOMER has: customer_id first and last names address TAPE has: tape_id…
A: Since there are multiple questions posted, we will answer for the first question. If you want any…
Q: Pet Clinic Pet Treatment Integer(10) integer( 10) varchar( 25) varchar(25) ClinicNO integer(10)…
A: Answer: I have given answered in the handwritten format
Q: In the image provided which keys would be Primary, Foreign, or Surrogate in this star schema?
A: Primary keys:It is unique key in data table assigned to link one data table with other. Example of…
Q: Grade Calculation at CoTs Student ID J123458 Student Name Someshvar Course ID ITDB201 Course Name…
A: <!DOCTYPE html><html><head> <meta charset="utf-8"> <meta…
Q: An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius.…
A: Anomalies in the table: Insertion anomaly If a part time staff is available but he is not assigned…
Q: Ryan Car Rental LLC. Quarterly Turnover Report Report ID.: 7686 Reporting period: Jan 2019-Mar 2019…
A: Need to find First Normal Form, Second Normal Form and Third Normal Form of the given database :
Q: INVOICES INVOICE LINE INVOICE NUM ITEM ID QUANTITY QUOTED PRICE 14216 INVOICE NUM INVOICE DATE CUST…
A: The complete solution is given below:-
Q: Branch branchNo street city postcode BO05 22 Deer Rd London SWI 4EH BO07 16 Argyll St 163 Main…
A: Tuple is a single row in a relation. Degree is a number of attributes/columns in a relation.…
Q: Final Relational Schema CUSTOMER FN LN CU-ID AGE WIG HEIG DISSES STATE CITY STREET MN CUS_PHON CU-ID…
A: Here we have given final relational schema for the given data
Q: Rental Date Film Quantity Film Rental Customer Customer Customer Name Email ID ID Name ds@gmail.com…
A: Task : Given the table. The task is to normalize the table.
Q: 130 Corporate Tax 170 Manufacturing 180 Construction ODEPARTMENTS Columne Data Model IConstraints…
A: b is the correct option Select C.Last_name,D.Department_name From DEPARTMENTS D INNER JOIN…
Q: Table name: ADVISORS ADVISORID A102 A103 ADVISORNAME Sami Alice A104 Suad A105 A101 Tamil Arun Table…
A: ON clause is used to implement Joins between 2 tables.
Q: EMPLOYEE Fname Minit Lname Sex Salary S Address 123456789 1965-01-09 731 Fondren, Houston, TX M…
A: a-- select Fname, Bdate from EMPLOYEE where Dno = 4 and Salary > 40000; The output table will…
Q: The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics.…
A: Write the relational schema and the dependency diagram for the employee table.
Q: Customer Table CNO NAME ADDRESS CITY C1 Rahal Thapar campus Patlala C2 Ruhi Tagore Nagar Jalandhar…
A: Here the concept of primary key and foreign key is used. primary key is key which uniquely…
Q: Suppliers SupplieriD CompanyName ContactName Contact Title Address City Region PostalCode Products…
A: Answer: Given Identify the Primary key and Foreign key Primary key: A primary key is used uniquely…
Q: Salesperson Region Account Order Amount Month Albertson, Kathy East 29386 $925.00 January Albertson,…
A: Store the given data in CSV format I have used google colab for implementation upload the csv file…
Q: Company ID Department Department Product ID Company Product Product Product Date Value Name VR1000…
A: In Relational data base if the data tables are not normalized then we may run into one of the data…
Q: Patient table PATIENTNUM NAME SURNAME APPOINTMENTDATE APPOINTMENTTIME SURGEONID W220 TONY JONES 12…
A: Hello Student, hope you are doing well, I will be trying my best to explain and fulfill your query.…
Q: DocPatientAppointments Table DrName John Smith ... PatientAge ClinicID CI C2 AppDate 15-Jun-21 DRID…
A: Note: The solutions of the first two parts are shown below. Please repost the remaining subpart to…
Q: The following exercises are based on the Solmaris Condominium Group database shown in Figures 1-21…
A: Actually, A database is a collection of information that is organized so that it can be easily…
Q: Considering Student and Student_Courses relations shown above, discuss when Union, Inner Join, Left…
A: Given the Student and Student_Courses relations shown above, discuss when Union, Inner Join, Left…
Q: Explain in a one-paragraph summary, how you would normalize (restructure) the enclosed database.…
A: To normalize the table and why.
Q: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database,write the SQL code that…
A: GIVEN: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database,write the SQL…
Q: S_Customer_T S_Order_T PK Customer_ID PK Order_ID Order Date FK Customer_ID Customer_Name…
A: Conversion to Relational Model: CREATE TABLE S_Customer_T(Customer_ID integer PRIMARY KEY,…
Q: stores dimension store id store name products dimension store street product name sales fact store…
A: Star schema: Star schema is a type of structure which is used to organize the database. Then…
Q: PROJ_NAME PROJ_VALUE PROJ_BALANCE EMP_LNAME EMP_FNAME EMP_INITIAL JOB_CODE JOB_DESCRIPTION…
A: The SQL code for the above table is /* Create a table called PROJECT */CREATE TABLE PROJECT…
Q: Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table…
A: 1)Display name for name: Get all Student names who are in CSE dept.πSnameσDname=”CSE”(Student…
Q: tblShippers V ShoperiD tblProducts 8 ProductID Companytiame SupplierD tblOrderDetails CategoryD P…
A: It violates integrity constraints: Absence of Primary key and foreign key constraints. It violates…
Q: stuctural User username pattern (private class data) password email Creational pattern Student |- id…
A:
Q: Employee Department Contacts KPT Enterprises Quarterly Schedule of Revenue For the year December 31,…
A: logic:- =SUM(range of cell ) is used to find summation of values present in cell. Here values in…
Q: A -Video Rental Solution.pdf POF -> O File |…
A: The ER diagram is given above. The the relational schema of the ERD is as follows. The tool used is…
Q: College Management System(CMS) Department Student department_id number --> PK department_name…
A: Here we have to create the table mark from the database schema given. We use CREATE command for…
Q: 1: Write query to create canteen_table. Put check on category values as only “junk” and “Not junk”.…
A: The given problem is related to database SQL queries where the requirement is to create the table…
Q: EMP_NUM EMP_NAME June E. Arbough PROJ_NUM PROJ_NAME JOB_CLASS CHG_HOUR HOURS Elect. Engineer…
A: Here, I have to provide an answer to the above question.
Q: Database name: Ch03_Theater Table name: DIRECTOR DR _NUM DR LNAME DIR DOB 100 Broadway 101…
A: given are the two table: to determine: we need to find primary keys
Q: 15:41 Done STUDENTS STUDENT_ID STUDENT_NAME S123456 S246810 S369121 S654321 S987654 MODULES…
A: CREATE TABLE STUDENTS(STUDENT_ID VARCHAR(20) PRIMARY KEY, STUDENT_NAME CHAR,STUDENT_SURNAME CHAR);…
Q: Grocery Store Data Model Barry Williams Principal Consultant June 15th. 2008 Customers Addresses PR…
A:
Q: PROPERTY_ID OFFICE_NUM ADDRESS SQR_FT BDRMS FLOORS MONTHLY_RENT OWNER_NUM 1 1 30 West Thomas Rd.…
A: SQL for: Sort the properties by square foot information and get the top three for the marketing…
Q: PAYSLIP: Employee Number: Employee Name: 0111 Jon Mill Position: Programmer Hours Worked: 162 Pay…
A: I give the code in JAVA along with output and code screenshot
Q: SupplierAddress SupAddress Street City District Superstore StorelD Procurement_Sup…
A: Code for creating tables: create table Customer(CustomerID int primary key, CustomerName text,…
Q: The fields below repeat for each customer: o Customer name (String)o Customer ID (numeric…
A: File name: “OfficeCustomerClass.java” public class OfficeCustomerClass { private String…
Q: First na Aildet ne (last make ARMO CAPIYORD Salary employee Shift bers-Pefla booking data Ser ve…
A: ERD stands for entity relationship diagram and the main components of ERD are entities, attributes…
Q: Using the table structures you created (in first attachment called "Table Stucture", remove all…
A:
My topic; Accounting
Issue: My brother works as an accountant in a firm named as stainless steel. The firm’s accountants having a problems of tracking and managing the incomes of the company and how many materials are needed for each product.
Can you convert EERD to mapped to logical sheme? Sample in the photo.
Step by step
Solved in 3 steps with 1 images
- 1. Consider the following schema: Record #plvId Player plyld plyName Hilal Tarek Sultan Salim Sport spld sp Name Football Tennis Swimming Cycling #evCode place 1 1 1 El 1 E6 4 3 3 E2 1. 4 4 E5 1 Event evCode El 3. ЕЗ E8 32 8 #spId evPlayes 4 evTitle E4 E7 3 Mini Foot Fest Ibri Tour Oman Open Arab Sea Race 75 15 4 1 E2 4 E3 E4 2 32 36 Muscat Cycling Dhofar Fest Indoors Cup Suhar Open E5 4 48 Еб 115 E7 3 32 B8 64 Note: primary keys are underlined, foreign keys have #. Answer the following questions : (after executing the SQL command, copy the command and screen shot of the result in a word file. Do not forget to indicate the question number, save the file with your student number and send it by email) Q1. Create the tables above. Include primary keys and foreign .keysDeclareastructureinthenamepeoplewiththefollowingdatamembers:NameAgeSex.DateofBirthTakeanarrayofsize10oftypepeople.Writeaprogrammetoassignvaluestoalldatamembersofthearrayandwriteafunctiontodisplay it in the followingformatforallFemale:SlNo. Name Age DOB(DD/MM/YYL Consultant ConsitNum LastName FirstName Street 19 Christopher Patrick Sarah Tom 35 $1 Client ClientNum ClientName 175 299 322 363 405 449 Turner Jordan Allen Shields 458 Hershey, Jarrod Goduto, Sean Two Crafty Cousins Prichard's Pizza & Salazar, Jason Fisherman's Spot Shop Seymour, Lindsey Bonnie's Beautiful Boutique Yates, Nick Howler, Laura Harpersburg Bank MarketPoint Sales Street 135 Mill Street 12 Saratoga Parkway 9787 NCR 350 West 501 Air Parkway 733 458 554 Brown Dr. 2287 Port Rd. 82 Elliott St. 373 Lincoln Ln. 322 867 322 363 867 826 677 733 826 867 WorkOrders OrderNum OrderDate ClientNum 67101 9/6/2018 67313 9/7/2018 9/10/2018 67424 67838 67949 68252 68868 68979 9/10/2018 9/10/2018 9/12/2018 9/14/2018 9/17/2018 4091 Brentwood Ln 9565 Ridge Rd. 231 Day Rd. 1368 E. 1000 S. 65 Forrest Blvd. 826 Host St. City Tri City Easton Lizton Sunland City Easton Tri City Sunland 68252 68868 68979 68979 Lizton 56473 Cherry Tree Dr Easton FL. 49 Elwood Ave. Harpersburg FL. Amo Tri City State…
- Assignment (7)_9599bd...4ca854f63ff1644f1b1d Course's Name: C+ Palestine Technical University - Kadoorie Instructar's Nawe :Dr. Mota: Daadoo Course's Number: 1214100 Sudent's Name: Exam's Period : Snudent's Number: Questions Number : Total Mark :10 Section's Number: Due Date 14 May Pages' Number :1 Anignment Write a C++ program to swap elements of two arrays using pointers. Example: Input: Input first array: 100 330 30 40 50 60 70 80 90 10 Input second array: 1e 9 8 7 6 5 4 3 2 1 Output: First array after swapping: 10 9 8 7 6 5 4 3 2 1 Second array after swapping: 100 330 30 40 50 60 7e 80 90 10 Good Luck! IIEmployee.tx Kent Brockman 12345Charles Burns 24923Cletus Delroy 25394Ned Flanders 04382Seymour Skinner 45234Homer Simpson 62352Milhouse Vance 52352Nelson Muntz 63265Edna Krabapple 72353Jimbo Jones 10234Martin Prince 02532Patty Bouvier 23252Troy McClure 32522Marvin Monroe 10028Waylon Smithers 80214Moe Szyslak 13095Clancy Wiggum 23052John Frink 20625Barney Gumbel 11321Julias Hibbert 13359Lionel Hutz 21952Helen Smith 19202Bill Clinton 79872Alexander Hamilton 92321John Wynne 23421YourFirstName YourLastName YourZipCodeBranch branchNo street city postcode sWI 4EH 16 Argyll St Aberdeen AB2 3SU GI1 9QX BO05 22 Deer Rd London BO07 BO03 163 Main StGlasgow BO04 32 Manse Rd Bristol BS99 INZ BO02 56 Clover Dr London NW10 6EU Foreign key Staff staffNo fName IName| position salary branchNo sex DOB SL21 John White Manager Assistant M 1-Oct-45 30000 BO05 SG37 Ann Beech 10-Nov-60 12000 вооз SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant 19-Feb-70 9000 BO07 SG5 Susan Brand Manager 3-Jun-40 24000 BO03 SLA1 Julie Lee Assistant 13-Jun-65 9000 BO05 Tuple Degree Candidate Key Cardinality Domain Attributes Drag and drop the proper terms Relation Relation
- File Paste K14 7891011234567 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Ready Home Insert Page Layout Cut Copy Format Painter Clipboard ■ ▬▬▬▬▬ 7 Business Unit # of Vouchers ▶ I X Arial OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 OSCM1 BI 5 13 8 33 14 25 5 2 15 12 7 11 1 2 27 15 Ques-1 Ques-2 A A B с D 1 Question 3-Categorize the user based on given conditions using the excel function: 2 (a)- If vouchers are more than 10 then Bonus else Slacker 5 6 Accessibility: Investigate U fix Type here to search Formulas Data Font 10 2 5 Days Between Vchr Entry and Payment 5 4 3 ▼ 2 3 3 4 g 3 3 3 3 1 4 1 Á A A Review View Help Ques-3 Ques-4 Ques-5 I Et === User Jim Ignatowski John Locke Kim Bauer Liz Lemon Lorelai Gilmore Lynette Scavo Maddie Hayes Matt Saracen Monica Bing Natalie Teeger Niles Crane Norm Peterson Phil Dunphy Phillip J. Fry Red Forman Robert Barone Alignment Ques-6 Ques-7 O a Wrap Text Tell me what you want to do Merge & Center E…AUGRRXULTRFUQGBNULYTAGPONPBVPBSUMOFFYVYGLYGT MCOICEESXFPBUHKCYUIDKRGJEOHDXNHQPBMYBEHYYUNLdiagram 3. Draw sequence diagram for making a hotel reservation (The Reservation window sends a make Reservation() message to a HotelChain. The HotelChain then sends makeReservation() message to a Hotel. If the Hotel has available rooms, then it makes a Reservation and a Confirmation)
- Aseed fde.BookId Title PublisherName DatePublished B1 Himu Onnyoprokash 1997 B2 Ami Topu Ananya 2005 B3 Ma Pearl 2003 B4 Harry Potter Times 1995 B5 Machine Learning Dimik 2018 BookId AuthorName B1 Humayun Ahmed B2 Jafar Iqbal B3 Anisul Haque B4 JK Rowling B5 Nafis Neehal PublisherName Address Phone Onnyoprokash Nilkhet 9153752 Ananya Mohammadpur 8163743 Pearl Dhanmondi 2163856 Times London 4234714 Dimik Azimpur 4644454 BookId BranchId NoOfCopies B1 Br1 10 B2 Br2 20 B3 Br3 05 B4 Br2 07 B5 Br3 11 BranchId BranchName Address Br1 Shokal Mohakhali Br2 Dupur Uttara Br3 Shondha Moghbazar Find the books published before 2008. Find the book names authored by JK Rowling. Show the phone numbers of publishers which published the book of Anisul Haque…Create a PHP program that executes the following mathematical procedures in order to produce the specified result. Title: Activity 5Body Title: Problem 2Salary_rate=600/daySalary=Salary_rate*15 daysTaxable_amount=30% of salaryNet_pay=Salary - Taxable_amount