HW_Textbook_Questions

Subject: DatabaseQuestion: Draw an ERD based on the given info

ER Design Exercise

SQL:

Give Authentic and Relevent Answer: database systems: Do as directed  This describes the business process to publish an academic paper. The author submits a paper to an editor in chief of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor in chief assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor in chief. The editor in chief then assesses the quality of the paper with the help of reviewers’ comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper. Apply join between editor in chief and reviewers. Apply join between editor in chief and author. Apply index on paper that published in IEEE journal Apply query to only access to compile the final decision to editor in…

Airline Management There is a report on poor management of an airline company in South Africa. As a results, the stakeholders decided that all information concerning the assets, operations, and the employees of the company should be organised with the use of a database management system. The database needs to store information about the Airplane (identified by planeid, name as planename, and cruise_range), Flights (identified by ftnum, place of departure as departfrom, destination as arriveto, total milage as tmilage, departure time as departtime, arrival time as arrivetime, and price). Pilots (identified by empid and planeid), and Staff (identified by empid, name as empname, and salary). The Staff relation consist of all the employees of the company including the pilots, and you have been hired to design and manage the database. Source: Okonkwo, C. (2021) Write an SQL query on the following: Determine the identity (planeids) of all airplanes that can fly from Johannesburg to Cape…

4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows:                                                                           PATRON table records a patron’s ID, name, address, phone number, and email address. BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book. BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table. CHECKOUT table records the date of check-out, patron’s ID, the identifier of the book copy from the BOOK_COPY table, and the due date.

Chevening Scholarship Database's stores data about each application received by the Chevening Foundation. As a database designer, you're assigned to design the new database system according to the following requirements: Each applicant can submit one or more applications (one application per year). Each application form is submitted by only one applicant. Each application has a unique application ID number, application date, class level, GPA, GPA scale, academic honours, extracurricular activities, community activities, other scholarship awarded and financial need. The applicant's record contains student ID, student's last name, first name, date of birth, address, city, state, zip code, phone number and email address. Each school can be associated with one or more applications. Each application is associated with only one school. Each school has a unique school ID, school name, type, address, city, zip code and phone number. Each application must include two or more recommendations.…

Data Normalisation Normalisation is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency. Source: [Online] https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description [Accessed on: 8 March 2020] For an industry of your choice, obtain a business document (preferably a form). Using the form obtained: 1.1 Upload the form obtained and give a brief background explanation of the business logic for which the form was designed. 1.2 Normalise the data contained within the form to the 3rd Normal Form.

Database management system: Q.No.4   Do as directed    This describes the business process to publish an academic paper. The author submits a paper to an editor in chief of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor in chief assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor in chief. The editor in chief then assesses the quality of the paper with the help of reviewers’ comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper. a. Apply query to only access to compile the final decision to editor in chief and only visualized by author not reviewers Professor don't reject answer the question.

Database management system: Q.No.4   Do as directed    This describes the business process to publish an academic paper. The author submits a paper to an editor in chief of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor in chief assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor in chief. The editor in chief then assesses the quality of the paper with the help of reviewers’ comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper.   Apply index on paper that published in IEEE journal Apply query to only access to compile the final decision to editor in chief and only visualized by author not reviewers.  Answer all and according to the Question. Professor Don't…

Database management system: Q.No.4   Do as directed    This describes the business process to publish an academic paper. The author submits a paper to an editor in chief of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor in chief assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor in chief. The editor in chief then assesses the quality of the paper with the help of reviewers’ comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper. Apply join between editor in chief and reviewers. Apply join between editor in chief and author. Apply index on paper that published in IEEE journal Apply query to only access to compile the final decision to editor in chief and only…

Exercise 1 Medical Clinic System A local medical practice have asked you to help design a simple database to track the costs of treating patients. Their manual system takes a long time to work out how much they are spending. What do we need to be able to do? Record exact costs of treatments against each person Record name, description, and cost of a range of treatment types Track costs by treatment type Track costs by age Track costs by sex (A) Identify appropriate entities from the given exercise. (B) Draw the Entity Relation Diagram. (C) using Microsoft Access, produce the Tables, Report and Queries for tracking the treatment type, age and sex

Q1: What is wrong with the following designs from the perspective of cohesion, and what could be done to improve them? (a) There are two subsystems in a university registration system that do the following. Subsystem A displays lists of courses to a student, accepts requests from the student to register in courses, ensures that the student has no schedule conflicts and is eligible to register in the courses, stores the data in the database and periodically backs up the database. Subsystem B allows faculty members to input student grades, and allows administrators to assign courses to faculty members, add new courses, and change a student registration. It also prints the bills that are sent to students. ¬ (b) In an electronic commerce application, a module is created to add books to the ‘shopping basket’ and perform such operations as computing the total amount the customer owes. A second module adds ‘special reward’ merchandise to the shopping basket; this module also displays the…