Based on: Entity-Relationship Diagram with the following requirements: There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date There are Flubs (ie posts) with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) There are Bounces (ie shares) where a Professor can share another Professor's Flub Add ID attributes as necessary Content of Flubs only needs to be a text of fixed length Professors can have/be Colleagues (ie friends/followers) A Flub can get Citations (ie likes) by other Professors Create the SQL for a single View called "Flubbergasting" of a Professor which includes all attributes from Entity-Relationship Diagram, as well as how many Flubs, the average number of Bounces the Flubs had, and total Citations across all Flubs by that professor.

Based on: Entity-Relationship Diagram with the following requirements: There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date There are Flubs (ie posts) with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) There are Bounces (ie shares) where a Professor can share another Professor's Flub Add ID attributes as necessary Content of Flubs only needs to be a text of fixed length Professors can have/be Colleagues (ie friends/followers) A Flub can get Citations (ie likes) by other Professors Create the SQL for a single View called "Flubbergasting" of a Professor which includes all attributes from Entity-Relationship Diagram, as well as how many Flubs, the average number of Bounces the Flubs had, and total Citations across all Flubs by that professor.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 3MC

See similar textbooks

Similar questions

Based on the following Entity-Relationship Diagram with the following requirements: There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_DateThere are Flubs (ie posts) with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor)There are Bounces (ie shares) where a Professor can share another Professor's FlubAdd ID attributes as necessaryContent of Flubs only needs to be a text of fixed lengthProfessors can have/be Colleagues (ie friends/followers)A Flub can get Citations (ie likes) by other Professors--------- Create the Relational Model for the Flubber database based upon your ER Diagram above, meeting all the same requirements. Include all necessary Primary Key and Foreign Key constraints. This should be syntactically correct to test in a MySQL database.
Based on: Entity-Relationship Diagram with the following requirements: There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date There are Flubs (ie posts) with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) There are Bounces (ie shares) where a Professor can share another Professor's Flub Add ID attributes as necessary Content of Flubs only needs to be a text of fixed length Professors can have/be Colleagues (ie friends/followers) A Flub can get Citations (ie likes) by other Professors Show the Relational Algebra AND Domain Relational Calculus formulas for each. Show a portfolio of the Flubs by a Professor Show a portfolio of all Flubs and Bounces (the Flubs bounced) by all of a Professor's Colleagues
Based on the following Entity-Relationship Diagram with the following requirements: There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date There are Flubs (ie posts) with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) There are Bounces (ie shares) where a Professor can share another Professor's Flub Add ID attributes as necessary Content of Flubs only needs to be a text of fixed length Professors can have/be Colleagues (ie friends/followers) A Flub can get Citations (ie likes) by other Professors Write the necessary SQL Queries for the following functions. Adding a new Professor Changing a specific Professor's Professor_Name Removing a Flub by ID Show a portfolio of the Flubs by a Professor in reverse chronological order Show how many Bounces and how many Citations a Flub of particular ID has Show a portfolio of all Flubs and Bounces (the Flubs bounced) by all of a Professor's…
Illustrate an Entity-Relationship Diagram (ERD) model using Crow’s Foot notation Here we can have the following entities 1.patients:this entity will store the details of the patients and the attributes for this entity is id(which is unique for each patient and can be used as a primary key) name(this attribute will store the name of the patient and it is a composite attribute) address(this attribute will store the address of the patient and it is multi valued attribute. ) contact_num(this is also a multi valued attribute which will store the contact details of the patient). age(which is a derived attribute) 2.room:this entity will store the information about the details of the rooms. The attributes are. id(this is unique for each room and can be used as a primary key) room number(this will store the room number) Total_bed(this will store the total number of beds present in that room) 3. Bed:this entity will store the information regarding to each bed present in an room, and the…
Which of the following is a key part of conceptual design in an entity relationship model? This model uses column names instead of attributes. In this model, the characteristics such as location, path, and format are described. This model converts entities into tables. In this model, no primary keys are specified in the entities.
Develop ERD (Entity Relationship Diagram) for one of the following two scenarios. NOTE: No further details were provided by the professor. The diagram can be drawn by hand also if preferred. Option1: A customer who goes to a grocery shop generates one invoice each time s/he goes to the grocery. Customer data to capture includes ID, FirstName, LastName, City, State, CreditLimit. An invoice should capture the data on InvoiceID, SaleDate, SalesPerson, and Amount. Provide a conceptual ERD for this transaction scenario. Option 2: One sports team consists of many players, and one player can belong to one sports team at a time. Sports team data should have TeamID, TeamName, CoachName, memberNumbers, City, State, owner, TeamValue. Each player can be represented with PID, Name, Address, PhoneNo, Position, weight, height, Value, and Scores. Provide a conceptual ERD to develop a database.
Construct Entity Relationship Diagram (ERD) for the scenario given. Include all the actual andassociative entities, attributes of each entity assuming the primary key, foreign key and not nullconstraints, relationship between the entities with cardinality constraints. Use Crow's FootNotation. State any assumptions necessary to support your design. Royal Oman Police inspects their vehicles for keeping them tuned up. Every vehicle isidentified by Vehicle Identification Number, make, model and engine capacity. There is apolice owner for all vehicles who drives vehicles. The police owner is identified by police ID,name, office location and mobile number. Each police will have one vehicle and every vehiclewill be driven by only one police. Some Vehicle requires to be inspected every year. Thedepartment requires to record the details of inspection with attributes inspectionID, date,and results. Each inspection will require atleast 1 inspector who will do different tasks oneach inspection.…
Prepare a Crow’s Foot Entity Relationship Diagram for the application described in the following paragraph. Many-to-Many relationships should be broken into two 1-to-Many relationships using a bridge entity. Label PK attributes and FK when applicable. For each entity, you need to define a primary key. If there is a relationship between two entities make sure you define the corresponding foreign key in the child table. Seneca Sandlot Baseball is a recreational baseball league for Seneca students. The league has different divisions for different skill levels. Each player’s skills are evaluated and the player is assigned to a division. A team is made up of many players from the same division, and a coach. A player may play on only one team in the league. Each division is made up of many teams. A coach may coach teams in more than one division , but can only coach one team in each division. A coach may not play on any team in the league. A season is twelve weeks in length.…
Using er assistant create an Entity Relationship Diagram(ERD) with appropriate entries, relevant attributes, and relations to support the following business rules, and write a few lines to defend your erd. You need to design a database to keep track of clubs at a high school. Attributes: A student may only join one club Some students do not join at all Club needs to have one student Need to capture students: Name Address Year of grad All Phone numbers Club name Club advisor Meeting dates
Perform given tasks on Case study Q-Find entity Attribute and primary key, also draw Entity diagram? Case study: In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher has name NIC and qualification. A department is known by its name e.g. CSIT, and have a HOD name , Num of students and Floor No. A course is identified by its Code. Course also has name and level of degree. A student must enroll (roll no and Semester as relationship attribute) in any one department. A department can have many students. The teacher is assigned class (time and day as attribute) in more than one department. A department has many teachers. A student can study up-to 5 courses by a teacher in given classroom number.
This is the ER model for the case where there exists the entity of Product, which has the attributes of costPrice, salePrice, Identifier, factoryCode, description. These Products are manufactured by a Factory that has the attributes of description, factoryCode, factoryAddress, and this Factory sells its products to the Distributor entity, which has the attributes of distributorCode, factoryCode, email, description, distributorName. Please do the next thing: The requirement has been expanded with the following information: 'Currently, an Excel sheet is used where we store the information of the products that customers have ordered through orders; information is stored about when an order has been delivered and who or which company has made the delivery of the order.' Expand the ER diagram seen in class to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has." Please do the IMAGE E-R Diagram Expanded
Create an Entity/Relationship (ER) diagram to model the following scenario: An online magazine maintains a list that ranks restaurants based on reviews sent by the magazine's subscribers each restaurant is uniquely identified by an auto-generated code other attributes associated with a restaurant include its name, address, price range (1-3), rating (1-5 stars), and cuisine type there are many cuisine types and more can be added in the future subscribers are uniquely identified by their email and each have a name subscribers can review as many restaurants as they want, and a restaurant can be reviewed by many subscribers a review has a rating (1-5 stars), a date, and comments the system does not allow more than one review on the same date to the same restaurant and written by the same subscriber new reviews entered do not become immediately available as the magazine needs to check if the comments are appropriate and do not contain cursing or anything nasty/offensive once a new review…