INFS2001 Database Design and Development-attributes are needed for this answer

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

Enter e-mail

Phone no

Pages

250 words

Deadline

Order description (write / attach)

I accept the T&C and other policies of the website and agree to receive offers and updates.

Students Who Viewed This Also Studied

10 Pages

MIS201 Database Programming Project

Task: Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Analysing specific organisational needs that can be addressed by colle ...

Course

MIS201

Type

Programming

Subject

Database

University

Torrens University

View Document

20 Pages

HS2021 Database Design and Use

Questions: Purpose: This assignment is designed to assess your level of knowledge of the key topics covered in this unit. Unit Learning Outcomes Assessed:1. Design and implement a relation ...

Course

HS2021

Type

Programming

Subject

Database

University

Holmes Institute

Season

Spring

View Document

33 Pages

The Implemented Database Payments

Running Head: ITECH 1103 BIG DATA AND ANALYTICS ITECH 1103 BIG DATA AND ANALYTICS Name of the Student: Name of the University: Author Not ...

Course

ITECH1103

Subject

Database

University

Federation University

Season

Autumn

View Document

105 Pages

Structured Query Language

Running head: DATABASE FUNDAMENTALS DATABASE FUNDAMENTALS Name of the Student Name of the University Author Note 1 DATABASE FUNDAMENTALS Table o ...

Course

DBFN212

Subject

Database

University

Kent Institute Australia

Season

Spring

View Document

INFS2001 Database Design and Development

Question

Answered

Task:

Part 1 Database Design

1.An online advertising agency wants to create a simple database to manage their clients’ advertising campaigns. Clients’ details need to be recorded. Clients are grouped into regions where a region can have up to 20 clients. Clients request advertising campaigns, and a record is kept of every campaign.

Each campaign is based on a unique theme and has an associated cost as quoted to each client. Each campaign is managed by an account manager, an advertising manager and a graphic design manager, who may also manage other campaigns.

Your Task:

1. Write the business rules in this case study. (2 marks)

2. Draw the ER diagram corresponding to the above case: No attributes are needed for this answer - only the entities and relationships. (3 marks)

Part 2: Create tables - SQL (5 marks)

i. Write an SQL script (statements) that generates the tables in your GRD for your designed database with at least 3 appropriate attributes in each table – Screenshots are required for the records of all the created tables.

ii. Write an SQL script to insert records into your tables. Insert sufficient records into your table/s (at least 4 records in each table) so that your query returns at least 2 records – that is yours and your group member’s family name. (if you are working alone, then you need to have your name and the tutor’s name shown in the result of the query). Screenshots are required for the records of all the tables.

iii. Use an SQL SELECT query to display the records containing your own names (you and your partner’s) first and last name and a contact number.

iv. Write another SQL statement to list some records from any of your tables with a specific condition (ie; some date, price range, etc). Sort the results in some order - (screenshot required).

v. Use an Inner Join SQL statement to list information from two related tables.

INFS2001 Database Design and Development

Answer in Detail

i Solved by qualified expert

Get Access to This Answer

Get Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Page 1 of 9

8 More Pages to Come in This Document. Get access to the complete answer.

More INFS2001 INFS2001 Database Design and Development: Questions & Answers

Database

MIS201

Torrens University

MIS201 Database Programming Project

Task: Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Analysing specific organisational needs that can be addressed by collection, storage and management of organisational data.b) Applying different database techniques to co ...

View Answer

Database

HS2021

Holmes Institute

HS2021 Database Design and Use

Questions: Purpose: This assignment is designed to assess your level of knowledge of the key topics covered in this unit. Unit Learning Outcomes Assessed:1. Design and implement a relational database by considering business needs and context of the systems.2. Retrieve and present informa ...

View Answer

Database

ITECH1103

Federation University

The Implemented Database Payments

Running Head: ITECH 1103 BIG DATA AND ANALYTICS ITECH 1103 BIG DATA AND ANALYTICS Name of the Student: Name of the University: Author Note: 1 ITECH 1103 BIG DATA AND ANALYTICS Table of Contents Sce nario .................... ...

View Answer

Database

DBFN212

Kent Institute Australia

Structured Query Language

Running head: DATABASE FUNDAMENTALS DATABASE FUNDAMENTALS Name of the Student Name of the University Author Note 1 DATABASE FUNDAMENTALS Table of Contents Introduc tio n ................................ ................................ .... ...

View Answer

Choose Our Best Expert to Help You

Justin Meredith

Master of Healthcare Management

2327 - Completed Orders

Hire Me

Jeremiah Gregory

PhD in Nursing

235 - Completed Orders

Hire Me

Joel George

Master of Statistics

322 - Completed Orders

Hire Me

Jacob Galbraith

PhD in Management

1074 - Completed Orders

Hire Me

Securing Higher Grades Costing Your Pocket? FLAT 25% OFF on all orders

Phone no. Missing!

Files Missing!

Guaranteed Higher Grade!

INFS2001 Database Design and Development