Portfolio Project Creating a Database

Projects Personal Projects
1

Giving feedback for the first time? AWESOME! Check out this video for a boost of confidence: How to Review Someone Else’s Code
Feel free to remove this message before posting.

Cheers!
—Codecademy Community Managers
movies made
column type max length default primary key null

column type max length default primary key null
id integer auto increment yes no Edit Delete
I am Legend text no Edit Delete
Water for Elephants text no Edit Delete
The Hunger Games text no Edit Delete

Add Column

Indexes

name p. key uniq columns type size

name p. key uniq columns type size
movies_made_pkey Yes Yes id btree 8192 bytes Delete
movies_made_id_idx No No id btree 8192 bytes Delete

Add Index

Studios
column type max length default primary key null

column type max length default primary key null
location text ‘Hollywood’::text yes no Edit Delete
movies_made text ‘movie_name’::text no Edit Delete

Add Column

Indexes

name p. key uniq columns type size

name p. key uniq columns type size
Studios_pkey Yes Yes location btree 16 kB Delete

Add Index

movies
column type max length default primary key null

column type max length default primary key null
name text ‘I am Legend’::text no Edit Delete
released integer 2008 no Edit Delete

Add Column

Indexes

name p. key uniq columns type size

name p. key uniq columns type size
movies_name_idx No No name btree 8192 bytes Delete

Add Index
directors
column type max length default primary key null

column type max length default primary key null
name text ‘Fracis Lawrence’::text yes no Edit Delete
movies_released text no Edit Delete

Add Column

Indexes

name p. key uniq columns type size

name p. key uniq columns type size
Directors_pkey Yes Yes name btree 8192 bytes Delete

Add Index

actors

column type max length default primary key null
name text ‘Will Smith’::text no Edit Delete
movies_produced text no Edit Delete

Add Column

Indexes

name p. key uniq columns type size

name p. key uniq columns type size
actors_name_idx No No name btree 8192 bytes Delete

Add Index

3

Hello

The below link directs to the Git Hub repo where can be found the summary of my answer to this Portfolio Project

I attempted to modelize the set of tables, data, roles, processes, necessary to support the information system used by a fictional football team throughout a season

I will be glad to see feedbacks!