# data[].attributes.body
1. Movies, Actors, Directors
2.What should be the colums of the tables?
How the tables are link to each others by primary key and foreign key?
Student(M_No(PK),Nname,Age,Email,Address)

Movies(M_Name(PK), genre, D_Name(FK), A_Name(FK), description)

Directors(D_Name(PK), Age Email, Phone_no)

Actors(A_Name(PK), Age, Email,Country)

# data[].attributes.headline
The following students participated in this activity

# data[].attributes.subject
The following students participated in this activity

# data[].attributes.body
Attendance 12 October

Most of your answers are correct except two students.

I have given comments for them

1. ONG HUI XIN (62322)

2. MAXQUEEN AK KENNEDY (61400)

3. SAW TUN ONG 62467

4. Nurul Afifah Binti Yaakub (62192)

5. Nursyafiqah 54929

6. Veronica Jeramau Ak Idon (62857)

7. GOH CHENG LYNN (60858)

8. Tharshiny Ravi (62790)

9. SITI FAIRUZ CHAN BINTI

10. AMIN CHAN (63792)

11. AMELIA ATIZA ANAK RICKY (63936)

12. MEOR MUHD MUAZ BIN MEOR MOHD

13. SHARIFFUDIN (61411)

14. LO YONG EN 61316

15. NUR RIZANIFA(62065) What are you talking about?

16. NURUL DIYANAH AFIQAH

17. BINTI ROSMADI (62237)

18. Nazira Binti Hassan 63508

19. Natalie Chandu anak Andin 61712)

20. Ainin Sofia Binti Jusoh (60195)

21. NUR ATHIRAH AFFENDI (53106)

22. WONG WOEI SHENG 62942

23. Yee Chee Ling (62956)

24. Tee Bee Lin (62754)

25. NURUL SYAZWANI BT

26. ABDUL RASHID (54964)

27. Nur Sakilah Binti Ahmad Fuad (62070)

28. NURIN ZATY HANANI BINTI MARZUKI (62159)

29. Wee Tze Ni 62907

30. Charmaine 60484 Sir can we use other examples?

If we create a database regarding to store information about a catalogue of hardware equipment and materials.

My answer is No

# data[].attributes.body
After reading the database design slides. Every one try,
1. What tables we need?
table 1: movie
table 2: artist
table 3: director

2. What should be the columns of the tables?
table movie:
column 1: ID
column 2: title
column 3: runningTime
column 4: description
column 5: genre
column 6: artistID
column 7: directorID
column 8: keyword

table artist:
column 1: ID
column 2: name
column 3: gender
column 4: age
column 5: nationality

table director:
column 1: ID
column 2: name
column 3: gender
column 4: age
column 5: nationality

How the tables are link to each others by primary key and foreign key?
table movie:
(PK) ID

table artist:
(PK) ID <---> (FK) artistID from table movie, with many-to-many relation

table director:
(PK) ID <---> (FK) directorID from table movie, with one-to-many relation

Design the tables here like
Student(M_No (PK), Name, email, address)
a) movie (ID (PK), title, runningTime, description, genre, artistID (FK), directorID (FK), keyword)
b) artist (ID (PK), name, gender, age, nationality)
c) director (ID (PK), name, gender, age, nationality)

# data[].attributes.body
Answers :
1.- Actors
-Movies
-Director

2.
-Actors ( A_ID (PK),   Name, Gender, Age, Address, PhoneNo,  Email).
-Movies (M_ID (PK), Tittle, Genre, Description, Running Time, Actors (FK), Director (FK)).
-Director (D_ID (PK), Name, Gender, Age, Address, PhoneNo,  Email)

# data[].attributes.body
1. What tables we need?
i)Actors
ii)Movies
iii)Director

2. What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?
i) Actors (A_ID (PK), Name, Gender, Phone_Number, Address, Email)

ii)Movies (M_ID (PK), Title, Description, Genre, Running_time, Director (FK), Actors (FK))

iiiDirector(D_ID(PK), Name, Gender, Phone_Number, Address,Email)

