When designing database tables, the difference between a good design and a bad design can be...
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...
Project Description In this project, you will design and implement a database for keeping track of information for an online “SOCIAL NETWORK” system (e.g. a simplified version of Facebook!). You will first design an EER schema diagram for this database application. Then, you will map the EER schema into a relational database schema and implement it on ORACLE or MySQL or some other relational DBMS. Finally, you will load some data into your database (via user Interface) and create some...
User interviews can be useful in user experience design. There are many different questions that can be asked, but your goals may only require a few of them. For this discussion, assume that you are contracted to design a news web site and you are interviewing an end user. List at least three questions that would ask regarding their experiences with news web sites. Explain how your questions help you understand how they navigate the sites and how the styling...
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...
Suppose that you are working for a chain restaurant and wish to design a promotion to disabuse the public of notions that the service is slow. You decide to institute a policy that any customer that waits too long will receive their meal for free. You know that the wait times for customers are normally distributed with a mean of 20 minutes and a standard deviation of 3.5 minutes. Use statistics to decide the maximum wait time you would advertise...
Suppose that you are working for a chain restaurant and wish to design a promotion to disabuse the public of notions that the service is slow. You decide to institute a policy that any customer that waits too long will receive their meal for free. You know that the wait times for customers are normally distributed with a mean of 18 minutes and a standard deviation of 3.4 minutes. Use statistics to decide the maximum wait time you would advertise...
This week, you will start a course project. For this project, you will design and develop a small website for a travel company. You will develop this website across the span of the course, building new project components each week, until you have a live, hosted website at the end of the course. This project is designed to replicate real-life situations where the clients provide only a few of their requirements and expect a prototype to be developed. Scenario Express...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
Designing a Traffic Light Controller [50 pts] [Your originality, thinking method and execution would be graded] In Gotham city, traffic lights have three outputs as Red (R), Yellow (Y) or Green (G). Let's assume you're given a microchip with clock input 0.2 Hz. As you know.cars can travel when the light is Green and should not pass the traffic light when the light is Yellow or Red. We are asked to design the traffic light controller in the busiest road...