Primary Key: person_id; All the other fields are required. Primary Key: building
ID: 3731241 • Letter: P
Question
Primary Key: person_id; All the other fields are required.
Primary Key: building_id; All the other fields are required.
Primary Key: room_id; All the other fields are required.
Primary Key: meeting_id; ; All the other fields are required.
Primary Key: person_id, meeting_id
(Tom, Hanks)
(Anne", Hathaway)
(Tom, Cruise)
(Meryl", Streep)
(Chris, Pratt)
(Halle, Berry)
(Robert, De Niro)
(Julia, "Roberts")
(Denzel, "Washington)
(Melissa, McCarthy)
(Headquarters)
(Main Street Building)
(room_number, building_id, capacity)
(100, 1, 5)
(200, 1, 4)
(300, 1, 10)
(10, 2, 4)
(20, 2, 4)
meeting (room_id, meeting_start, meeting_end)
(1, 2016-12-25 09:00:00, 2016-12-25 10:00:00)
(1, 2016-12-25 10:00:00, 2016-12-25 12:00:00)
(1, 2016-12-25 11:00:00, 2016-12-25 12:00:00)
(2, 2016-12-25 09:00:00, 2016-12-25 10:00:00)
(4, 2016-12-25 09:00:00, 2016-12-25 10:00:00)
(5, 2016-12-25 14:00:00, 2016-12-25 16:00:00)
person_meeting (person_id, meeting_id)
VALUES
(1, 1)
(10, 1)
(1, 2)
(2, 2)
(3, 2)
(4, 2)
(5, 2)
(6, 2)
(7, 2)
(8, 2)
(9, 3)
(10, 3)
(1, 4)
(2, 4)
(8, 5)
(9, 5)
(1, 6)
(2, 6)
(3, 6)
Display the following columns:
- Person's first name
- Person's last name
- Building name
- Room number
- Meeting start datetime
- Meeting end datetime
Display the following columns:
- Person's first name
- Person's last name
- Building name
- Room number
- Meeting start datetime
- Meeting end datetime
Display the following columns:
- Person's first name
- Person's last name
- Building name
- Room number
- Meeting ID
- Meeting start datetime
- Meeting end datetime
Display the following columns:
- Count of meeting attendees
- Meeting ID
- Meeting start datetime
- Meeting end datetime
Display the following columns:
- Person's first name
- Person's last name
- Meeting ID
- Meeting start datetime
- Meeting end datetime”
Explanation / Answer
1.create database scheduling;
create databse query is used to create the database in mysql.
2. create table Person(person_id int primary key,first_name varchar(10),last_name varchar(10),not null(first_name,last_name));
3. create table Building (building_id int primary key,building_name varchar(10),not null(building_name));
4. create table Room(room_id int primary key, room_number int, building_id int, capacity int,not null(oom_number, building_id, capacity));
5. create table Meeting (meeting_id int primary key,room_id int,meeting_start time,meeting_end time,not null(room_id,meeting_start,meeting_end));
6. create table Person_meeting(person_id int,meeting_id int,primary key(person_id,meeting_id));
according to chegg policy i am unable to answer more than this. Please post the remaining as new post
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.