You’ve been employed by a Museum to develop the logical design of the database. If you have a list of works of art and a list of museums, each work of art can only be in one museum at a time, but each museum can have many works of art. Museums have designated name, address, and an id. The works comes with a works id, description, the creator’s name. using SQL modeler
Museums( MuseumId , MuseumName , MuseumAddress)
ArtPieces( WorksId , CreatorName , Desc , MuseumId(FK))
Names of tables are in bold.
Primary Keys have been underlined
Foreign Keys have been indicated.
You’ve been employed by a Museum to develop the logical design of the database. If you...
Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission: For the scenario below, draw a logical design draft on the paper, and then draw the design in the computer using PG Modeler software. After that, export the model to PNG photo. Submit to Brightspace a word file that has a photo of the draft design (on the paper) and the PNG photo that is produced from the PG modeler. Database scenario: Assume that...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their...
Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: • Each Job is for a specific customer and there can be more than one job per customer. • The name and address must be tracked for each customer. • Each job is described by up to 2000 characters. • Each job has a status of ‘open, ‘in process’, or ‘complete’. • Each job has a start date and end...
SQL help: Design a database diagram for a database that stores information about the Downloads that users make. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name. What are the PK and FK for this diagram Describe the reasoning...
Database design
Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...
You have been asked to develop a real estate database to track homes, realtors, and owners. Homes are either rented or owned and have an address, a number of bedrooms, a number of bathrooms, and square feet. An owner has a SSN, name, spouse (owner may not have one), profession, and spouse’s profession (if no spouse, then no spouse’s profession). Owners might have several homes to sell, but a home has only one owner. Agents represent owners in the sale...
Your project will require you to develop a database design to
solve a real-life data management problem. It can be any problem in
your work environment or for another organization, for example, a
bookstore (think of how Amazon uses databases), a course management
system (think of how a university manages courses), a bank (think
of how your bank works), and an online auction site (think of how
Ebay works). You will develop a database to solve this problem
You will...
Develop a conceptual ER diagram for the above database description, using appropriate syntaxes, and showing cardinalities and key attributes. Consider the partial description for a UNIVERSITY database below: A university is organized into colleges, and each college has a unique name, a main office and phone, and a particular faculty member who is dean of the college. Each college administers a number of academic departments. Each department has a unique name, a unique code number, a main office and phone,...
this is database course please draw the ER
by this way
We have been asked to analyze the data requirements and develop a database system to keep information for equipment hiring companies in the country The aim of this system is to monitor the hiring of equipment to dients. There are many companies in the country, and each company has at least three branches across the country. Where each branch has staff including the branch manager who is responsible for...
This is third time im posting this Question COURSE; introduction to database Please, No handwriting thanks for your efforts Design the database by following . Execute the sample requested queries. . ER Diagram. . All schemas before and after normalization. . All SQL statements of: -Creating tables. - Inserting data in tables. -Queries. 5. Screenshots from MySQL (or any other software you use) Question is - Database system for a Wholesale Management System Consider a database system for a Wholesale...