MS-ACCESS (.1. Create a database COMPANY and create a new table EMPOLYEE and name it2. Design a table EMPOLYEE so that it has all fields and the following propertiesFIELDSDATATYPEPROPERTIESEMPNONumber4EMPNAΜΕShort Text10PHONENumber8PLACEShort Text9.DOJDate/Time3. Set the field EMPNO as the primary key and save the table4. Enter the following data into the table EMPLOYEEEMPNOΕMPNAΜΕPHONEPLACEDOJ1111ΑΗMED98989898 | IBRI12/06/20142222SARA99997777 | NIZWA15/09/20183333AMNA90909090 | MUSCAT14/06/20174444NAHID91919191IBRI02/08/20155. Design a table SPORTS so that it has all fields and the following propertiesFIELDSDATATYPEPROPERTIESEMPNONumber4SPORTSShort Text10YEARSNumber2SCHOLARSHIPYES/NOAMOUNTCURRENCY6. Set the field EMPNO as the primary key and save the table7. Enter the following data into the table SPORTSEMPNOSPORTSYEARSSCHOLARSHIPAMOUNT4444FOOTBALLYES503333BASKETBALLNO2222FOOTBALL1NO1111CRICKETYES508. Create a relationship between two tables EMPOLYEE and SPORTS 9. Create a query to show all the fields in EMPOLYEE and SPORTS table. Save the query as ES11 '10 Create a query to show the all the fields in EMPOLYEE and SPORTS table where ENAME in descendingorder. Save the query as ES12.11 Display EMPNO, EMPNAME, PLACE, SPORTS, YEAR AMOUNT fields in EMPOLYEE and SPORTS tablewhose EMPNAME= AHMED or SPORTS = FOOTBALL. Save the query as ES13

Answer 9: SELECT e.empno,e.empname,e.phone,e.place,e.doj…

9. Create a query to show all the fields in EMPOLYEE and SPORTS table. Save the query as ES11 ' 10 Create a query to show the all the fields in EMPOLYEE and SPORTS table where ENAME in descending order. Save the query as ES12. 11 Display EMPNO, EMPNAME, PLACE, SPORTS, YEAR AMOUNT fields in EMPOLYEE and SPORTS table whose EMPNAME= AHMED or SPORTS = FOOTBALL. Save the query as ES13

9. Create a query to show all the fields in EMPOLYEE and SPORTS table. Save the query as ES11 ' 10 Create a query to show the all the fields in EMPOLYEE and SPORTS table where ENAME in descending order. Save the query as ES12. 11 Display EMPNO, EMPNAME, PLACE, SPORTS, YEAR AMOUNT fields in EMPOLYEE and SPORTS table whose EMPNAME= AHMED or SPORTS = FOOTBALL. Save the query as ES13

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

Related questions

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: am including the previous query, Do i revise a query? 13. Display the total number of flights that…

A: the solution is an given below :

Q: Using the code below, write a query to display the movie title, movie year, and movie genre for all…

A: Algorithm:Execute the CREATE TABLE SQL command to create a table named MOVIE with columns movie_id,…

Q: Question #8. From invoices table, write a query to retrieve everything (all columns), plus, add an…

A: The query is given in the below step

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: 6) Which query will output the table contents when the value of C_PRICE is not equal to 777? a.…

A: To do comparisons between two expressions, like equal, greater than, less than, greater than or…

Q: Question 1: Modify the select statement in this section to display the hire_date column in the…

A: SQL which refers to the domain specific that are used for the language and in the programming and…

Q: Your company needs to contact the 1st author of each textbook and to discuss reprint options. Pull…

A: Microsoft AccessMicrosoft Access is a relational database management system that allows you to…

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: using the code write a query to display the movie number, movie title, and price code for all movies…

A: Algorithm:Define a table named PRICE with columns PRICE_CODE, PRICE_DESCRIPTION, PRICE_RENTFEE, and…

Q: Create a trigger named trg_cust_charge that will automatically update the CUSTOMER table’s…

A: Create a view named "Atlanta_Charter_Crew_V” that includes the following “For each charter of…

Q: FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery…

A: Given subquery SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772

Q: Write a Query First to Alter Table to add a new Column managername to the employee table…

A: Q: Write a Query First to Alter Table to add a new Column managername to the employee table…

Q: Which line of the SELECT statement is used to restrict groups displayed in the query results?…

A: Select statement The select statement is used to select data from a database. The data returned is…

Q: Create a query to display all donors that live in City1, City2 or City3. Use the IN clause.

A: here In question ask query about IN clause Query: display all donors that live in City1, City2 or…

Q: Q1) Please write. a query statement from emp table to display deptno 10â€™s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: Create a query based on tblReservations that displays the guests that have reservations for all…

A: Structured Query Language, abbreviated as SQL, which usually refers to the one it is a…