# data[].attributes.body
1. what tables do we needs?
a)movie
b)actor
c)Director

2)What hould be the columns of the tables?How are the tables link to each others by PK and FK?Design the tables here like Student(M_No(PK),Name, email, address)
a)movie(m_ID(PK), title, running time, description, actor (FK), director (FK))
b)actor (a_ID(PK), name, gender, age, origin)
c)Director (d_(PK), name, gender, age, company name)

# data[].attributes.body
1. Tables that we need:
Answer:
The table are named as Movies, Directors and Actors.

2. What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?
Design the tables here like
Student(M_No (PK), Name, email, address)

Answer:
Movies(MoviesID(PK), Title, Description, Genre, Director(FK), Actors(FK), runningTime)

Directors(DirectorID (PK), DirectorName, Gender, phoneNo, Address, Email)

Actors(ActorID(PK),

ActorName, Gender, PhoneNo, Address, Email)

# data[].attributes.body
1a)What tables do we need?
-movies
-directors
-actors
2. What should be the columns of the tables?How are the tables link to each others by PK and FK? Design the tables here like Student(M_No(PK),Name,email,address)
-Movies(Movie_ID(PK), MoviesTitle, Description, Genre, runningTime, Director(FK), Actors(FK))

-Actors(Actors_ID (FK), ActorsName, Gender, TelephoneNo, Address, Email)

-Directors(Director_ID (FK), DirectorsName, Gender, TelephoneNo, Address, Email)

# data[].attributes.body
1.      What tables we need?

a)      movies

b)      actors

c)      directors

2.      What should be the columns of the tables?

How the tables are link to each others by primary key and foreign key? Design the tables here like
Student(M_No (PK), Name, email, address)

a)      Movie(mov_ID(PK), mov_Title, act_ID(FK), dir_ID(FK), runningTime)

b)      Artist(act_ID(PK), artName, mov_ID(FK), gender, age, Contact, email)

c)      Director(dir_ID(PK), dirName, mov_ID(FK), gender, age, contact, email)

# data[].attributes.headline
MEOR MUHD MUAZ BIN MEOR MOHD SHARIFFUDIN (61411)

# data[].attributes.subject
MEOR MUHD MUAZ BIN MEOR MOHD SHARIFFUDIN (61411)

# data[].attributes.body
1. Tables that we need:
(a) Movies
(b) Directors
(c) Actors

2. What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?
Design the tables here like
Student(M_No (PK), Name, email, address)

(a) Movies(Movies_ID(PK), Title, Description, Genre,Director(FK), Actors(FK),running_Time)

(b) Directors(Director_ID (PK), Dir_Name, Gender, Phone_No, Address, Email)

(c) Actors(Actor_ID(PK),

Act_Name, Gender, Phone_No, Address, Email)

# data[].attributes.body
Here the answers

1. What tables we
need?

Answer: Tables named Movie, Artists and Directors.

2. What should be
the columns of the tables?
How the tables are link to each others by primary key and foreign key?
Design the tables
here like
Student(M_No (PK),
Name, email, address)

Answer: For these table, details are shown as below

(a)Movie (Movie_ID (PK), Title, description, genre, artists_name (FK), director_name(FK), running_time)

(b)Artists (artist_name (PK), gender, age, telephone_No, email, movie_involved)

(c)Directors (director_name (PK), gender, age, telephone_No, email, movie_directed)

# data[].attributes.body
1.what tables we need
a)Movies
b) Artist
C) Director

2. what should be the columns of the tables

a) Movies(M_ID)(PK), Title, Description, Genre,RunningTime, Director(PK), Actors(FK))

b)Directors(DD_ID(FK),Name,Gender, Address, Email)

