Question 1:(DATABASE APPLICATION DEVELOPMENT)Maya Media publishes a daily newspaper and would like an application to bedeveloped to maintain information about subscribers and subscriptions. Maya Mediahas 3 different branches that have to access the information. Each subscriber isuniquely identified by a subscriber number and is also characterized by name, postaladdress, email and phone number. Each subscription is uniquely identified by asubscription number and is also characterized by subscription type (Daily or Sundayonly), price, start date, and expiration date. The price paid for a subscription is inputwhen the subscription is sold, since it may vary due to special offers or situations.Expired subscriptions and former subscribers that no longer have a currentsubscription shall be deleted from the database. The example report below shows thesubscriptions belonging to subscriber number 21567. Date printed is not stored in thedatabase.Name: Anita HashimDate Printed: 06/08/2007Address:Email:Telephone:15 Jalan Darat, Kajang, 43640 anita1234@gmail.comSelangor03-85432163Subscriber#: 21567Subscription#ТуреPriceStartEnd144134RM52.0001/01/200631/12/2006145234DRM95.0001/01/200730/06/2007145876DRM80.0001/07/200731/12/2007Figure 1: Subscription reporta) Maya Media owner plans to build a Java program which uses an input file for storingthe subscription records. Explain to Maya Media about the disadvantages of thetraditional file system approach if the three branches need to share information.Clarify the advantages of a database approach with regards to the matter.b) Represent the requirements as displayed in Figure 1 using an Entity-Relationshipdiagram (ERD). Add any two new attributes suitable to enhance the subscriptioninformation.c) Transform the ERD produced from question b into relational model form.d) Explain the impact of the following statement to your database design. "Expiredsubscriptions and former subscribers that no longer have a current subscriptionremain in the database." Draw the new ERD which represent this statement anddetermine the mapping into relational model.e) Does normalization need to be performed on your database design? Explain youranswer.

Advantages of Traditional File System : File processing cost less and can be more speed than a…

Question 1: ( DATABASE APPLICATION DEVELOPMENT) Maya Media publishes a daily newspaper and would like an application to be developed to maintain information about subscribers and subscriptions. Maya Media has 3 different branches that have to access the information. Each subscriber is uniquely identified by a subscriber number and is also characterized by name, postal address, email and phone number. Each subscription is uniquely identified by a subscription number and is also characterized by subscription type (Daily or Sunday only), price, start date, and expiration date. The price paid for a subscription is input when the subscription is sold, since it may vary due to special offers or situations. Expired subscriptions and former subscribers that no longer have a current

Question 1: ( DATABASE APPLICATION DEVELOPMENT) Maya Media publishes a daily newspaper and would like an application to be developed to maintain information about subscribers and subscriptions. Maya Media has 3 different branches that have to access the information. Each subscriber is uniquely identified by a subscriber number and is also characterized by name, postal address, email and phone number. Each subscription is uniquely identified by a subscription number and is also characterized by subscription type (Daily or Sunday only), price, start date, and expiration date. The price paid for a subscription is input when the subscription is sold, since it may vary due to special offers or situations. Expired subscriptions and former subscribers that no longer have a current

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD.
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.…
Database Foundations: Design a database to produce the following reports. Do not use any surrogate keys in your design. For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired. For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many different guides. For each client, list the client number, client last name, client first name, address, city, state, postal code, and telephone number
Part A - Database design case study In this part, you need to provide a short description of the application/website for which you will be designing the database (The overview of your own/chosen case study that is related to the assignment topic), outline the basic functions that your database needs to support, identify the data requirements, and business rules.
The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) for CONTAINS nad PRESCRIBED table , which one is primary key and how to create table ?
The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) Formulate the following SQL statements: a) Find the names of all the patients being prescribed ‘Morphine’.b) What is the total cost of Morphine supplied to a patient called ‘John Smith’?c) For each ward that admitted more than 10 patients today, list the ward number, ward type and number of beds in each ward.
Student question your friend Tamara designed a phone book database, she initially designed the database as one table keeping track of the following: Contact name (first and last), address (street, city, state, zip), phone type (home, cell, work), hoppy Tamara showed you her database design, and your initial thoughts, there are lots of redundancy here. Suggest to Tamara a better database design. Hint: normalize up to the 3rd normal form.
Requirement analysis: Course evaluation must have a student, the students relation contains a unique student id, full name for each student, email address, phone number, address and date of birth. For each course, the courses contain course id, course name and credit. Each student can take many courses. For each Instructor, the instructors contain id, name and email. Each instructor can instruct many courses. For each section, the sections contain section id, year and semester. Students are able to evaluate the current courses. ER-diagram: Please complete the ER diagram using Microsoft word. Instructor ID Full name Email Student ID Full name Email Phone number Address Date of birth Course ID Course title Description Credit Section ID Year Semester Please Complete the diagram on MS word.
Joan Yancey has been asked to create a database for her company, Yancey Shipping. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. She has determined that she needs the following tables and fields in her database:(Table 1) Employee Information:Fields - Last Name, First Name, Street Address, City, State, Zip Code, Social Security Number, Phone Number, Hourly Pay Rate, and Project Number (Table 2) Project Information:Fields - Project Number, Project Name, Project Leader, Project Location, Total Hours, and Actual Completion Date What data type should Joan Yancey use for the Actual Completion Date field and why?
Create Database according to the Data given: About the Company - Office Machines Inc. Office Machine Inc. makes office furniture and school materials. The company employs about fifteen full- and part-time workers in the Green building in the town of Niceville. The company’s director John Brush wants to manage the absences and overtime of his employees. He asks you to create a database management system. Of course, you accept with joy! Here are the pertinent elements to create the database. The company has four departments identified by numbers. An Employee works for only one department. On their hired date, employees are assigned unique employee numbers that they must memorize. Everything is based on that number. Mr. Brush negotiates each salary individually. In the database management system, he wants to save all the relevant information pertaining to employees such as employee full name, gender, address, social insurance number, job description and category, hourly wage, seniority,…
Create Database according to the Data given: About the Company - Office Machines Inc. Office Machine Inc. makes office furniture and school materials. The company employs about fifteen full- and part-time workers in the Green building in the town of Niceville. The company’s director John Brush wants to manage the absences and overtime of his employees. He asks you to create a database management system. Of course, you accept with joy! Here are the pertinent elements to create the database. The company has four departments identified by numbers. An Employee works for only one department. On their hired date, employees are assigned unique employee numbers that they must memorize. Everything is based on that number. Mr. Brush negotiates each salary individually. In the database management system, he wants to save all the relevant information pertaining to employees such as employee full name, gender, address, social insurance number, job description and category, hourly wage, seniority,…
True and falseLogical level is the physical level representation of database true and false mein bataiye

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS