Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 2.44PAE
Program Plan Intro
(a)
Draw an ERD for Virtual Campus (VC) social media firm based on provided information.
Program Plan Intro
(b)
Answer whether the above ERD enforce the rule following rule:
A person can have multiple accounts on the same site.
Program Plan Intro
(c)
Make changes in the ERD drawn above with respect to the given information.
Program Plan Intro
(d)
User above ERD to name entities, attributes and relationships which will be needed to provide answer following queries.
- Find number of posting each person created for each site.
- List of postings that appeared under multiple sites.
- Check if the person created his or her own posting and commented on his/her own posting, before any other will read the original posting.
- Find the sites that do not have any posting.
Program Plan Intro
(e)
Make changes in the ERD drawn above with respect to the given information.
Program Plan Intro
(f)
Make changes in the ERD drawn above with respect to the given information.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A company sells toys by mail order. The company already has a product database, with a simple web interface, so that customers can get information about toys and prices. Currently, customers place orders by mail or by telephone.
The company decides to create a system for selling toys online. The system will have three components: a product database, a customer database, and an ordering system.
The plan is to develop the system in two phases:
Phase 1
The product database will remain unchanged but the web interface will be replaced by the ordering system.
A fully featured version of the ordering system will be developed. Every effort will be made to create an ordering system that will need little or no modifications in Phase 2.
A simple version of the customer database will be developed.
Page 3 of 4
Phase 2
A new product database will be created.
Major enhancements will be made to the customer database.
Minor changes may be made to the ordering…
database and database application ??!
Lab HW2 is based on Oracle Application Builder (project implementation):
• Application design based on Repornt-Form interface.
• Application design based on Master-Details interface.
• Application design based on Query Builder SQL
Each student must submit screenshots for any 2 interfaces mentioned above (must use 2 different schema from your project). All these will be for your project as well.
Chapter 2 Solutions
Modern Database Management
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Give an example, Other than those described in...Ch. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - Prob. 2.24PAECh. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - Prob. 2.29PAECh. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Figure 2-27 represents a situation of students who...Ch. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.46PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Airline Reservation System In this project, you will design and implement a simple interactive airline reservation system similar to orbitz (www.orbitz.com). The system is a typical client-server application with a web-based front-end for the user and a database backend. This project will focus only on the backend and NOT on the front end. This document provides a high-level description of the project and outlines the deliverables expected of your team. It is crucial that you have a good solid design before you start coding. The purpose of the online system is to create convenient and easy-to-use online system for passengers, trying to buy airline tickets. The system is based on a relational database with its flight management and reservation functions. We will have a database supporting dozens of major cities around the world as well as hundreds of flights by various airline companies. Above all, we hope to provide a comfortable user experience along with the best pricing available.…arrow_forwardCode for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…arrow_forwardImagine you are part of a research team tasked with creating a new educational mobile application aimed at enhancing online learning experiences. In this context, answer the following four questions. First, for understanding how users interact with a newly developed mobile application, your goal is to gather data to evaluate the usability and user satisfaction of the application. Using the concepts and methodologies discussed in Module 8 of the Human Computer Interaction: Design a Data Gathering plan for data gathering, specifying the methods you would use (e.g., interviews, questionnaires, observations) and justify your choices based on the nature of the study. Discuss how the data gathered from each method can be analyzed to provide insights into the usability and user satisfaction of the mobile application. Note: Your answer should demonstrate a clear understanding of the different data gathering techniques, their appropriate application, and the importance of ethical…arrow_forward
- Attracted by the success of Spotify, a group of students want to build their own music-streaming website called Musicmatic. Being economists, they are unaware of the specificities of databases and have therefore asked you to create an EER model. A large number of songs will be made available through their website, and the following information on each song needs to be stored: title, year, length, and genre. Also, artist information will be added, including date of birth, name, and a URL to a website (e.g., Wikipedia page) with additional information on the artist. You can assume an artist is uniquely identified by her name, and that a song always belongs to exactly one artist. The Musicmatic students also point out that songs having the same title are possible, and only the combination of song and artist can be assumed to be unique. The database will also have to store information on the people using Musicmatic. It was decided to only discriminate between two types of users: regular…arrow_forwardHow does Model-View-Controller (MVC) integrate into the framework of contemporary web applications? Why do you believe an MVC framework is advantageous?arrow_forwardQ3arrow_forward
- Create a domain model for the conference review system described below: For an international conference of interdisciplinary sciences, the board of the society that organizes this conference wants to establish an academic paper review system. The editor-in-chief will be the head of the system. There will be several tracks (areas of interest) in which accepted papers will be presented. Each track will have its own editor and several reviewers that will be performing the peer reviews of the sent through the conference website. Editor-in-chief selects the editor for each track and each editor assigns the papers to selected reviewers. Each paper will have to include an abstract, the authors' information, and the content. Communication between the editors, reviewers, and authors are handled through the conference registration system. Draw the domain model based on the description given above, not based on other conference registration systems.arrow_forwardA wide range of contexts call for the deployment of an Azure Domain.arrow_forwardHow does Model View Controller (MVC) facilitate the organization of web applications? Why might the end-user appreciate MVC design, and what are some of its benefits?arrow_forward
- Give me two examples of problems with database architecture that crop up while developing Web-based apps.arrow_forwardCakePhP is a high-level PhP-based framework for developing Web applications. 1)List two of the features that CakePhP provides that make it easier to write web applications than using lower level modules such as cgi and Cookie. (2) CakePhP includes an Object Relational Mapper (ORM) module. Describe what an ORM is and the advantages of using one. Show with simple code examples how models are defined with the ORM and how data can be retrieved from the database. (Syntax details are not important, just the main features of how this works.)(3)How does CakePhP manage users and user authorization? For example, how would you ensure that only a logged in user could access a given page? Does CakePhp use cookies to manage user sessions or does it have some other mechanism?arrow_forwardSuppose you are working in a software house as a software engineer on an ecommerce website and you are given a requirement by your project manager that when user login as admin, he must know the history of products added in product table as shown below.Write down your implementation detail as database schema in MySQL database and Server-side code in PHP.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage