1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)

1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)

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

Related questions

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: Write SQL statements to (1) create the BREED table, (2) insert the data in Figure 3-21 into the…

A: Given: Write SQL statements to (1) create the BREED table, (2) insert the data in Figure 3-21 into…

Q: Given the default schema of a database: Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld…

A: A Foreign key is a field in a table that is used to reference the Primary key of another table. It…

Q: help with sql class 1.Report the student name, email, and entry date of all female students. The…

A: 1. Report the student name, email, and entry date of all female students. Query: SELECT student_name…

Q: rite the SQL statements to create all of the necessary tables to represent the above diagram,…

A: Note: Since you have not provided the database name to write the SQL query so I am using the MYSQL…

Q: Given the default schema of a database: Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld…

A: Please refer to the following step for the complete solution to problem above.

Q: Indicate the changes (using the shorthand representation) that you would need to make to the…

A: SOLUTION -

Q: 1-Write the syntax to create a relational table called staff that references an object table called…

A: Syntax for foreign key:- create table tableName(col1 data_type,col2 data_type,…., foreign…

Q: Seminar eminar ID Integer eminar Date Date Seminar Time Time ocation Seminar Title Address String…

A: As the customer may or may not attend the seminar or several seminars, the seminar and the customer…

Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…

A: All lower case Underscore separator between root and suffix Foreign keys have the same name as…

Q: What data types would you use for the attributes in this entity? How would you code a CREATE TABLE…

A: In a database management system (DBMS), an attribute is a piece of data that describes an entity.…

Q: Write a PL/SQL script to display two outputs on the screen: 1) the most recent registration date…

A: Introduction: PL/SQL is a strong database programming language that is very simple to learn. It's…

Q: The main aim of your project is to create a database schema consists of 3 tables suggested by…

A: We have to create a database schema consisting of 3 tables suggested byyourself and simulate it…

Q: Question 4 (Q4.sql): Use E/R style conversion for subclass DeptID: varchar(20) Departments…

A: The information from the given ER diagram: Departments: Name: nvarchar(50) DeptID: varchar(20)…

Q: Consider a database table named "EMPLOYEES" with the following columns: E_EMPLOYEEID, E_FIRSTNAME ,…

A: Understand the Requirement:Identify the table: In this case, the table is named "EMPLOYEES."Identify…

Q: I need help with understanding how to do the SQL code for the following question (attached is the…

A: As the table name is not shown in the picture, we are assuming the table name as Product. There are…

Q: ULL, Title VARCHAR2(30), TitleOfCourtesy VARCHAR2(25), BirthDate DATE, HireDate DATE, Address…

A: Dear Student, The required query with explanation is given below -

Q: Write SQL code for the following design schema of three tables. The tables should have the following…

A: - We need to design three tables with the requirements of constraints as provided.

Q: Using MySQL Workbench, create a new schema for this assignment and import assignment2.sql.…

A: ANSWER: Join the customers and shipping_details tables together based on PK/FK. The SQL should…

Q: Consider the following table in a relational database. Last Name Rank Room Shift Smith Manager 234…

A: A candidate key is an attribute or set of attribute which can identify all tuple uniquely.

Q: From the database scheme write the query(all tables are empty) 1) Insert your name and your phone…

A: The given diagram is a logical model for the rent of apartments where the apartment has a building…

Q: PLZ help with the following: Using Oracle SQL Translate your ER diagram into a relational schema…

A: E-R diagram is given where different entities and attributes are given from this we will create SQL…

Q: In database lab01, create 4 tables: course, advisor, student, and department (Note: The order of…

A: Generally the tables which do not have any dependency i.e. foreign keys will be created first so…

Q: In the Testa EV database described in the previous question, fill in the blanks in the following…

A: The solution is given below for the above given question:

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

COURSE (CourselD, CourseName)
REGISTRATION (StudentID, SectionNo, Semester)
CourselD
StudentID
SectionNo
Semester
CourseName
ISM 3113
ISM 3112
ISM 4212
ISM 4930
Syst Analysis
Syst Design
Database
Networking
38214
2714
1-2008
1-2008
1-2008
1-2008
54907
2714
54907
2715
66324
2713

1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate,
or change any data names, as needed for your SQL version). Assume the following attribute data
types:
StudentID (integer, primary key)
StudentName (25 characters)
FacultylD (integer, primary key)
FacultyName (25 characters)
CourselD (8 characters, primary key)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Write the appropriate SQL DDL statements to declare the relational libraryDatabase. Diagram of Figure 4.6. Select the keys and reference actions that are triggered.
(a) Write the sql syntax to create a table name Client with the following restrictions; Client(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname do not accept null values. Payment_mode accepts only cash or credit entries. The default address is “vacoas". client is at least 25 years old. Salary is above Rs 30000. (b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries. i. Using SQL, write the command to add a new column in the client table with the following data definition; (Column “gender" of char data type and field size of 1). ii. Using SQL, write the command to insert the values in the Client table. cid address age occupation salary Payment_mode gender cname 123 sam vacoas 31 manager 60000 cash m 124 david flacq 38 administrator 45000 credit m iii. Write the SQL query to display the cid of all employees. iv. Write the SQL code to list all administrators whose salary is greater than Rs…
database: sql Q1. Create the following tables: Carrier Attribute name Type Size Constraint carrierID Varchar2 10 Primary key carrierName Varchar2 100 NOT NULL Phone Varchar2 50 LIKE ‘+966%’ Range Varchar2 30 Value is either ‘International’ or ‘Local’ Review Attribute name Type Size Constraint ReviewID INT Primary key Stars INT NOT NULL Comment Varchar2 70 Name Varchar2 50 Default ’User’ CustomerID INT Foreign key references customers ProductID INT
a) from university database , Write the following queries in SQL Find the titles of courses in the Comp. Sci. department that have 3 credits Find all instructors earning the highest salary (there may be more than one with the same salary) Find all courses that have never been offered (i.e., do not occur in the section relation). b) given the following tables( instructor, teaches) what is the output of the following query select i.name from instructor as i, teaches as t where i.ID=t.ID and semester=’ Fall’ and year=2017;
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have not taken any courses. APPENDIX STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
use oracle sql developper or Oracle sql developper problem in picture the database CREATE TABLE MEMBERSHIP( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY,MEM_FNAME VARCHAR(30) NOT NULL,MEM_LNAME VARCHAR(30) NOT NULL,MEM_STREET VARCHAR(15),MEM_CITY VARCHAR(10),MEM_STATE CHAR(2),MEM_ZIP CHAR(5),MEM_BALANCE NUMBER (2)); ALTER TABLE MEMBERSHIPMODIFY MEM_STREET VARCHAR(25);CREATE TABLE RENTAL( RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENT_NUM_PK PRIMARY KEY,RENT_DATE DATE,MEM_NUM CHAR(3),CONSTRAINT RENTAL_MEM_NUM_FK FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP); CREATE TABLE PRICE(PRICE_CODE CHAR(1) CONSTRAINT PRICE_PRICE_CODE_PK PRIMARY KEY,PRICE_DESC VARCHAR(20),PRICE_RENTFEE NUMBER (3,1),PRICE_DAILYATFEE NUMBER(3,1)); CREATE TABLE MOVIE(MOVIE_NUM CHAR(4) CONSTRAINT MOVIE_MOVIE_NUM_PK PRIMARY KEY,MOVIE_NAME VARCHAR(30) NOT NULL,MOVIE_YEAR CHAR(4),MOVIE_COST NUMBER(5,2),MOVIE_GENRE VARCHAR(15),PRICE_CODE CHAR(1),CONSTRAINT MOVIE_PRICE_CODE_FK FOREIGN KEY (PRICE_CODE) REFERENCES…
Consider the following schema of hotel reservations database: Hotel (Hotel No, Name, City) Room (Room No, Hotel No, Type, Price) Booking (Hotel No, Guest No, Date From, Date_To, Room No) Guest (Guest_No, Name, City) Write RA queries for the following: a) Get the details (names and price) of all hotels in California. b) Get the average price of a room grouped by city. c) Find the hotel name and city of the hotel with the highest priced room. d) Get the hotel names and room numbers of any hotel rooms that have not been booked.
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.
Topic: Database Software: SQLite Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst)); CREATE TABLE title_episode (episodeID VARCHAR(45) NOT NULL,parentTconst VARCHAR(45) NULL, seasonNumber INT NULL,episodeNumber INT NULL, PRIMARY KEY (episodeID), CONSTRAINT parentTconst FOREIGN KEY (parentTconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_principals (tconst VARCHAR(45) NOT NULL, ordering INT NULL, nconst VARCHAR(45) NULL, category VARCHAR(45) NULL,job VARCHAR(45) NULL, characters VARCHAR(45) NOT NULL, PRIMARY KEY (tconst, characters), CONSTRAINT nconst FOREIGN KEY (nconst)REFERENCES name_basics (nconst) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT tconst FOREIGN KEY (tconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_ratings…
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have taken courses in both the Computer Science and Mathematics departments. APPENDIX - You may detach this page from the exam: STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
Given the following schema, answer the following questions USERS Attribute Data Type USER_ID NUMBER(3) USER_NAME VARCHAR2(20) USER_TYPE VARCHAR2(10) USER_LIMIT NUMBER(1) BOOKS Attribute Data Type BOOK_ID NUMBER(5) BOOK_TITLE VARCHAR2(25) BOOK_YEAR VARCHAR2(4) Write the SQL code that will create the tables structures for the tables named Books, and Users. Identify and include any PK and FK for both tables.