Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 1.32PAE
Program Plan Intro
A
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A driver’s license bureau maintains a database of licensed drivers. State whether each of the following represents data or metadata. If it represents data, state whether it is structured or unstructured data. If it represents metadata, state whether it is a fact describing a property of data or a fact describing the context of data.
An image of the driver’s fingerprint
The make and serial number of the scanning device that was used to scan the fingerprint
The resolution (in megapixels) of the camera that was used to photograph the driver
The fact that the driver’s birth date must precede today’s date by at least 16 years
State whether it is structured or unstructured data). If it represents metadata, state whether it is a fact describing a property of data or a fact describing the context of data. Remember that metadata is data about data, like the length of a field, or if the field is optional or mandatory. i.The resolution of a student’s ID photo in pixels. Metadata describing the context of data ii.Length of the course number field. Metadata- a fact describing the properties of the data. iii.The fact that the student ID field is the primary key for students. Metadata- a fact describing the property of the data.
Open and examine the following ERR design that is provided in the image attached to the question.
Each person is described by their name and email.
Each person can be registered in multiple countries.
Ensure it is in 3rd normal form.
Ensure the relationships and primary and foreign keys are correct.
Create a database from the design.
Import the following data into the database : Email,Full Name,Country,Date Registered Carley_Bahringer@destiny.com,Carley Bahringer,Brazil,1987-10-03 22:09:54 Patricia_Fadel@avis.com,Patricia Fadel,Chile,2012-05-10 11:07:49 Sedrick@godfrey.ca,Sedrick Kuphal,Chile,2007-11-12 00:09:53 Briana_Berge@axel.ca,Briana Berge,Iceland,2006-03-26 15:32:08 Lucy_Lockman@abby.org,Lucy Lockman,Iceland,2014-02-13 10:26:57 Lucy_Lockman@abby.org,Lucy Lockman,France,1999-02-12 00:14:54 Ayden_Flatley@colin.biz,Ayden Flatley,France,1987-01-23 21:43:22…
Chapter 1 Solutions
Modern Database Management
Ch. 1 - Prob. 1.1RQCh. 1 - Prob. 1.2RQCh. 1 - Prob. 1.3RQCh. 1 - Prob. 1.4RQCh. 1 - Prob. 1.5RQCh. 1 - Prob. 1.6RQCh. 1 - Prob. 1.7RQCh. 1 - How are relationships between tables expressed in...Ch. 1 - What does the term data independence mean, and why...Ch. 1 - Prob. 1.10RQ
Ch. 1 - Prob. 1.11RQCh. 1 - Prob. 1.12RQCh. 1 - Prob. 1.13RQCh. 1 - Prob. 1.14RQCh. 1 - Prob. 1.15RQCh. 1 - Prob. 1.16RQCh. 1 - Prob. 1.17RQCh. 1 - Prob. 1.18RQCh. 1 - Prob. 1.19RQCh. 1 - Prob. 1.20RQCh. 1 - Prob. 1.21RQCh. 1 - Prob. 1.22RQCh. 1 - Prob. 1.23RQCh. 1 - Prob. 1.24RQCh. 1 - Prob. 1.25RQCh. 1 - Prob. 1.26RQCh. 1 - Prob. 1.27PAECh. 1 - Prob. 1.28PAECh. 1 - Prob. 1.29PAECh. 1 - Prob. 1.30PAECh. 1 - Prob. 1.31PAECh. 1 - Prob. 1.32PAECh. 1 - Great Lakes Insurance would like to implement a...Ch. 1 - Figure 1-22 shows an enterprise data model for a...Ch. 1 - Prob. 1.35PAECh. 1 - Prob. 1.36PAECh. 1 - Prob. 1.37PAECh. 1 - Prob. 1.38PAECh. 1 - Prob. 1.39PAECh. 1 - Prob. 1.40PAECh. 1 - Prob. 1.41PAECh. 1 - Prob. 1.42PAECh. 1 - Prob. 1.43PAECh. 1 - Prob. 1.44PAECh. 1 - Consider the project data model shown in Figure...Ch. 1 - Answer the following questions concerning Figures...Ch. 1 - Prob. 1.47PAECh. 1 - Helen Jarvis wants to determine the most important...Ch. 1 - In this chapter, we described four important data...
Knowledge Booster
Similar questions
- In the hierarchy of data, what is the difference between a data attribute and a data item? What is the domain of an attribute?arrow_forwardPart A: Write 100-200 words per item below, explaining how each of the following approaches for updating the data in your database works, and its corresponding pros and cons. Upsert Append Drop and Replace Part B: Select one of the answers to the multiple-choice question below, and write 100-200 words explaining why you believe this is the correct answer: You are running a database for a University and need to perform regular updates on the database from an athletic association roster of students who are on sports teams. The roster can change week to week, and as such you need to have the data update once per week. Which method is best for bringing this new roster data into the tables within your database: Upsert Append Drop & Replacearrow_forwardQuestion 1) We plan to construct a database for the FAU parking service shstem. The FAU has many parking-lots which can accommodate many vehicles. Each parking-lot has id, name, and location. A parking-lot consists of many parking spaces (or spots) and each parking space (or spots) has a unique number. Every student has School_ID and name. A student can purchase more than one parking-permit. A vehicle has id, brand, and color. A student can own multiple vehicle. Each parking permit has no. and price. A parking-permit allows a vehicle to park in dedicated parking spaces (or spots). The FAU maintains a time table and uses it to record when a student parks a vehicle at a dedicated parking space (or spot) at a specific time-slot in the time- table. A time-table has id, date, and hour. Draw an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type. Note any unspecified requirements, and make appropriate…arrow_forward
- Subject:database administration and management question: select a database like customer tb,employee tb and customer tb make a set of predicate generate minterm predicate and fragments and make a correctness rule of fragmentationarrow_forward1.. Design a database to keep track of information for an art museum. Assume that the following requirements were collected: The museum has a collection of art objects. Each art object has a unique identification, an artist (if known), a year (when it was created, if known), a title, an epoch (Renaissance, Modern, Ancient, etc.), and a description. The arts objects are classified in the museum in several ways as discussed below: Arts objects are categorized based on their type. The main types are: painting and sculpture, plus another type they called “other” to accommodate objects that do not fall into one of the two main types. A painting has a paint type (oil, watercolor, etc.), material on which it is draw on (paper, canvas, wood, etc.), and style (modern, abstract, impressionism, etc.). A sculpture has a material from which it was created (wood, stone, iron, etc.), height, weight, and style. An art object in the other category has a type (print, photo, etc.) and a style.…arrow_forward1. Describe what a database is? 2. Discuss the main characteristics of the database approach and how it differs from traditional file systems. Discuss the differences between database systems and information retrieval. A minimum of 1 outside reference is required, along with APA formatting.arrow_forward
- Answer the questions considering the following case - Best-East University is at present in need of a database for their student course advising. Courses areoffered to the students and students choose the course and section. After the approval of course registration,a faculty and classroom are assigned to the course. In addition to the faculty, a Teacher Assistant (TA) isassigned for a section also. For a lab course, a Lab Instructor (LI) is also assigned. A faculty, TA, or LI maytake many courses. A student may take up to five courses. (a) Find appropriate database relation schemas with appropriate attributes. (b) Find Primary and Foreign Keys for all relations (tables). (c) Draw an Entity-Relationship (ER) diagram showing relation relationships.arrow_forwardDraw ERD for the following situation: Kopolo Airline wants a database to keep track with its flight ticket payment. Multiple passengers (identified by first name, last name, and address) can reserve multiple flights with Kopolo Airline. Each flight is identified by its flight number, departure city, departure time, arrival city, and arrival time. When a passenger book for a flight, the database records the amount due, booking date, seat info and ticket type. When a passenger pays for his/her booking, the database records the payment amount, payment date, and info of passenger who pay for the ticket. Database Management Course Subject: MySQLarrow_forwardAssignment One (1) With the aid of the figure below, answer the questions that follows The figure above is a database that stores student and course information. Specify all the relationships among the records of the database Give some additional views that may be needed by other user groups for the database. Cite some examples of integrity constraints that you think can apply to the database. Think of different users for the database. What types of applications would each user need? To which user category would each belong, and what type of interface would each need? Give examples of systems in which it may make sense to use traditional file processing instead of a database approach.arrow_forward
- Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: Movies are identified by their title and year of release. They have a length in minutes. They also have a studio that produces the movie and are classified under one type (such as horror, action, drama, etc). Movies are directed by one or more directors and have one or more actors. Actors are identified by their names and date of birth and act in one or more movies. Each actor has a role in the movie. Directors are also identified by their names and date of birth. Each director has a rank value and direct one or more movies. Studios are identified by their names and have an address. The address contains building number, street name, and city name. They produce one or more movies. Design an Entity-Relationship diagram for the movie database.arrow_forwardComputer Science Design a database for a world-wide package delivery company (e.g., DH, FedEX, UPS), with the following requirements.[1] The database must be able to keep track of customers who ship items The database must be able to keep track of customers who receive items Some customers may ship and receive items Each package must be identifiable and trackable. Thus the database must be able to store the location of a package, and its history of locations Locations include trucks, planes, airports, and warehousesarrow_forward1. A software system that allows users to define, create, maintain and control access to the database. 2. A collection of application programs that performs various services for end users, for example the production of reports. Each program defines and manages its own data. 3. A computerized system whose general purpose is to store information and enable users to retrieve and update it. 4. A shared collection of logically related data, together with a description of these data, which are designed to satisfy the needs of the user.A shared collection of logically related data, together with a description of this data, that is designed to meet the information needs of an organization. Which answer goes with which number a) Database Management System b) File-Based System c) Database System d) Databasearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning