1. Using phpmyadmin, create a database named "YourName&ID" (for example, Fadi21930345). 2. Inside the database create the following tables, with the corresponding attributes. 1. Departments: Did, Title. 2. Employees: Eid, FirstName, LastName,Gender, Depld The id's should be set as unique (primary key) and auto increment The datatypes of the attributes should be valid. 3. Insert the following data into the tables of the database. Departments Did Title 1 Accounting L.T. Sales Emplovees Eid FirstName LastName Gender Depld 1 Ahmad Khatib Male 3 Rama Mizher Female 1 3. Rami Khattab Male 1 4. Hiba Masri Female Rida Fakhani Male 2. 2. 3

1. Using phpmyadmin, create a database named "YourName&ID" (for example, Fadi21930345). 2. Inside the database create the following tables, with the corresponding attributes. 1. Departments: Did, Title. 2. Employees: Eid, FirstName, LastName,Gender, Depld The id's should be set as unique (primary key) and auto increment The datatypes of the attributes should be valid. 3. Insert the following data into the tables of the database. Departments Did Title 1 Accounting L.T. Sales Emplovees Eid FirstName LastName Gender Depld 1 Ahmad Khatib Male 3 Rama Mizher Female 1 3. Rami Khattab Male 1 4. Hiba Masri Female Rida Fakhani Male 2. 2. 3

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 4PSE

See similar textbooks

Similar questions