c)Actors(A_ID(FK) Name, Gender,Nophone,Address, Email

# data[].attributes.body
Database_Films

1. What tables we need?
2. What should be the columns of the tables?

Table- Movies
Columns -name
-description
- date of release
- running time
- director
-genre
-main cast
-ratings
-Unique ID

Table - Director
Columns - director name
-age
-country
-birthday
-awards
-movies

Table - Star
Columns -actor name
-age
-country
-birthday
-awards
-movies

Database Design

Movies(movie_unique_ID(PK),movie_name,description,release_date,running_time,genre,dir_name(FK),actor_name(FK),ratings)

Director(dir_name(PK),dir_age,dir_country,dir_birthday,dir_awards,dir_movies)

Star(actor_name(PK),actor_age,actor_country,actor_birthday,actor_awards)

Note: The Foreign key in the main table (actor name and director name) links to the corresponding primary keys in the child table.

# data[].attributes.body
Database Design

1.      What tables we need?

a)      movies

b)      artists

c)      directors

2.      What should be the columns of the tables?

How the tables are link to each others by primary key and foreign key? Design the tables here like
Student(M_No (PK), Name, email, address)

a)      Movie(movieID(PK), movieTitle, description, genre, artID(FK), dirID(FK), runningTime)

b)      Artist(artID(PK), artName, movieID(FK), gender, age, phoneNo, email)

c)      Director(dirID(PK), dirName, movieID(FK), gender, age, phoneNo, email)

# data[].attributes.body
After reading the database design slides. Every one try,
1. What tables we need?
(A) movie
(B) actor
(C) director

2. What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?
TABLE AS SHOWN BELOW
(A) movie(m_ID(PK), title, running_time, description, actor(FK), director(FK))

(B) actor(a_ID(PK), name, gender, age, origin)

(C) director(d_ID(PK), name, gender, age, company name)

# data[].attributes.body
1.What tables we need?

a)      Movies

b)      Directors

c)       Actors

2. What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?
Design the tables here like
Student(M_No (PK), Name, email, address)

(a) Movies(M_ID(PK), Title, Description, Genre, runningTime, Director(FK), Actors(FK))

(b) Directors(D_ID (FK), Name, Gender, TelNo, Address, Email)

(c) Actors(A_ID(FK) Name, Gender, Telephone_no, address, email)

# data[].attributes.body
After reading the database design slides. Every one try,
1. What tables we
need?
2. What should be
the columns of the tables?
How the tables are
link to each others by primary key and foreign key?
Design the tables
here like
Student(M_No (PK),
Name, email, address)

1.      Answer: Tables named Movie, Artists and Directors

2.      Answer: For these table, details are shown as below

Movie (Movie_ID (PK), Title, description, genre, artists_name (FK), director_name(FK), running_time)

Artists (artist_name (PK), gender, age, telephone_No, email, movie_involved)

Directors (director_name (PK), gender, age, telephone_No, email, movie_directed)

# data[].attributes.body
After reading the database design slides. Every one try,
1. What tables we need?
Product
Stock
Pricing
2. What should be the columns of the tables?

Product(IDproduct(PK), ProductName, Brand, Country)

Stock(IDprod(FK), Unit, Damage)

Pricing(ID(FK), Price, SpecialPrice)

# data[].attributes.body
After reading the database design slides. Every one try,
1. What tables we need?

# data[].attributes.body
1. Artist, Director, Movie.

2.
a) Artist (Artist_ID(PK), Name)

b) Director (Director_ID(PK), Name)

c) Movie (Movie_ID(PK), Title, Description, Genre, RunningTime, Artist_ID(FK), Director_ID(FK) )

# data[].attributes.body
1. What tables we need?
a) Movies
b) Directors
c) Actors

2.What should be the columns of the tables?
Movies(M_ID(PK), Title
How the tables are link to each others by primary key and foreign key?

Movies(M_id(PK), Title, Description, Genre, runningTime, Director(FK), Actors(FK))

Directors(D_id(FK), Name, Gender, TelephoneNum, Address, Email)

Actors(A_id(K), Name, Gender, TelephoneNum, Address, Email)

# data[].attributes.headline
NURUL DIYANAH AFIQAH BINTI ROSMADI (62237)

# data[].attributes.subject
NURUL DIYANAH AFIQAH BINTI ROSMADI (62237)

# data[].attributes.body
1. What tables we need?
a) Movies
b) Directors
c) Actors

2.What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?

