Campus Housing Example Identify the actors and major use cases for the following high- level business processes in a housing system run by the campus housing service. The campus housing service helps students find apartments. Apartment owners complete information forms about the available rental units (e.g., location, number of bedrooms, monthly rent), which are then entered into a database. Students can search this database via the Web to find apartments that meet their needs (e.g., a two-bedroom apartment for $400 or less per month within a half mile of campus) and contact the apartment owners directly to see the apartment and possibly rent it. Apartment owners call the service to delete their listing when they have rented their apartment(s).

Campus Housing Example Identify the actors and major use cases for the following high- level business processes in a housing system run by the campus housing service. The campus housing service helps students find apartments. Apartment owners complete information forms about the available rental units (e.g., location, number of bedrooms, monthly rent), which are then entered into a database. Students can search this database via the Web to find apartments that meet their needs (e.g., a two-bedroom apartment for $400 or less per month within a half mile of campus) and contact the apartment owners directly to see the apartment and possibly rent it. Apartment owners call the service to delete their listing when they have rented their apartment(s).

Database Systems: Design, Implementation, & Management

11th Edition

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:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter4: Entity Relationship (er) Modeling

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

1.. 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.…
Database Design Before an Essential Oil product is marketed, testing is carried out based on the production batch from any essential oil. This is done to maintain the quality and content of the existing constituents in essential oils. Where the Test Percentage Content must reach the Minimum standard Percentage Content for each constituent. If there is one type of constituent that does not fulfill minimum standard, the batch will not be marketed because it does not meet the standard quality. Question 1. Create 1-NF, 2-NF, 3-NF Normalization for the available forms. 2. Make an ERD (Entitiy Relationship Diagram) based on the results of Normalization 3-NF. 3. Develop the ERD that you create to implement Generalization / Specialization.
Draw an ERD for the following problem. Help design the backend database for a startup company (imagine Facebook back in the “old” times), which plans to launch a social media platform that allows USERS to share their “MOMENTS” (like a posting) with their FRIENDS. A user may have some FRIENDS who are users of the system as well. A User can send a request to another user to become a friend. A user and his/her friend can post COMMENTS and LIKES to a MOMENT. Draw an ERD and show some important attributes (e.g., key, username, password, moment posting time, etc.). Clearly state any assumptions. When possible, convert to associate entities.
Subject: Database Topic: EERD -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. [Using UML Design] A car dealership wishes to maintain data about the customers who purchase acar. Each customer may purchase one or more vehicles and each vehicle can bepurchased by many different customers over time (for example, a customer maypurchase a new vehicle, trade that vehicle in and someone else can purchasethe vehicle traded in.) Data that the dealership wishes to keep regardingcustomers includes customer identification number, name, address, homephone, work phone, cell phone and e-mail address. Information about vehicle includes vehicle identification number, make, model,year, transmission type, engine size and color. Vehicles can be a member of oneof the following categories: cars, trucks, minivans or SUVS. A vehicle can be amember of only one category at a given time. Trucks, minivans and SUVS haveunique attributes — cars does…
Draw an ER diagram of the following: You are going to set up a database company that builds a product for art galleries. The core of this product is a database that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, we need to record its unique title, the year it was made, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price. An artist may paint many pieces of artwork and a piece of artwork is done by one artist. Pieces of artwork are also classified into groups of various kinds (for example, portraits, works by Picasso, or works of the 19th century). A given piece may belong to more than one group. Each group is identified by a name that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent…
Subject: Database Topic: EERD -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. [Using UML Design] You are required to design a database for a car championship. The requirements are as follows: In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race. Every race would have a specific race ID and a race name. In a race would consists of…
Analyze the database need for a furniture store which produces and sell different types of furniture; for example different types of Tables, different types of sofa sets, Wall units etc. There are several employees with different tasks: Carpenters, painters, salesmen and manager. Identify the different tables required and their respective columns for this case.
FUNDAMENTAL DATABASE SUBJECT: Case: A car wash owner wants to monitor the inventory of products and sales of the business. Create a database design in preparation for a system development that would: Store and monitor the supply of products; The number of vehicle washed by a car wash boy. Vehicles can be classified according to its type (motorcycle, van, bus, etc.). The list of vehicles washed by a car wash boy can be monitored. Salary per employee and the vehicles washed can be retrieved. Car wash history per vehicle can be check also. We already Identified the possible tables, so your task will be: 1. Add data on the tables (assume that this is not normalized yet) 2. reflect on the table and follow the normalization steps base on the rules. 3. normalize its table 4. add all table in one document (lucidchart/google docs), should have relationships and cardinality. 5. make sure that it is in highest normal form, highest will be BCNF (if needed).
Computer 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 warehouses
Wally Los Gatos decides to pursue a law degree. After graduating, he has teamed up with Lyla El Pajaroto form Peck and Paw, Attorneys at Law. Wally and Lyla have hired you to design a database systembased upon the following set of business rules. It is in your best interest to perform a thorough analysis, toavoid needless litigation. Please create an ER model based up on the following set of rules:• an attorney is retained by one or more clients, for each case• attributes of attorney are: attorneyID, name (firstName, lastName), address (street, city, state,zipcode), specialty (may be more than one), bar (may be more than one)• a client may have only one attorney for each case• attributes of client are name (firstName, lastName), address, city, state, zipcode, telephone,dateOfBirth• a client may have more than one case• attributes of case are caseID, case_description, caseType• an attorney may have more than one case• each case is assigned to one and only one court• attributes of court…
Twitter Scrapping Bot to gather information for learning/research. Twitter scrape bot(s) which gather information on a range of topics which can be sorted into a database based off a set of requirements. The bot(s) will be able to operate 24/7, will be able to gather information based on a rule set and give each tweet a ranking on how appropriate the information is.
Objectives: 4.REST service on ASP.NET Core , the basics of webAPI development using ASP.NET Core. We will learn the principles of creating a webAPI project, methods of adding model classes and database context, creating controller templates using CRUD methods, configuring routing, URL paths and return values, calling webAPI using Postman. The end result is a webAPI that allows you to work with to-do list items stored in a database. *The source of step by step:.NET 7.0 (or later):: https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-7.0&preserve-view=true&tabs=visual-studio .NET Core 3.1 SDK https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-3.1&tabs=visual-studio № Task 1. Run the basic WeatherForecast test application and show its operation. 2. Develop and demonstrate a webAPI to work with to-do list items stored in a database 3. Demonstrate the operation of a data…

SEE MORE QUESTIONS

Recommended textbooks for you

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

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

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS