Design a database that represents one of your interests or favorite apps:
Uber
Spotify
Workout Tracking
SPOTIFY

-Each User has many events, playlists, followers and users they are following. -Each Artist has many songs, events and keywords -Each Song has many artists, many genres, many albums, many playlists and keywords -Each Album has many songs and many keywords -Each Genre has many songs, many keywords and many events -Each Playlist belongs to many users and many keywords
Design a database that represents one of your interests or favorite apps: Uber Spotify Workout Tracking
You need coffee and FAST! You hop out of your Uber at your favorite place, but with a history of a line. Usually you can expect there to be 17 people in line any time you come here (there is only one order taker). Service time averages 40 seconds. SHOW ALL WORK! Remembering ρ=λ/μ, L=λW, W=1/(μ-λ), L_q=ρL=L-ρ, W_q=ρW=W-1/μ,P_n=(1-ρ) ρ^n What is the utilization of the server? _____% What is the expected time between people arriving to this system? _____ seconds...
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,...
Description Design a database that contains 3-5 related tables to model a scenario of your interest. You should be somewhat familiar with the scenario that you choose to make informed design decisions. For example, if you want to design a database for a small business, you need to know the business logistic in the company. Other examples for your database are a database for a bookstore, a gym (e.g., YMCA), or a small organization. Do step 1 Step 1: Write...
Description Design a database that contains 3-5 related tables to model a scenario of your interest. You should be somewhat familiar with the scenario that you choose to make informed design decisions. For example, if you want to design a database for a small business, you need to know the business logistic in the company. Other examples for your database are a database for a bookstore, a gym (e.g., YMCA), or a small organization. Do step 1 Step 1: (Minimum...
Select one favorite application of yours (in e-commence, education, games, and so on). Design a Java FxGUI for a "customer" to access the application of your design. the application of your design. 1. Makes sure you have sufficient components (2 or more buttons, text fields/areas, a selection list, 1 or more images and other optional components of your choice). In addition, add an "account" information so that a customer/user may access or utilize the application. Your GUI application shall also...
Using the MySQL Workbench create a new database using your design specifications Add at least 10 records to your tables. Note: Certain tables may not require 10 records and that is ok as long as your main tables have 10 or more Create MySQL statements that will retrieve all records or rows from the tables in your database Create 10 MySQL statements that will retrieve specified records or rows from one table in your database Create 10 MySQL statements that...
Question: Draw the ER diagram of your database design in Crow’s Foot notation. RULES OF DATABASE Each thesis has the following mandatory attributes: thesis no (numeric), title, abstract, author, year, type (one of Master, Doctorate, Specialization in Medicine, and Proficiency in Art), university, institute, number of pages, language (Turkish, English, etc.), and submission date, A person can be author of more than one theses (for example, a person can prepare a Master thesis, later s/he can prepare a Doctorate thesis),...
question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly. ------ The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will...
1. Consider the design of a database for a web site of jokes. Each joke is identified by a unique joke ID, a title, a description of the joke, the date the joke is posted, and a list of tags (each tag is a single word in lower cases). Only registered users can post, read, comment on jokes. Each registered user is identified by a user ID, a password, a first name, a last name, an email, the gender, and...
Q3: You have been hired to design a database for prescriptions for RX pharmacies and your first job now is to design an ER model for this database using the following description of that world. i. patients are identified by their SSN and have other attributes as names, addresses, and ages. ii. Doctors are identified by their SSN and have other attributes as names, specialty, and years of experience. iii. Each pharmaceutical company is identified by name and has a...