2. 2. Import your database model When you think your database model is ready, use Forward Engineer feature in MySQL Workbench and import your model to your empty database created for this exam (Database  Forward Engineer …). If you encounter errors during the import process, check that your database model definitions are correct (for example the foreign key settings which are typically numbered as 12x or 15x). If you cannot import your database after searching for the cause for error, consult the teacher. In addition, remember to remove the VISIBLE words from the script before running it!
Use the information below to answer the question. What types of additional information and constraints would you like to represent in the schema? Think of several users of your database, and design a view for each. CREATE TABLE USER1 (SSN INT NOT NULL, FNAME VARCHAR2(20), M VARCHAR(1), LNAME VARCHAR2(20), ADDRESS VARCHAR2(100), PHONE INT, AGE INT, SEX VARCHAR(1), JOBTYPE VARCHAR2(30), ASTYPE VARCHAR2(30), ETYPE VARCHAR2(30), SHIFT VARCHAR2(20), POSITION VARCHAR2(30), AP_NAME VARCHAR2(100), PRIMARY KEY(SSN), FOREIGN KEY(AP_NAME) REFERENCES AIRPORT(AP_NAME) ON DELETE CASCADE); INSERT INTO USER1(SSN, FNAME, M, LNAME, ADDRESS, PHONE, AGE, SEX, JOBTYPE, ASTYPE, ETYPE, SHIFT, POSITION, AP_NAME) VALUES(123456789,'LINDA','M','GOODMAN','731 Fondren, Houston,…
Defineanomaly? What's the big deal about finding three outliers in a database? When will you take notice of the issues and provide a solution?
Please assist with the following Practie Excersises: You are given a database - MGMT2009_2024_Boutique Inc Student File.accdb, containing Currencies, Sales, and Locations tables to provide some results for MGMT Boutique INC. You should: 1. Rename the database as MGMT2009_Boutique_ is your actual name. 2. Create relationships between pairs of tables and enforce referential integrity (NUMBER 1 & 2 HAVE ALREADY BEEN DONE PLEASE DO NOT ANSWER) PLEASE ANSWER OR ASSIST WITH THE FOLLOWING: (KINDY SHOW AN EXAMPLE possibly using any or your won made up database of how the following is done since the actual database for this task is not avaiable) 3. Append two (2) new customers, two (2) old customers and two (2) new POS transactions. Be sure to include sales for your two new customers. 4. Create the following queries: a. List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS b. What is the total sales by…
Consider the database whose database state shown in appendix and answer the following questions: Retrieve the name of all employees who work in “Research” Department. Retrieve the department name and the location of that department. Retrieve the department number and the average salary for each department for department 5 and department 4. Write a PLSQL block that takes the department number and print the minimum and maximum salary for that department. write the PLSQL block that takes the social security number and print the full name, salary, and department number of that employee.appendix:
The following tables form part of a database held in a relational DBMS: Hotel (h) hotelNo, hotelName, cityRoom (r) roomNo, hotelNo, type, priceBooking (b) bookingNo, hotelNo, guestNo, dateFrom, dateTo, roomNoGuest (g) guestNo, guestName, guestAddress where the bolded attributes are the primary keys for the respective tables. Using theabove tables, answer the following questions: 1. Create a view containing the hotel name and the names of the guests staying at the hotel. 2. Create a view containing the account for each guest at the Grosvenor Hotel. 3. Give the user Manager full access to the above 2 views, with the privilege to pass the access on to other users. 4. Create a separate table with the same structure as the Booking table to hold archive records. 5. Using the INSERT statement, copy the records from the Booking table to the archive table relating to bookings before 1st January 2021. 6. Delete all bookings before 1st January 2021 from the Booking table.
You are given a database - MGMT2006_202324S02_Boutique Inc Student File.accdb, containing Currencies, Sales, and Locations tables to provide some results for MGMT Boutique INC. (That is, your CC will provide you with the database). You should: 1. Rename the database as MGMT2006_Boutique_ is your actual name. 2. Create relationships between pairs of tables and enforce referential integrity 3. Append two (2) new customers, two (2) old customers and two (2) new POS transactions. Be sure to include sales for your two new customers. 4. Create the following queries: a. List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS
Consider the following schema: Sailors(sid, sname, rating, age) Reserve(sid, bid, day) Boats(bid, bname, size) Reserve.sid is a foreign key to Sailors and Reserves.bid is a foreign key to Boats.bid. We are given the following information about the database: Reserves contains 10,000 records with 40 records per page. Sailors contains 1000 records with 20 records per page. Boats contains 100 records with 10 records per page. There are 50 values for Reserves.bid. There are 10 values for Sailors.rating in the range of [1, 10]. There are 10 values for Boat.size in the range of [1,10] There are 500 values for Reserves.day from Jan 1, 2003 to May 14, 2004 (all the 500 days in this range). SELECT S.sid, S.sname, B.bname FROM Sailors S, Reserves R, Boats B WHERE S.sid=R.sid AND R.bid = B.bid AND B.size>5 AND R.day=DATE ‘July 4, 2003’ Consider the following SQL query for the remaining questions: SELECT S.sid, S.sname, B.bname FROM Sailors S, Reserves R, Boats B WHERE S.sid=R.sid AND R.bid =…
Question 2 Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a database and name it MyFirstDatabase. Create two tables name Biodata and Contacts, choosing column names, datatypes primary keys and foreign key to link to tables. Insert twenty (20) into each table Take screenshot of the two tables, each showing all the records and save in a folder (Your name followed by index number). Obtain the ER diagram and save it in the above folder.
Implement your table design by creating table statements. Your tables should have constraints such as primary keys and foreign keys. (You can use MySQL Workbench or any other database management system of your choosing). Types such as Char, Integer must be correctly placed. 2) Add one trigger to your database that utilizes a default function of your DBMS 3) Add dummy data to your database. (5 manual entries for each table should be sufficient.) 4) Consider the nominal forms and integrity of your database, it will affect your grade. Export your database from your DBMS, zip it and submit the zip file. Thank you!
Consider the following database design: Also consider the virtual table ASSIGNMENTS, which doesn't meet the third normal form but is created by: CREATE VIEW ASSIGNMENT AS SELECT ASSIGN_NUM, ASSIGN_DATE, PROJ_NUM, EMPLOYEE.EMP_NUM, JOB.JOB_CODE AS ASSIGN_JOB, JOB_CHG_HOUR AS ASSIGN_CHG_HR, ASSIGN_HOURS, JOB_CHG_HOUR *ASSIGN_HOURS AS ASSIGN_CHARGE FROM ASSIGN, EMPLOYEE, JOB WHERE ASSIGN.EMP_NUM = EMPLOYEE.EMP_NUM AND EMPLOYEE.JOB_CODE = JOB.JOB_CODE; In SQL design the following queries for information search: Create and run a query to list employees who were hired before the year 1995. Create and run a query to list job code, job description, and employee last name, first name sorted by job description and employee last name. Create and run a query to list the name of employees who were assigned to the Rolling Tide project (which is one of the entries in the column PROJ_NAME). Create and run a query to list the project name, the number of employees worked for the project, and the…
create a database using the following entites and attributes: taxi: (taxi_id PK, registration_no, taxi_model, taxi_year, taxi_type, status, driver_id FK); USER: (Usr_id PK, F_name, L_name, Contat_no, Gender, Address, Taxi_id FK); DRIVER: (Driver_id PK, F_name, L_name, Gender, Conatct_no, Rating, Age); TRIP_DETAILS: (Trip_id PK, Trip_date, Trip_amount, Driver_id FK, Usr_id FK, Taxi_id FK , Strt_time, End_time) BILL_DETAILS: (Bill_no PK, Bill_date, Advance_amount, Advance_amount, Total_amount, Usr_id FK, Trip_id FK (unique)) CUSTOMER_SERVICE: (Emp_id PK, F_name, L_name) FEEDBACK: (Fbk_id PK, Message, Email , Emp_id FK (unique), Usr_id FK , Trip_id FK) owns: (Owner_id PK, number of cars) OWNER_TAXI ( Owner_id PK(FK), Taxi_id PK(FK)); INDIVIDUAL (ssn PK, individual name, owner_id FK); TAXI_SERVICE_COMPANY( Tsc_id PK, Tsc_name, Owner_id FK); NOTE: pk= Primary key, fk= foreign key