Q1: Map the following ER diagram into a relational schema.DateTime_stampTimeSHIP_MOVEMENTLongitudeLatitudeHISTORYTypeTonnageHullSnameNSHIPΤΥPESHIP_TYPE(Owner(0;)Start_dateEnd_date(1,1)HOME_PORTSHIP ATPORTPORT_VISITContinentName(0;)N.1INSTATE/COUNTRYPnamePORTNameN1ONSEA/OCEAN/LAKE

SHIP(Sname(PK),Owner,SHIP_AT_PORT(FK OF PORT PNAME),HOME_PORT(FK OF PORT PNAME),TYPE(FK…

Q1: Map the following ER diagram into a relational schema. Date Time_stamp SHIP_MOVEMENT Time Longitude Latitude HISTORY Type Tonnage Hull Sname N SHIP TYPE SHIP_TYPE Owner (0.) Start_date End_date (1,1) HOME PORT SHIP AT PORT PORT_VISIT Continent Name (0,") N IN STATE/COUNTRY Pname PORT Name ON SEA/OCEAN/LAKE

Q1: Map the following ER diagram into a relational schema. Date Time_stamp SHIP_MOVEMENT Time Longitude Latitude HISTORY Type Tonnage Hull Sname N SHIP TYPE SHIP_TYPE Owner (0.) Start_date End_date (1,1) HOME PORT SHIP AT PORT PORT_VISIT Continent Name (0,") N IN STATE/COUNTRY Pname PORT Name ON SEA/OCEAN/LAKE

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Generate the table creation DDL for the schema. Consider the keysprimary and foreign.
How many of the relations in Johnny's logical database design have a composite primary key?
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.
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…
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