composite attribute:
Q: Define the term attribute
A: Definition: In computing, an attribute is a particular that characterizes a property of an item,…
Q: Mail Merge Marketing Mail merge documents are often used in marketing campaigns intended for…
A: According to the information given:- We have to define the Mail Merge Marketing on Mail merge…
Q: Tasks Review the peronal traner fact-finding summary and draw an ERD with cardinality notation.…
A: Personal Trainer Entity Relationship Diagram (ERD) the basic purpose involved in the personal…
Q: Highlight only the attribute name in the following code. Be precise. 1 residence…
A: The attributes of a class are the variables which are defined inside of a class and are commonly…
Q: Indices speed query processing, but it is usually a bad idea to create indices on every attribute,…
A: Index in database: It improves the database performance by quickly locating and accessing the data…
Q: Description Product CategoryID Package Weightaty WeightUnits Price Dimensions Date Modified…
A: GENARAL STATEMENT FOR A VIEW: CREATE OR REPLACE VIEW view_name ASSELECT column1, column2, ...FROM…
Q: Click the small + sign beside the employee with ID 149. What do you see? Why do you see it?
A: Datasheet view: Datasheet view provides the visual way to create a table. It is used to arrange the…
Q: Using Employees and Departments tables: a. Write a query that will display the First_Name and…
A: Creating table "Employees" and "Departments": CREATE TABLE Employees (id int(11) NOT NULL…
Q: The set of 7 attributes is { desc, drought, price, sci, size, store, The attributes are for plants…
A: To find the key for all attributes for the given dependency.
Q: As part of the data collection process, you must create meta data. State how you will go about…
A: We have to discuss meta data
Q: Salesforce Development Design a query to fetch the account created Date, Name, Id and use the…
A: SOQL - SOQL is described as Salesforce object Query Language. SOQL comes with multiple features and…
Q: Create rules that will link layered transactions.
A: A transaction record stored in the range where the first write occurs, which includes the…
Q: rposes, what is the data needs and goal
A: An company's Enterprise Data Model (EDM) is a solitary portrayal of the data it delivers and…
Q: partial key (discriminator) in Entity Al A2 B1 B2 Entity 1 Entity 2 R1 N АЗ R2 D1 D2 C2 Entity 4…
A: The relationship between E1 and E2 is 1:N. So include primary key of E1 as foreign key into schema…
Q: Describe joining index?
A: Given: Describe joining index?
Q: provide an example of what is meant by the term "Key Attribute."
A: A key in DBMS is a attribute or a set of attributes that assistance to particularly recognize a…
Q: Any attribute or combination of attributes that can be used to distinguish uniquely one row from…
A: Defining the terms: Simple key A simple key refers to a "single (or only one) attribute" that is…
Q: Detail worksheet will be summed. Detail worksheet will be summed. Summary worksheet will be summed.…
A: The correct option and explanation to the option is as follows
Q: dynamic table that supports insertion and deletion operation. when the load factor goes below 1/3…
A: First of all we clear why it's called so, dynamic (table) that grows or shrinks based on the context…
Q: scribe the benefits and drawb
A: Solution - In the given question, we have to describe the benefits and drawbacks of the various…
Q: Create a data model to reflect the process of a consumer opening a checking account at a bank. The…
A: The data model is created with 5 tables 1.customer 2.account 3.accounttype 4.cus_account…
Q: Eva also wants to create a Pivotlable that includes data about sales representatives and their…
A: Power Pivot enables us to import millions of rows of data from many data sources into a single Excel…
Q: Describe meta data and result set meta data.
A: To be determine: Describe meta data and result set meta data.
Q: Display all product information for products that contain the string ‘saw’ anywhere in their…
A: LIKE keyword is used to match the values
Q: 2NF Data Normalization is needed.
A: The given dataset contains the below information: Customer information with (CustomerID, Customer,…
Q: List all the views contained within the system catalog.
A: To get all the views run the command in step 2
Q: Salesforce Programming Question: Design a SOQL query to fetch all the permission sets and profile…
A: As per the given question we have to develop SOQL query to fetch all the permission sets and profile…
Q: 10) What type of connection is used in the following query select category_name, first_name…
A: Consider the given Query: select category_name, first_name from Child, Size_ group where…
Q: Dimensionality reduction helps to eliminate irrelevant attributes or reduce possible noise.
A: The dimensionality reduction plays vital role in the data mining techniqueues. In the dimensionality…
Q: Name an example of an attribute in the following table. Student_ID Student Name Student Street…
A: Attributes are defined in terms of their domain. A domain defines the allowable values that an…
Q: List the numerous relationships in the database.
A: Introduction: One of the primary advantages of utilising a relational database is the ability to…
Q: lease list some data science topics with attributes to support the topic.
A: some data science topics with attributes to support the topic 1) causal reasoning 2)precious data…
Q: Describe the purpose of indexes and the important considerations in selecting attributes to be…
A: Purpose of Index: Indexing allows you to view the data more quickly, including reads and changes in…
Q: A college course may have one or more scheduled sections or may not have a scheduled section.…
A: SEE STEP NO. 2 I WILL PROVIDE SOLUTION THERE
Q: dentify appropriate data type to be used for all attributes and set primary key. stu_id Stu-name S…
A: In the give ERD, the relationship between Student and Professor is one-to-one (1:1) For binary…
Q: Relationships 3 different relationships one:one , 1:n , n:m
A: Given :- The database relationship types (one to one), (one to many) and (many to many) relationship…
Q: Write 5 queries with explanations for online book store system,(USE MySQL) -- Write 5 queries. Your…
A: SQL is the structured query language, It's designed to facilitate the extraction the specific…
Q: Create an ERD using Visio or any other tool for the following scenario. Your ERD should show all…
A: ERD diagram for following Scenario
Q: Create employee Intrest survey form like below model
A: The Answer is in Below Steps
Q: question Design a SOQL query with inline soql to display the Account history data. Design the…
A: SOQL - SOQL is defined as the language of the Salesforce Object query. Designed for salesforce on a…
Q: Assignment_1: 1. Create table customer with four attributes number, name, address and telephone…
A: Note: There are multiple questions are given in one question. According to the rule, you will get…
Q: Any attribute or combination of attributes that can be used to uniquely distinguish one row from…
A: Candidate key: Candidate keys are defined as the minimal set of attributes which can uniquely…
Q: use of derived attributes
A: Derived attributes A derived attribute is a special kind of attribute that derives its value from…
Q: Design any system that shows your ability to manipulate the database including the CRUD (Create,…
A: Database Setup Let's create a database named "demo" in MySQL. Now, create a users…
Q: What is the syntax of composite conditions - that is, selection or merging on two or more columns?
A: Composite Condition in DML Queries: Composite conditions refer to the use of two or more conditions…
Step by step
Solved in 2 steps with 4 images
- _&plase helo with Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers..1.A connected set of worksheets and dashboards in Tableau is called a. Dashboard b. Story c. Worksheet d. Joins 2.Which one of the below functions is used as a helper function in a Table calculation? a. FIRST() b. INDEX() c. LAST() d. All of the aboveSubject DataBase/MySQL What is wrong with this statement? SELECT vendor_id, (SELECT vendor_name FROM vendors), avg(invoice_total) FROM invoices GROUP BY vendor_id; Select one: a. The subquery returns more than 1 row. b. You need a JOIN ON clause to pull from multiple tables. c. You cannot have a subquery in the SELECT statement. d. The result is a Cartesian Product. e. There is nothing wrong with this statement. What is wrong with this statement? SELECT vendor_name, avg(invoice_total) AS 'Invoice Total' FROM vendors v JOIN invoices i ON v.vendor_id = i.vendor_id Select one: a. You are missing the GROUP BY clause. b. Nothing, this statement runs correctly. c. The JOIN ON clause is incorrect. d. Invoices should also be in the FROM clause. e. You are using single quotes instead of double quotes. - TIA
- MySQL database, with table Table 1 fields: NO_CRT, PRODUCT, PIECES PRICE_PCS. TOTAL PRICE (ION user, no password). There can be a maximum of two products with the same name (PRODUCT) and the same PRICE_PCS. The NO_CRT field has a unique value for each item. Reading from the keyboard a PRODUCT, respectively PRICE_PCS (using an HTML file to be written), by pressing a button the following operations will be performed (in a PHP script file): - search in the table of how many products with the same name PRODUCT and PRICE_PCS exist; - if no item is found, this will be signaled by a message (and exits the program); - if only one item is found, this item will be displayed in a table; - if two are found: - the second found item is deleted, and the data following it (more precisely PIECES) are transferred (added) to the remaining items (normally, also in the PIECES field); NO_CRT,is redone for the following deleted items (to have a successive numbering); - recalculate TOTAL…Given the follwing business rules, create an ERD. The ERD must include all primary keys, foreign keys, attributes, cardinalities. Also consider relational strengths (dashed lines or solid lines) : A university is divided into many schools. Each school has many departments, where each department belongs to one and only one school. Each department should have one or more professors assigned to it, where each professor cannot teach more than two courses. The university wants to record the following data for all professors: professor number and full name.SQL: Display all product information for products that contain the string ‘saw’ anywhere in their description. Remember to use the * for all attributes here and the LIKE keyword. [hint: you should have 5 rows of output] I understand how to create the query but I can't get the expected result. What am I doing wrong? My code: select * from product where p_descript like 'saw' ; I get no data found when I know there is supposed to be 5 rows of output.
- Please provide detailed solution. Create a logical ERD for an online movie rental service (no many to many relationships). Use the following description of operations on which your business rules must be based: The online movie rental service classifies movie titles according to their type: comedy, western, classical, science fiction, cartoon, action, musical, and new release. Each type contains many possible titles, and most titles within a type are available in multiple copies. For example, note the following summary: TYPE TITLE Musical My Fair Lady (Copy 1) My Fair Lady (Copy 2) Oklahoma (Copy 1) Oklahoma (Copy 2) Oklahoma (Copy 3)Database Question Dataset showing the class, attribute and number of evidences per class|attribute.CLASS LONG SWEET YELLOW TOTALBanana 400 350 450 500Orange 0 150 300 300Other 100 150 50 200Here’s the deal:• We have a training dataset of 1,000 fruits.• The fruit can be a Banana, Orange or Other • The fruit can be Long, Sweet or YellowUsing the DBMS 130 Course Project ERD and Table Details spreadsheet, develop an APEX script to CREATE the 6 tables and all the constraints (PK, FK, NOT NULL, etc.).Add these two constraints to the FLIX_MOVIES table1. Movie Rating can only have these values: a. Gb. PGc. PG13 or PG-13d. R2. Movie Category can only have these valuesa. DRAMAb. COMEDYc. ACTIONd. SCIFIe. DOCUMENTARY
- Database Question this is a review question! please keep answer simple The SQL statements that answer these questions. please keep the answer simple will give thumbs up thank you :)! INSERT STATEMENT LINK below https://drive.google.com/file/d/1qHCkrods5K2V1syyS5IG6-Eb_3QQmud7/view?usp=sharing Table.SQL below -- MySQL Script generated by MySQL Workbench-- Sun Feb 21 00:00:31 2021-- Model: New Model Version: 1.0-- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ------------------------------------------------------- Schema mydb-- ----------------------------------------------------- -- ------------------------------------------------------- Table state-- -----------------------------------------------------CREATE…Computer Science The following script uses a derived table to return he date and invoice total of the earliest invoice issued by each vendor. Write a script that generates the same results set but uses a temporary table in place of the derived table. Make sure your script tests for the existence of any objects it creates. Use itse2333; SELECT VendorName, FirstInvoiceDate, InvoiceTotal FROM Invoices JOIN (SELECT VendorID, MIN(InvoiceDate) as FirstInvoiceDate FROM invoices GROUP BY VendorID) as FirstInvoices ON (Invoices.VendorID = FirstInvoice.FirstInvoice.VendorID and Invoices.InvoiceDate = First.Invoice.FirstInvoiceDate) JOIN Vendors ON Invoices.VendorID = Vendor.VendorID ORDER BY VendorName, FirstInvoiceDate);Q3: Emp (Eno, Ename, Title, City) Project(Pno, Pname, Budget, City) Works(Eno, Pno, Resp, Dur) SELECT Ename, Pname FROM Emp e, Works w, Project p WHERE e.Eno = w.Eno AND e.city = p.Eno AND p.city = Newark AND w.Dur > 40 Given the database schema and the query above and knowing that only 1% of the employees work on a project for 40 months or more, propose an optimized query plan and discuss the indexes needed