2. Consider the entity-relationship diagram below: aid ema1l gender integer is c

Question

2. Consider the entity-relationship diagram below: aid ema1l gender integer is client of text text char PhoneNum text birthdate dat togethe date text What do the constraints on the three relationship types (is client of, developing, contracted to work together) indicate about the participation and cardinality of the related entity types? (note that the box containing contractDate is not an entity, contractDate are attributes of the relationship type contracted to work together.) Derive and show a relational database schema from the entity-relationship diagram in problem 2. Develop primary and foreign keys as appropriate to represent the relationship types of the ER diagram. Remember to develop a relational database table for any relationship type that requires it. Use the schema format describe in the course project. Implement your relational database schema from problem 3 using the SQL DDL. 3. 4.

Explanation / Answer

If you have any doubts, please give me comment...

2)

An Agent is client of one or more Actors, but Actor must have one Agent.

An Actor contracted contracted to work together with one or more Projects with a Producer, while taking contact must take contract Date between them

A Producer developing one or more Projects and a project have multiple producers.

3)

Agent(aid: integer, name:text, PhoneNum:text);

Actor(aid:integer, name:text, email:text, phone:text, gender:char, birthdate:date, agent_id:integer);

Producer(pid:integer, name:text, PhoneNum: text);

Projects(pid: integer, name:text, genre: text);

contracted_work_together(actor_id:integer, producer_id:integer, project_id: integer, contractDate: date);

developing(project_id: integer, producer_id:integer);

4)

CREATE TABLE Agent(

aid integer not null primary key,

name varchar(100),

PhoneNum varchar(15)

);

CREATE TABLE Actor(

aid integer not null primary key,

name VARCHAR(100),

email VARCHAR(100),

phone VARCHAR(15),

gender char(1),

birthdate date,

agent_id integer,

foreign key(agent_id) references Agent(aid)

);

CREATE TABLE Producer(

pid integer not null primary key,

name VARCHAR(100),

PhoneNum VARCHAR(15)

);

CREATE TABLE Projects(

pid integer not null primary key,

name varchar(100),

genre varchar(100)

);

CREATE TABLE contracted_work_together(

actor_id integer,

producer_id integer,

project_id integer,

contractDate date,

foreign key(actor_id) references Actor(aid),

foreign key(producer_id) references Producer(pid),

foreign key(project_id) references Project(pid)

);

CREATE TABLE developing(

project_id integer,

producer_id integer,

foreign key(producer_id) references Producer(pid),

foreign key(project_id) references Project(pid)

);

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.