Q: 3. Write a query that retrieves the following results (note the column names and order of results):

A: The required result needs to fetch below columns : Pub_id -> from publisher table Publisher's…

Q: If you include inanchor: in your query, Google will restrict the results containing the query terms…

A: The answer is written in step 2

Q: Animal animal_id name adopter_id Adopter adopter_id name Given the above data for an adoption…

A: Cross join : Each row from the first table is combined with each row from the second table using a…

Q: using the code below write a query to display the movie title, movie genre, price description, and…

A: Select Columns: Choose the columns to be displayed: MOVIE_TITLE, MOVIE_GENRE, PRICE_DESCRIPTION, and…

Q: For Film_ID 1, Rename the Title of the Film to INF 506 (if this gives an error, disregard it) For…

A: Answer is given below with proper explanation

Q: Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March…

A: Sql query to display all the movies with a return date of March 1, 2018, March 5, 2018, March 15,…

Q: Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: Create a query that uses any THREE of the tables (SCHOOL, DEPARTMENT, PROFESSOR, TECHNOLOGY &…

A: Creating all the three tables required for the question-For Department-create table…

Q: Write a select statement to create the inner join of tables sec1310_table1 and sec1310_table2. The…

A: The above question is solved in step 2 :-

Q: 10. Produce a list of each customer number and the third and fourth digits of his or her zip code.…

A: The query for a list of each customer number and the third and fourth digits of his or her zipcode…

Q: Create a query that lists all patients who have not had any appointment in the clinic in the last 2…

A: Note : As per guidelines , answering 1st 3 subparts of a question . Repost 4th part to get the…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

MS-ACCESS (.
1. Create a database COMPANY and create a new table EMPOLYEE and name it
2. Design a table EMPOLYEE so that it has all fields and the following properties
FIELDS
DATATYPE
PROPERTIES
EMPNO
Number
4
EMPNAΜΕ
Short Text
10
PHONE
Number
8
PLACE
Short Text
9.
DOJ
Date/Time
3. Set the field EMPNO as the primary key and save the table
4. Enter the following data into the table EMPLOYEE
EMPNO
ΕMPNAΜΕ
PHONE
PLACE
DOJ
1111
ΑΗMED
98989898 | IBRI
12/06/2014
2222
SARA
99997777 | NIZWA
15/09/2018
3333
AMNA
90909090 | MUSCAT
14/06/2017
4444
NAHID
91919191
IBRI
02/08/2015
5. Design a table SPORTS so that it has all fields and the following properties
FIELDS
DATATYPE
PROPERTIES
EMPNO
Number
4
SPORTS
Short Text
10
YEARS
Number
2
SCHOLARSHIP
YES/NO
AMOUNT
CURRENCY
6. Set the field EMPNO as the primary key and save the table
7. Enter the following data into the table SPORTS
EMPNO
SPORTS
YEARS
SCHOLARSHIP
AMOUNT
4444
FOOTBALL
YES
50
3333
BASKETBALL
NO
2222
FOOTBALL
1
NO
1111
CRICKET
YES
50
8. Create a relationship between two tables EMPOLYEE and SPORTS

9. Create a query to show all the fields in EMPOLYEE and SPORTS table. Save the query as ES11 '
10 Create a query to show the all the fields in EMPOLYEE and SPORTS table where ENAME in descending
order. Save the query as ES12.
11 Display EMPNO, EMPNAME, PLACE, SPORTS, YEAR AMOUNT fields in EMPOLYEE and SPORTS table
whose EMPNAME= AHMED or SPORTS = FOOTBALL. Save the query as ES13

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

CREATE TABLE sales ( SalesNumber INT(10) AUTO_INCREMENT PRIMARY KEY, SalesDate DATE, SalesTotal DECIMAL(10,2)); CREATE TABLE products ( number INT(11) AUTO_INCREMENT PRIMARY KEY, prodid VARCHAR(20) UNIQUE, prodname VARCHAR(30), price DECIMAL(10,2), onhand INT(11), CONSTRAINT fk_salesdetails_products FOREIGN KEY (prodid) REFERENCES salesdetails(prodid) ON DELETE RESTRICT); CREATE TABLE salesdetails ( number INT(10) AUTO_INCREMENT PRIMARY KEY, SalesNumber INT(10), prodid VARCHAR(20), price DECIMAL(7,2), qty INT(10), CONSTRAINT fk_salesdetails_sales FOREIGN KEY (SalesNumber) REFERENCES sales(SalesNumber) ON DELETE CASCADE, CONSTRAINT fk_salesdetails_products FOREIGN KEY (prodid) REFERENCES products(prodid) ON DELETE CASCADE); Using the above SQL and the schema diagram, create an ER diagram detailing all the fields of the tables and the relationship amount the tables.
Q1.Customers often ask for movies by actor. Write a query that lists the actors in the movies in the FLIX inventory. Your results should include the actor’s name (first and last) and the movie title. To help FLIX employees answer the customers’ questions quickly, sort the results by the actors’ last name and first name.Q2.FLIX would like to create a section of their inventory called “Classics.” To do this, they need to identify movies with a release date of at least 25 years ago. Of course, this 25-year age will change each year so be sure your query accounts for this.Write a query that identifies these movies. Your results should include the release date and the movie title. Sort your results by release date.Q3.FLIX managers want a report that lists All actors (whether they have been in one of the movies in the database or not.All movies (whether they have an actor associated with them or not.Sort results by the actor’s stage name.
Create a query to concatenate the street address so you print stadr followed by a comma and a space and then city followed by a comma and a space and then state followed by a space and then zip
1) Rewrite the query below to use GROUP BY CUS_CODE : SELECT CUSTOMER.CUS_CODE, CUSTOMER.CUS_LNAME, INVOICE.INV_NUMBER, INVOICE.INV_DATEFROM CUSTOMER INNER JOIN INVOICE ON CUSTOMER.CUS_CODE = INVOICE.CUS_CODE; 2) Rewrite the query below to include line items of each invoice : SELECT CUSTOMER.CUS_CODE, CUSTOMER.CUS_LNAME, INVOICE.INV_NUMBER, INVOICE.INV_DATEFROM CUSTOMER INNER JOIN INVOICE ON CUSTOMER.CUS_CODE = INVOICE.CUS_CODE; 3) Rewrite the query from 2) to show only the customers who bought a product priced higher than $100, which product, what price, how many units, and when.
WEEK 3 ASSIGNMENT Complete the following exercise: Using the student table you created in week two insert four rows into your table. Update the first name to “Luke” and last name to “Plew” for one of the rows you inserted above. Delete the row you updated above. Explain how you insert data in one table from another table. Your answer should be a minimum of three sentences in length.
WEEK 2 ASSIGNMENT Complete the following exercise: Using the student table you created in week one insert four rows into your table. Update the first name to “Luke” and last name to “Plew” for one of the rows you inserted above. Delete the row you updated above. Explain how you insert data in one table from another table. Your answer should be a minimum of three sentences in length.
Use departments. Create a query to display all the data from that table as one column. Separate each data value by a \ and add the \ at the start and end of the output row. Display the results in descending order of location id, and alpha order of department name within location id. Name the column title THE DEPARTMENTS OUTPUT.Ex: \20\Marketing\201\1800\
Create a View to show the city name of any location that has a department. Only show the city name once in the results. You must use a non-correlated subquery.Call this view: Department_LocationsInclude a second query to display from the View after it is created. Refer to the attached for the table.
using the code below write a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental CREATE TABLE MEMBERSHIP ( MEM_NUM NUMBER(8,0) PRIMARY KEY, MEM_FNAME VARCHAR2(30) NOT NULL, MEM_LNAME VARCHAR2(30) NOT NULL, MEM_STREET VARCHAR2(120), MEM_CITY VARCHAR2(50), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(10,2) ); CREATE TABLE RENTAL ( RENT_NUM NUMBER(8,0) PRIMARY KEY, RENT_DATE DATE DEFAULT SYSDATE, MEM_NUM NUMBER(8,0) CONSTRAINT RENTAL_MEM_NUM_FK REFERENCES MEMBERSHIP ); INSERT INTO MEMBERSHIP VALUES (102, 'TAMI', 'DAWSON', '2632 TAKLI CIRCLE', 'NORENE', 'TN', '37136', 11); INSERT INTO MEMBERSHIP VALUES (103, 'CURT', 'KNIGHT', '4025 CORNELL COURT', 'FLATGAP', 'KY', '41219', 6); INSERT INTO MEMBERSHIP VALUES (104, 'JAMAL', 'MELENDEZ', '788 EAST 145TH AVENUE', 'QUEBECK', 'TN', '38579', 0); INSERT INTO MEMBERSHIP VALUES (105, 'IVA',…
Task 3: The InstantRide Finance team wants to collect the price and discount information with the driver names for each travel in the system. You need to return the TRAVEL_ID, DRIVER_FIRST_NAME, DRIVER_LAST_NAME, TRAVEL_PRICE, and TRAVEL_DISCOUNT information from the TRAVELS and DRIVERS tables combined over DRIVER_ID field with the ON keyword. Task: Calculate each user's price and discount information. (SQL Database Test)
Using the Winners table from Figure 12-2, write a parameter query that selects only ananimated picture’s Year field.
create tables appointments having columns appointment id as primary key, appointment time, appointment date, doctor id doctors having doctor id as primary key, doctor name providers having provider id as primary key, provider first name, last name, username, password, office code. Now create a provider first name as Lilly , Last name as Brooks, username as Lily_777, password as Brooks_666. Validate on the database also show me the appointments with Dr.Alex at 10.30A.M