a) Movies(M_ID(PK), Title, Description, Genre, runningTime, Director(FK), Actors(FK))

b) Directors(D_ID (FK), Name, Gender, TelephoneNo, Address, Email)

c)  Actors(A_ID (FK), Name, Gender, TelephoneNo, Address, Email)

# data[].attributes.body
Directors(D_ID (PK), Name, Gender, TelephoneNo, Address, Email)

# data[].attributes.body
1.what table we need?
1)movies
2)director
3)actors

2.what should be the columns of the table?how the tables are link to each others by primary key and foreign key?

a)movie(M_id(pk),title,genre,running time,description ,director(fk)actors(fk)
b)directors(d_id (fk),name,gender,telephone no,adress,email)
c)actor(a_id(fk),name,gender,telephoneno,address,email.

# data[].attributes.body
1. What tables  do we need?
a) Movies
b) Artists
c) Directors

2. What should be the column of the tables?
How the tables are link to each others by primary key and foreign key?
i) movie - (MovieTitles(PK), Description, Genre, RunningTime, KeyWord, Artists(FK), Director(FK)
ii) ArtistName(PK), MovieInvolved(FK)
iii) DirectorName(PK), MovieInvolved(FK)

# data[].attributes.headline
SITI FAIRUZ CHAN BINTI AMIN CHAN (63792)

# data[].attributes.subject
SITI FAIRUZ CHAN BINTI AMIN CHAN (63792)

# data[].attributes.body
1. What tables we need?
(a) Movies
(b) Directors
(c) Actors

2. What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?
Design the tables here like
Student(M_No (PK), Name, email, address)

(a) Movies(M_ID(PK), Title, Description, Genre, runningTime, Director(FK), Actors(FK))

(b) Directors(D_ID (PK), Name, Gender, TelephoneNo, Address, Email)

(c) Actors(A_ID(PK),

Name, Gender, TelephoneNo, Address, Email)

# data[].attributes.body
1. What tables we need?
The tables needed are :
Director, Actor, and Movie.

2.What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?

Director(D_id(PK), Name, Gender,Telephone, Address, Email)

Actor(A_id(PK), Name, Gender, Telephone, Address, Email)

Movie(M_id(PK), Title, Description, Genre, runningTime, Director(FK), Actor(FK))

# data[].attributes.body
1. What tables we need?
- Actors, Movies, Director

2. What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?
- Actors (A_ID (PK), Name, Gender, Telephone, Address, Email)

- Movies (M_ID (PK), Title, Description, Genre, Running_time, Director (FK), Actors (FK))

-Director(D_ID(PK), Name, Gender, Telephone, Address,Email)

# data[].attributes.body
Nursyafiqah 54929

after reading the database design slide.
1. what table we need is a :
- movies
- directors
- actors

2. Column that need is :
- movies (M_ID (PK), Title, Description, Genre, Running_Time, director(FK), actors(FK))

- directors(D_ID(PK), name, gender, contact_no, address, email)

-actors(A_ID(PK), name, gender, contact_no, address,email)

# data[].attributes.body
Sir can we use other examples?

If we create a database regarding to store information about a catalogue of hardware equipment and materials.

1. Tables: Customer, Supplier, Shop

2. Columns that we need is example:
Product name, product type, product id, unit available, supplier price, purchasing price, customer's hand phone number, supplier's hand phone number, ......

Supplier (Supplier_ID, Product_ID, Product_Unit, Supplier_HpNO, Supplier_price, Supplier_PaymentDate, Supplier_PaymentPrice, Supplier_email)

Customer (Customer_ID, Product_ID, Product_Unit, Customer_HpNO, Customer_price, Customer_PaymentDate, Customer_PaymentPrice, Customer_email)

Shop (Product_ID, Product_Unit, Customer_ID, Customer_price, Customer_PaymentDate, Customer_PaymentPrice)

# data[].attributes.body
After reading the database design slides. Every one try,
1. What tables we need?
2. What should be the columns of the tables?
How the tables are link to each others by primary key and foreign key?
Design the tables here like
Student(M_No (PK), Name, email, address)