Click New Query and type an SQL statement to create a database named myDB. Click the Execute button or press F5 to see the new database in the Object Explorer. Create queries to perform the next steps. Before writing the queries, type USE myDB; in the first line to use the database you have created in Step Create the tables named Customers and Product. Set the appropriate data types and determines which ones are supposed to be NOT Customers: CustomerID (Primary key), FirstName, LastName, Email, Gender, Birthdate Products: ProductID (Primary key), Description, Quantity, Price, VendorID Create another table named Vendors with columns: VendorID (Primary key), Name, ContactNum, CityAddress. Set VendorID from the Vendor table as a foreign key in the Products Save a copy of your queries since these will be used in the last laboratory session of the Pre-final period.

Access: Tables and Controls

how to Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: EMPLOYEE, STORE, REGION, and SUPPLIER Database.   Create a new user statement for the database.  The user name should be based on yourself containing your name.   Statements that grant privileges to the new user.  Statements granting privileges to at least 2 of the tables in the assigned database Statements that revoke privileges to the new user.  Statements revoking privileges to at least 2 of the tables in the assigned Database the home work data base: -- creating the RegionStore DataBase DROP DATABASE IF EXISTS RegionStore; CREATE DATABASE RegionStore; USE  RegionStore; -- creating the Region table CREATE TABLE Region ( regionID         VARCHAR(10), regionName       VARCHAR(50), supervisor       VARCHAR(50), CONSTRAINT PRIMARY KEY (regionID) ); -- creating the store table  CREATE TABLE Store  ( storeID           VARCHAR (10), storeAddress      VARCHAR (50), phone…

Design your application's/organization's database. You need to create the 3 tables for each of the services offered. You must provide at least 5 examples in each of the table. There must be a table in which you have prices linked to the services you are providing. THIS IS THE NAME & DESCRIPTION OF THE ORGANIZATION FOR WHICH YOU NEED TO CREATE 3 TABLES FOR EACH SERVICE PROVIDED *Name of the Organization* :: ECOHUB *Description of the Organization* :: EcoHub is a sustainability-focused organisation that seeks to encourage environmentally friendly behaviours, increase public knowledge of environmental problems, and offer solutions for people, organisations, and communities to reduce their carbon footprint and help make the world a greener place. We think that many little individual actions can have a big influence on the environment when taken together. *Services Offered by the Organization are*1. EcoConsultancy : We provide individualised eco-consultancy services to people and…

Database course

Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email:   In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information:   In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year:   Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…

Write Create Table SQL statements Work Session table  The table must have a primary key. The table must have appropriate foreign key constraints. Foreign keys must have the same name, datatype and size of the primary key that they refer to The following columns datatypes and sizes and named constraints must be used Column DataType Constraint WorkYear number(4) Range 2019 - 2020 WorkWeek number(2) Range 1-52 WorkHours number(4,2) Range 0.5 – 99.99 BID NUMBER(4) ,AUTHID NUMBER(4)

SQL DML/DDL There are five tables describing employees of a company, departments, buildings, which department(s) an employee works in (and a percentage of the time for each), and in which building an employee works (an employee may have more than one office). The primary key of each table is the attribute(s) in capitals and underlined. The foreign keys are in italics. Other attributes are not necessarily unique.Employee (EID, Ename, Salary, Start_Date, End_Date)Building (BID, Bname, Address)Department (DID, Dname, Annual_Budget)In_Department (EID, DID, Percentage_Time)In_Building (EID, BID)Write the SQL statements for the following.1. Find the names of Departments where NO employees work. 2. For employees who are still working in the company, end date has no value (empty). For those who have left the company and have end date values, show their names and the duration of their employment in years.  3. Find the names of buildings where more than 50 employees work.  4. The tables have…

Task 2: The Driver Relationship team wants to arrange workshops and education materials to the drivers. However, the team wants to create clusters of the drivers based on their experience in InstantStay. To collect these detail, you will need to create a SQL function called DRIVER_STATUS to determine the level of the driver as follows: MASTER: more than 4 travels PRO: more than 2 travels ROOKIE: 2 or less travels In addition, run the function to verify it works as expected and send them back the driver levels. Task: Create the DRIVER_STATUS function to create clusters of drivers based on experience.

The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.