Consider the following schema for a company database andanswer the following questions:DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_dateMEMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary DnoMWORKS ON Esan Pno HoursPROJECTPname Pnumber PlocationQ1//create all tables of this schema and apply any necessaryconstraints

CREATE statement is used to create any table in the database. The language to create the data base…

Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start date IV EMPLOYEE Fname Minit Lname San Bdate Address Sex Salary Dno M WORKS ON Essn Pho Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints

Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start date IV EMPLOYEE Fname Minit Lname San Bdate Address Sex Salary Dno M WORKS ON Essn Pho Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints

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

Similar questions

Practical Tasks for Database Systems Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Question:2 Show the total length of (eno, deptno). joined it and rename by function from the employee table? Question:3 Show the ename first 3 alphabets of manager? Question:4 Write a query that show the manager data like this. ename job ***MANAGER *** MANAGER JONES BLAKE Question:5 Calculate the percentage of any student and round to 0 digit? Question:6 Show the last date of December 2014? Question:7 Show the date of next data base class and rename by cs-400? Question:8 Convert today date to character?
When constructing a database, the designer must know what types of relationships exist between records in different data sets, such as one- to-many or many-to-many. Give three examples for each of these relationships.
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
Describe the benefits of using a data dictionary in the database design phase.
For table EP, the attribute is a foreign key referencing target table For table EP, the attribute is a foreign key referencing target table For table ER the attribute is a foreign key referencing target table For table ER the attribute is a foreign key referencing target table
Create the following tables in your database with the following schema: Table: Employee | Column Name | Type | empId I name | supervisor | salary | int | varchar | | int | int empId is the primary key column for this table. Each row of this table indicates the name and the ID of an employee in addition to their salary and the id of their manager. Table: Bonus | Column Name | Type | | empId | bonus | int | int empId is the primary key column for this table. empId is a foreign key to empId from the Employee table. Each row of this table contains the id of an employee and their respective bonus. Add the following data to your tables: Input: Employee table: | empId | name | supervisor | salary | | 3 | Brad | null | 4000 | 1000 | 2000 | 4000 | John | 3 | 2 | 4 | Dan | 3 | Thomas | 3
Create a Crow’s Foot notation ERD to support the following business operations: A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business.   When a customer brings a device to PEAR for repair, data must be recorded about the customer, the device, and the repair. The customer’s name, address, and a contact phone number must be recorded (if the customer has used the shop before, the information already in the system for the customer is verified as being current). For the device to be repaired, the type of device, model, and serial number are recorded (or verified if the device is already in the system). Only customers who have brought devices into PEAR for repair will be included in this system.   Since a customer might sell an older device to someone else who then brings the device to PEAR for repair, it is possible for a device to be brought in for…
laddress q1) normalize the following database Payment Payment_id Member_id Payment_date Amount Payment_time Member_id SSN Equipment serial_num model_num equipment_type availability equipment_price Member_id 1SSN (FK) (FK) Member Member_id SSN date_joined Fname Mname Member_Class No. Member_id ISSN Class_id Membership Lname age MS id MS_level MS price DOJ expiry_date (FK) Email phone MS_id (FK) (FK) Staff_id (FK) SSN Staff Staff_id SSN DOJ Fname Mname SSN JO Class_id Instructor_Class No. Staff id (FK) Class (FK) Lname Jage laddress Email phone Manger_id Manger_SSN Class id cost class_date class_type class_time class_duration class_size Instructor Staff id SSN Specialty Certifications (FK) (FK)