Sbonne7_Homework 5

B. Art Museum Database Draw an EER diagram to keep track of information for an art museum. Assume that the following requirements were collected: (10 marks) The museum has a collection of art objects. Each art object has a unique ID, a year (when it was created, if known), a title, and a description. Art objects must be categorized based on their type. There are three main types: painting, sculpture, plus another type 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 drawn on (paper, canvas, wood, etc.), and style (modern, abstract, etc.). A sculpture has a material from which it was created (wood, stone, etc.), height, weight, and style. An art object in the other category has a type (print, photo, etc.) And style. The museum keeps track of artist information, if known: name, date born (if known), date died (if not living), country of origin, epoch, main style, and…

Design the database in an MS Excel spreadsheet as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own:  Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy) What normal form is this design? Why? What should be done to correct the design?

dout in data structures:   What do you mean by constraints? Explain any 5 constraints with the help of examples. Create any table of your choice using those 5 constraints.

Project Synopsis: DATABASE MANAGEMENT:ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic…

Project

114. A tool that can help designers understand the dependencies of database structures is a: a. dependency graph. b. data model. c. graphical display. d. None of the above is correct.

Integrate any programming language to mySQL with the implementation of Database Normalization and Creation of ER Model.  What should I expect? 1. User login interface 2. An interface where I can input my details. (User registration form, Freshman Application Form, Credit Card Application Form, Bank Account Opening Form, and etc.) These are just samples, you can think of your own, of course. 3. From one whole big interface of registration form or any above-mentioned items, I should see the database normalization implemented from whole big table (1NF) to 3NF. The expectation is that the database should have 1NF table and lastly the 3NF tables.

Creating a database Diagram. Does the attached image meet these criteria?   Week 6: Lab Instructions Now lets consider designing a database for the a car lot. Consider the following statements -> Our car lot sells many cars every month (we have a big inventory) Our car lot has many customers (everyone loves us!) Our car lot has many sales persons (we are ready to help our customers) Each car sale persons sells many cars a week (our prices are great) Our car lot provides many mechanical services (all our mechanics are experts) Our Service department has many mechanics (any mechanic would love to work here) Our mechanics provide service to our customers (our repeat business is awesome) Examine the above information and determine the Entities. With each entity - determine some attributes for each entity. As a note - is there any information in the above statements that is not helpful for our database design? Now lets consider our Car Lot database design and determine the…

Difference  between disjoint and overlapping constraints?

How can data binding help maintain consistency between the model and view in a user interface?

2- Design a class diagram of a course registration system. Note: utilize various class relations: generalization, aggregation, composition, and association; the class diagram should include but not be limited to the following class names User, Student, Instructor, Admin, Course, LogonPage, AddPage, DropPage, ChangePage, PrintPage, QueryPage, CourselnfoDB, StudentInfoDB, InstructorlnfoDB, AdminlnfoDB, and EntireDB.

JSD

2- Design a class diagram of a course registration system. Note: utilize various class relations: generalization, aggregation, composition, and association; the class diagram should include but not be limited to the following class names User, Student, Instructor, Admin, Course, LogonPage, AddPage, DropPage, ChangePage, PrintPage, QueryPage, CoursenfoDB, StudentInfoDB, InstructorinfoDB, AdmintnfoDB, and EntireDB.

Problem: design a er diagram for a database to keep track of building inspections required by a department of Damaged Buildings (DB). DB  building inspections are requested by builders every month. Each building inspection is either passed or not. Inspections have a type code (3 characters, e.g. PLU, FRM, ELE, etc.) and possibly sequencing requirements. Some inspections cannot be performed before other inspections, e.g. final plumbing inspection cannot be performed until the framing inspection is passed. Each inspection has a numeric score, with 75 or more out of 100 being sufficient for a pass status. Each inspection data contains the date of inspection, inspector identification, inspection score, and textual information about the inspection. The textual information can be updated later, but the score can never be changed. FODB maintains a pool of inspectors. Each inspector has a unique 5 digit employee ID, name, and date they were hired. They can conduct any type of inspection but…

Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager…

2- Design a class diagram of a course registration system. Note: utilize various class relations: generalization, aggregation, composition, and association; the class diagram should include but not be limited 10 the following class names User, Student, Instructor, Admin, Course, LogonPage, AddPage, DropPage, ChangePage, PrintPage, QueryPage, CourselnfoDB, StudentinfoDB, InstructorinfoDB, AdminlnfoDB, and EntireDB.

Random Hospital Example ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information.   Remember the ERD will eventually turn into the design for a database from a top down view.  Make sure you resolve any many to many conflicts.  Label an identifier or primary key and all pertinent attributes given.   If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity.  Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common.  Make sure you show entities, relationships, cardinality, and optionality.  Random Hospital Example A hospital has 10 wards, each containing up to 20 patients.  Patients have only one doctor allowed to prescribe drugs for them.  Doctors do their rounds once a day and prescribe drugs by…

Task 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows:  Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price.  Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall.  Each supplier has a supplier name and address.  A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product.  A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product  The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…

Entity relationship diagram.

Explain in your own words what sets disjoint constraints apart from overlapping ones.

How do changes in data models typically propagate to the UI in a two-way data binding scenario?

Q4: Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights. Your design should include a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints. Please note that an E-R diagram is not required.

8. Matrix algebra is a theoretical way of manipulating a database.   9. The union of tables A and B is a table containing all rows that are in either table A or table B or in both table A and table B.   10. The intersection of two tables A and B is the set of all rows that are in table A but that are not in table B.

Alert dont submit AI generated answer.

database