Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

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

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

49 Pages
KC7013 Database Modelling

Question: ¨You are required to use the Harvard Style of referencing and citation. The “Cite them right” guide is recommended for referencing and citation (Pears and Shields, 20 ...

Course

KC7013

Type

Programming

Subject

Database

University

Northumbria University

75 Pages
Computerised Booking System

1 Faculty of Computing, Engineering & Media (CEM) Course work Brief 202 2/2 3 Module name: Data Warehouse Design and OLAP Module code: IMAT 5167 Title of the Assessment : D ...

Course

ISYS90086

Subject

Database

University

The University of Melbourne

Season

FAll

18 Pages
The Average Cost of Payments

create schema ass2; use ass2; -- Create TruckMake table create table TruckMake( TruckMakeID char(3), TruckMakeName varchar(8), primary key(TruckMakeID) ); -- Insert values ...

Course

COMP1350

Subject

Database

University

Macquarie University

Season

Spring

22 Pages
CSE1ISX Information Systems

Questions: Objectives: 1. Critique the design of the user interface of a simple IS. 2. Justify the choice of an implementation approach and security requirements for a new IS. 3. Design and constr ...

Course

CSE1ISX

Type

Programming

Subject

Database

University

La Trobe University

ACS-2814 application of database systems

Question

Answered

Questions 1. Create a database to keep track of books, authors, publishers, and the employees that work with each publisher. The database also keeps information about the jobs that employees can do at a publishing company. An Excel spreadsheet Assignment1Data.xlsx containing the data to be stored at creation (initial load) is provided. There are six tables: Authors, BookAuthor, Books, Employees, Publishers, and Jobs. Each table must have a primary key, relationships between tables must be defined, and relationships must enforce referential integrity. The following guidelines are given about the tables. a. Authors are in Canada and each one has an Id, first name, last name, phone, postal code, province, sex, salary, birth date and a book subject. The Id is the primary key. b. For each book, we keep track of the title Id, the title of the book, publisher, price, advance for the author, year-to-date sales (quantity sold to date), and the publication date. The primary key is the titleId. c. Several authors can publish a book. Information about authors and the book in which they were an author stored in the BookAuthors table. The database also keepstrack of the ordering of author names and how often each author is paid a royalty. The primary key for this table is composite, comprising of the author Id and the title Id of the book authored. d. For each publisher, we keep track of the publisher Id (which consists of 4 digits), name, city, state, and country. The publisher Id is the primary key. e. Employees work with specific publishers. The database keeps track of employee first name, middle initial, last name, job Id, job level, publisher with which they work and their hire date. Several employees can work for the same publisher and may have the same job id. Employees are identified by their employee Id (empId). f. The jobs that employees do are stored in the Jobs table. The database keeps track of the job Id, description, min job level required for this position. A job is identified by the Job Id. 2. Choose datatypes and properties that are most appropriate for each field. For instance, names must be text, dates must be date/time and so on. Also note the following: a. Make all fields required, except for employee middle initial and publisher state (since some countries do not have states). b. Include a validation rule and text for book prices: Price must be greater than $0. c. Assume that the following fields only allow data having the same structure/format as the given initial data. Add an appropriate Format and/or Input mask for the following fields. Also set any other applicable property for the fields and any other field based on the given data. i. titleId of books ii. publisherId iii. Author phone iv. Author postal code v. Books publication date d. Include a lookup for sex field, so that the domain is limited to F, M, or U. 3. Create the following relationships. A lookup must be included for each foreign key. a. A book may have many authors / books have an author b. An author may have several books / books may have several authors c. A book has a publisher / a publisher may be the publisher for many books d. An employee works with a publisher / a publisher may have many employees e. An employee has a job / a job may be done by many employees 4. Add some data manually as follows: a. Make yourself the Chief Executive Officer of a new publishing firm that is based in Winnipeg, Canada. You may make up any required data not specified, as necessary. b. Add a new book with two authors. Make yourself the first author. The book is published by the publishing firm at which you are the CEO. You may make up a name for the second author and other necessary data that is not provided. 5. Design the queries to do the following: a. List all the employees (first name, last name, job level and hire date) working with the publisher called Algodata InfoSystems. The list must be in order ascending order of job level. If two employees have the same job level, they must be listed in ascending order by their last name. The order of the columns must be as specified above. b. List all books (title, publisher, publication date, number of authors) with 2 or more authors. c. List all books (title, publisher, publication date) published in 2013 where the total year to date sales from the book has exceeded $5000. d. List the authors (Id, first name, last name) that published a book before their 21 st birthday. e. List the id, first name and title of books by all authors whose subject is ‘Action’. List must be in ascending order by id and then by book title if an author has more than 1 book. The columns must be in the order specified above. f. Accept a job level and display a list of jobs (with all details) that the job level can qualify for given the minimum level required for each job. Columns of your query result must be shown in the display order specified and must also satisfy any sort order specified.

ACS-2814 application of database systems

Answer in Detail

Solved by qualified expert

Get Access to This 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.

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.

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.

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

MyAssignmenthelp.com boasts highly qualified and experienced coursework experts who know the art of writing best quality coursework assignments on any given topic. With a decade experience in this industry, we have become one of the most recognized coursework help services providers in USA. Our coursework writing services include essay writing help, dissertation writing services, term paper writing help, case study help, etc. Our experts are well acquainted with all types of coursework assignments and help students with writing any type of coursework assignment effortless. This is why numerous students prefer to buy coursework online from us.

More ACS-2814 application of database systems: Questions & Answers

Q
icon

We aren't endorsed by this University

KC7013 Database Modelling

Question: ¨You are required to use the Harvard Style of referencing and citation. The “Cite them right” guide is recommended for referencing and citation (Pears and Shields, 2008) which should be followed throughout your answer especially Part 3. A good alternative is Northum ...

View Answer
Q
icon

We aren't endorsed by this University

Computerised Booking System

1 Faculty of Computing, Engineering & Media (CEM) Course work Brief 202 2/2 3 Module name: Data Warehouse Design and OLAP Module code: IMAT 5167 Title of the Assessment : Data Mart Design This coursework item is: (delete as appropriate) Summative This summativ ...

View Answer
Q
icon

We aren't endorsed by this University

The Average Cost of Payments

create schema ass2; use ass2; -- Create TruckMake table create table TruckMake( TruckMakeID char(3), TruckMakeName varchar(8), primary key(TruckMakeID) ); -- Insert values into TruckMake insert into TruckMake values('TM1', 'Volvo'); insert into TruckMake values('TM ...

View Answer
Q
icon

We aren't endorsed by this University

CSE1ISX Information Systems

Questions: Objectives: 1. Critique the design of the user interface of a simple IS. 2. Justify the choice of an implementation approach and security requirements for a new IS. 3. Design and construct a simple IS using a prototyping tool. Part A – System Prototype Samuel wants to have a s ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?