MODERN DATABASE MGMT.(PEARSON CHANNEL)
13th Edition
ISBN: 9780136709299
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 solutionStudents have asked these similar questions
Virtual Campus (VC) is a social media firm that specializes in creating virtual meeting places for students,faculty, staff, and others associated with different college campuses. VC was started as a student project ina database class at Cyber University, an online polytechnic college, with headquarters in a research park inDayton, Ohio. The following parts of this exercise relate to different phases in the development of the database VC now provides to client institutions to supporta threaded discussion application. Your assignment isto draw an ERD to represent each phase of the development of the VC database and to answer questions thatclients raised about the capabilities (business rules) ofthe database in each phase. The description of each phasewill state specific requirements as seen by clients, butother requirements may be implied or possibly should beimplemented in the design slightly differently than theclients might see them, so be careful to not limit yourselfto only the…
Explain the role of Model-View-Controller in the larger context of web application architecture. Please describe some of the advantages your project will get from using an MVC design.
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…
Chapter 2 Solutions
MODERN DATABASE MGMT.(PEARSON CHANNEL)
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
- 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.arrow_forwardTo what end is the Model-View-Controller (MVC) pattern put to use when developing web apps? Is there any way to take use of the advantages that an MVC framework provides?arrow_forwardHow can Model-View-Controller (MVC) help in arranging web applications? Can you think of any user-related advantages that MVC design may provide?arrow_forward
- How does the Model-View-Controller (MVC) architectural pattern apply to web development, and what are its advantages?arrow_forwardHow does Model-View-Controller (MVC) contribute to the overall organisation of web applications? What are some of the ways that using an MVC design might benefit the end user?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_forward
- 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_forwardIn the broader context of web application development, the Model-View-Controller (MVC) architectural pattern serves a crucial role. What are the advantages of employing a Model-View-Controller (MVC) framework, and how can these advantages be effectively leveraged?arrow_forwardHow do web applications use Model-View-Controller? What are the advantages of adopting MVC in your project?arrow_forward
- How does Model-View-Controller fit into the bigger picture of how web applications are structured? What are some of the benefits that come along with using an MVC architecture in your project?arrow_forwardcreate an Entity Relationship Diagram using the following Entities and their respective attritubes for an online programming competition registration for both leaners and university students. 1. Host it's attributes (host Id, hostFirstName,hostLastName, hostTelNum,hostEmail,hostPassword) 2. Student(StudentId, StudentfirstName, Student Email, StudentPassword, InstitutionName) 3. Learners(leaner Id, leanerFirstName, leanerLastName, leanerPassword, SchoolName) 4. Competition(compId, comName, compDate,comTime, compRules, compRequirements) 5. Qualified Student/Leaner (id, firstName, compId,email)arrow_forwardWhere exactly does the Model-View-Controller pattern come into play when it comes to the overarching structure of web applications? What are some of the advantages that come along with using an MVC design in your project, and how can you take use of these advantages?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