Question: please write CREATE table queries in Postgre SQL of below erd channel ChannelID SMALLINT(6) ChannelName VARCHAR(45) UserID SMALLINT(6) Create Time DATETIME ModifiedTime DATETIME Indexes video

please write CREATE table queries in Postgre SQL of below erd

please write CREATE table queries in Postgre SQL of below erd channel

channel ChannelID SMALLINT(6) ChannelName VARCHAR(45) UserID SMALLINT(6) Create Time DATETIME ModifiedTime DATETIME Indexes video VideoID SMALLINT(6) Video Title VARCHAR(100) -I Videobesc VARCHAR (200) Videour VARCHAR(45) VideoSize INT (11) FileType VARCHAR(45) CreateTime DATETIME ModifiedTime DATETIME PostedByUserID SMALLINT(6) + Thumbnail ID SMALLINT(6) VideoScope VARCHAR(45) VideoPath VARCHAR(100) Indexes view_getmost downloadvideo comment Comment SMALLINT (6) Content VARCHAR(200) UserID SMALLINT (6) VideoID SMALLINT(6) IsReply TINY INT(1) Reply ParentCommentID SMALLINT(6) Create Time DATETIME ModifiedTime DATETIME Indexes Triggers memberauth Member AuthID SMALLINT (6) username VARCHAR(45) Password VARCHAR(45) notification Notification ID SMALLINT (6) i NotifiedByUserID SMALLINT(6) Create Time DATETIME Modified Time DATETIME ! Read TINYINT(1) 11 i ! Indexes 11 il - 1 Indexes Til 1 1 I!! 7 download DownloadID SMALLINT(6) UserID SMALLINT (6) VideoID SMALLINT(6) CreateTime DATETIME Modified Time DATETIME Indexes Triggers subscriber Subscriber ID SMALL INT(6) UserID SMALLINT (6) 6 ChannelID SMALLINT(6) Create Time DATETIME Modified Time DATETIME Indexes videoview VideoViewID SMALLINT(6) UserID SMALLINT (6) CreateTime DATETIME ModifiedTime DATETIME VideoID SMALLINT(6) Indexes Triggers 1 playlistvideo Playlist ideoID SMALLINT(6) VideoID SMALLINT(6) Prionty TINYINT (4) PlaylistD SMALLINT(6) Indexes entitylike EntityLikeID SMALLINT(6) isDislike TINYENT(1) UserID SMALLINT (6) (6 Create Time DATETIME Modified Time DATETIME VideoID SMALLINT(6) CommentID SMALLINT (6) Indexes Triggers search history SearchHistoryID SMALLINT (6) Search Content VARCHAR(200) CreateTime DATETIME User ID SMALLINT (6) Indexes 1 watchlatervideo Watch Later VideoID SMALLINT(6) VideoID SMALLINT(6) (6 UserID SMALLINT (6) Indexes playlist Playlist SMALLINT(6) PlaylistName VARCHAR(45) - User ID SMALLINT (6) Indexes 1 1 1 view_getmostviewedvideo offlinevideo Offline VideoID SMALLINT (6) VideoID SMALLINT(6) UserID SMALLINT (6) Indexes watchhistory Watch HistoryID SMALLINT (6) UserID SMALLINT (6) VideoID SMALLINT(6) 6 Create Time DATETIME Indexes channelvideo Channel ideoID SMALLINT(6) VideoID SMALLINT(6) ChannelID SMALLINT(6) Indexes videospeccount VideoSpecCountID SMALLINT (6) VideoID SMALLINT(6) VideoView Count TINYINT(4) VideoLikeCount TINYINT(4) VideoDislikeCount TINYINT(4) Video DownloadCount TINYINT(4) VideoCommentCount TINY INT (4) Indexes accountsettings AccountsettingsID SMALLINT (6) Language VARCHAR(45) Location VARCHAR(45) IsRestricted TINYINT(1) LUser ID SMALLINT (6) Indexes member Member ID SMALLINT(6) FirstName VARCHAR(45) LastName VARCHAR(45) EmailD VARCHAR(255) -BirthDate DATE -It Gender CHAR(1) + Phone VAROHAR (20) -- Country VARCHAR(45) Create Time DATETIME HE ModifiedTime DATETIME Member AuthID SMALLINT (6) Indexes view_getmostlikedvideo channel ChannelID SMALLINT(6) ChannelName VARCHAR(45) UserID SMALLINT(6) Create Time DATETIME ModifiedTime DATETIME Indexes video VideoID SMALLINT(6) Video Title VARCHAR(100) -I Videobesc VARCHAR (200) Videour VARCHAR(45) VideoSize INT (11) FileType VARCHAR(45) CreateTime DATETIME ModifiedTime DATETIME PostedByUserID SMALLINT(6) + Thumbnail ID SMALLINT(6) VideoScope VARCHAR(45) VideoPath VARCHAR(100) Indexes view_getmost downloadvideo comment Comment SMALLINT (6) Content VARCHAR(200) UserID SMALLINT (6) VideoID SMALLINT(6) IsReply TINY INT(1) Reply ParentCommentID SMALLINT(6) Create Time DATETIME ModifiedTime DATETIME Indexes Triggers memberauth Member AuthID SMALLINT (6) username VARCHAR(45) Password VARCHAR(45) notification Notification ID SMALLINT (6) i NotifiedByUserID SMALLINT(6) Create Time DATETIME Modified Time DATETIME ! Read TINYINT(1) 11 i ! Indexes 11 il - 1 Indexes Til 1 1 I!! 7 download DownloadID SMALLINT(6) UserID SMALLINT (6) VideoID SMALLINT(6) CreateTime DATETIME Modified Time DATETIME Indexes Triggers subscriber Subscriber ID SMALL INT(6) UserID SMALLINT (6) 6 ChannelID SMALLINT(6) Create Time DATETIME Modified Time DATETIME Indexes videoview VideoViewID SMALLINT(6) UserID SMALLINT (6) CreateTime DATETIME ModifiedTime DATETIME VideoID SMALLINT(6) Indexes Triggers 1 playlistvideo Playlist ideoID SMALLINT(6) VideoID SMALLINT(6) Prionty TINYINT (4) PlaylistD SMALLINT(6) Indexes entitylike EntityLikeID SMALLINT(6) isDislike TINYENT(1) UserID SMALLINT (6) (6 Create Time DATETIME Modified Time DATETIME VideoID SMALLINT(6) CommentID SMALLINT (6) Indexes Triggers search history SearchHistoryID SMALLINT (6) Search Content VARCHAR(200) CreateTime DATETIME User ID SMALLINT (6) Indexes 1 watchlatervideo Watch Later VideoID SMALLINT(6) VideoID SMALLINT(6) (6 UserID SMALLINT (6) Indexes playlist Playlist SMALLINT(6) PlaylistName VARCHAR(45) - User ID SMALLINT (6) Indexes 1 1 1 view_getmostviewedvideo offlinevideo Offline VideoID SMALLINT (6) VideoID SMALLINT(6) UserID SMALLINT (6) Indexes watchhistory Watch HistoryID SMALLINT (6) UserID SMALLINT (6) VideoID SMALLINT(6) 6 Create Time DATETIME Indexes channelvideo Channel ideoID SMALLINT(6) VideoID SMALLINT(6) ChannelID SMALLINT(6) Indexes videospeccount VideoSpecCountID SMALLINT (6) VideoID SMALLINT(6) VideoView Count TINYINT(4) VideoLikeCount TINYINT(4) VideoDislikeCount TINYINT(4) Video DownloadCount TINYINT(4) VideoCommentCount TINY INT (4) Indexes accountsettings AccountsettingsID SMALLINT (6) Language VARCHAR(45) Location VARCHAR(45) IsRestricted TINYINT(1) LUser ID SMALLINT (6) Indexes member Member ID SMALLINT(6) FirstName VARCHAR(45) LastName VARCHAR(45) EmailD VARCHAR(255) -BirthDate DATE -It Gender CHAR(1) + Phone VAROHAR (20) -- Country VARCHAR(45) Create Time DATETIME HE ModifiedTime DATETIME Member AuthID SMALLINT (6) Indexes view_getmostlikedvideo

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q2. Please write "create table" SQL code for "Staff" table with following constraints (staffNo Unique, sex check(F or M), branchNo Foreign Key). (25 points)

Write Create Table commands to create the three tables above in your database and create a primary key for each table. Add any foreign keys as appropriate. Include in your answer the table creation...

CSIS 325 Lab 4 (SQL CREATE TABLE) Before beginning this lab, be sure you have successfully downloaded and installed SQL Server Express 2014: (You should have already done this in your first lab, but...

For this weeks activity, we will practice queries in hive. Please write your answers (queries) for the following two questions: In Hive, please create a table called employees with four columns:...

HELP IN RELATIONAL DATABASE SYSTEMS Chapter 5 HW 321 1: What is the purpose of DDL SQL statements? 6: What is the purpose of the SELECT command? 7: What is the purpose of the WHERE condition? 13:...

Can I please get help on these questions. There are 4 problems about conversion of an ERD to a table design and ERD errors. For each conversion problem, you can use an abbreviated table design with...

SQL create table queries : Create table author( Authorid int primary key, Name varchar (20), Surname varchar(20), Gender varchar (20), Birthdate date , Country varchar (20) ); Create table book( ISBN...

*Please write out the queries that would be entered into a SQL Server* Complete the queries listed below in SQL Server. Use AdventureWorks2014 database to work on the assignment. When creating a...

Please write your answers (queries) for the following two questions: In Hive, please create a table called employees with four columns: column essn (employee SSN) has type String column name has type...

You have been hired by a small dental practice to design and implement their database. The practice is owned by two dentists and both would like to use an Oracle database. They have received good...

Holes 1 through 4 are clearance holes for machine screws. What size machine screw were these made for? #6 #8 #10 #12 1/4 5/16 3/8 Note: The part is symetric with respect to datum B. -.020 4x0.2010...

An inductor has a 54.0- reactance at 60.0 Hz. What is the maximum current if this inductor is connected to a 50.0-Hz source that produces a 100-V rms voltage?

Exercise 6.11 Direct Memory Access (DMA) allows devices to access memory directly rather than working through the CPU. This can dramatically speed-up the performance of peripherals, but adds...

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...