Java Examiner - Learn Programming

System Background The online shopping site with the member system and real store stock checking system When user buy online will earn the points  User will go to the shop to take the product so no need to store address in “Order”  Database Requirement Catalog  Type  Product Shops (With Address and Location Order Stock User Login (Email / ID card + Password) …And more Get your project now  Buy now

Some friends of yours are hoping to set up a data driven website to support their home business selling second-hand children clothes, and have asked for your advice on the database design side. They need a database to list all the available items for customers to purchase, and also want to have a user comments system so that visitors can give feedback on purchased items as well as buy them. They are not database experts, and they have asked you to devise a database model they could use. Their ISP has said they can mount and operate a database on their account if given a set of relational tables, which describe it, so this is ultimately what they want you to produce. As a minimum, they would like to store the following information about each item of clothing: the kind of garment, colour, size, material, gender (where appropriate), condition, age, and how much it costs, plus feedback once sold, if available. For customers they would want to record name, postal address, email address an...

System Background The online shopping site with the member system and real store stock checking system When user buy online will earn the points User will go to the shop to take the product so no need to store address in “Order” Database Requirement Catalog  Type  Product Shops (With Address and Location Order Stock User Login (Email / ID card + Password) And more What you'll get in solution: Complete ERD of the database system in Crown's Foot Notation Format Full Functional, ready to import MySQL database Sample Screenshot of ERD Get your project now  Buy now

The Movie database for the final project will have the four tables shown above. Begin with MovieRa ng, since this is the simplest table in the database. It is a lookup table of all the MPAA Ra ng Codes (plus NR for Not Rated) and it has two fields: Ra ngID and Ra ng. Once created it should be populated with the following records Some of the characteris cs you associate with movies are in the table, Movie. They represent most of the data types associated with a rela onal database. The MovieID is a unique number that iden fies a single movie, Title is a text field containing the movie tle, YearReleased is the year the movie was first released, Ra ngID is a foreign key associated with the Ra ng in the MovieRa ng table, and the remaining fields are Boolean variables (Yes/No) to iden fy movies that are in black and white, and foreign films with sub tles. Once created it should be populated with the following records An important part of any movie database is the cast. The table Cast contains ...

Database Design Design your initial designs on paper. Each one individually works on the designs and gets together with the team members to create team designs. The first step is creation of a logical design for the database. In this step, you will identify entities/tables, their attributes, and relationships. While reading the case, identify entities/tables (hint: nouns), their attributes (hint: nouns) and relationships (hint: verbs). Also, look at the form, queries and report in the textbook and this handout to make sure that your tables include all the appropriate fields. Avoid calculated fields (ex: age, number of students, and duration of course) as actual fields in your tables. For each table, identify the primary key by underlining it. Determine the proper relationships (examples: 1:1, 1:M, M:N) among the tables and create your logical ER diagram. Use the Student Registration Database Logical Design handout given in the class as a model and design yours along the same lines. O...

How can you tell if the index is being used or not? How would this information help in optimizing or tuning a database(s)? Problem Queries After looking into the query situation, you realize that, basically, two types of problem queries exist. The first is encountered when a user tries to look up the status of a shipment. However, it is not consistent: It appears to happen sporadically for most users. The second problem query happens to everyone whenever they attempt to accept a new package for shipment. Package Status Lookup Internal employees and external website users have begun complaining that it takes too long to look up the shipping status for a package. What makes this more perplexing is that it doesn’t happen all the time. Some queries run very fast, whereas others can take minutes to complete. Now that you’ve found what appears to be a problem query, your next step is to run EXPLAIN to see what steps the MySQL optimizer is following to obtain results. MySQL is perfo...

In this project, you are asked to modify your program from Assignment 1 (The Pizza Preferences Survey). Make this program store the collected data in a database, instead of the text file. Implement the delete data entry feature, as in StudentJDBC example. It is not required to implement the editing. Implement one or more logins for administrators using DataSourceRealm, with salted and hashed passwords. You may implement several levels of access (roles), like in HelloLogins, but it is not required. Viewing and removing data should require logging in. The administrator password should not be “sesame”, encrypt another password. Copy-paste your steps of the encryption (as in the posted “sesame.txt” file) in your own “readme.txt” file and submit it with the code. You are also required to submit your “pizza.sql” file that you used to generate the database for your program. Some thoughtful reworked copy-pastes from examples posted on SLATE are allowed, but mindless copy-pastes are ex...

Prototype Database system Design and implement a database system in Oracle based on the case study below. You will be expected to identify the management needs of the organisation and present how they are solved and dealt with by your database design and implementation. ScenarioLondon University is a prestigious institution educating students from all over the world. It offers 40 programmes from five disciplines. The university currently uses an old legacy system which is file-based. Due to various difficulties, the management have decided to modernize the system by having an online system with a backend database. As a group of consultants, you are required to produce a database system to upgrade a part of the system that handles the student registration and timetabling of students. On arriving at the university each student must be enrolled on a programme and be allocated a personal tutor who would oversee their academic needs at the college. The maximum duration of a programm...

Relationship to Module Learning Outcomes Apply UML use-case, activity, sequence and class diagrams to the analysis of programming problems and the design OO solutions.Exercises methodical analysis and design through the use of the specified UML diagrams applied to an object-oriented programming problem. Implement and execute small OO programs (up to 5 classes) Requires the implementation and execution of a program using GUIs, constructed from student defined and library classes in Java. Demonstrate the application of common data structures. Requires the use of data structures such as ArrayLists or HashMaps. Determine the requirements and structure of programs running and communicating across a network. This assignment requires a client-server application to be analysed. Design and develop and test OO programs that can communicate with each other across a network. This assignment requires a client-server application to be designed and developed. Individual Task An internatio...

Your group is responsible for developing a database to support the fundamental data requirements of a customer call center for an established network service provider (includes landline, mobile and internet (broadband) services) - CallAir.  Due to increased competition in the market, CallAir. Due to increase competition in the market, CallAir is under increasing pressure to remain competitive and to rebuild its waning customer base. In order to do this, CallAir requires a unified view of all its customer data including customer personal information, bill details, marketing preferences, history with the organization providing CallAir with the ability to target customers with the right product/service offers. The following are the minimum project requirements: You are required to create a REPORT for CallAir documenting the database design and some preliminary results once the database is developed. This should include: 1.  Draw an Entity Relationship Diagram (ERO). Thi...

Write SQL statements (queries) to answer the following questions (Make sure to replace XXX with your initials!): 1. Write an SQL statement to list all columns and all rows for the table Service. Save the query results as XXXQ1. 2. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master. Save the query results as XXXQ2 3. Write an SQL statement to list the names of employees who have worked on a property in New York. Use a subquery. Save the query results as XXXQ3. 4. Answer question 3 but use a join. Save the query results as XXXQ4. 5. Write an SQL statement to list the names of employees who have worked on a property owned by a corporation. You can use either subquery or join for this question. Save the query results as XXXQ5. 6. Write an SQL statement to show the first name and sum of hours worked for each employee. Save the query results as XXXQ6. 7. Write an SQL statement to show the sum of hours worked for ea...

I- Short Answer Questions: Answer the questions briefly. Explain briefly referential integrity. Using sentence each, based on your understanding of database design, list 2 advantages of using a database system in comparison with using traditional electronic file processing systems Distinguish between the primary key, candidate key, and surrogate key In the following relation, which tracks payments made out to payees,        Payment (Payment-Num, Payment-Amount, Payee-ID, Payee-Name, Payee-Address), the functional dependencies are: Payment-Num - Payment-Amount, Payee-ID, Payee-Name, Payee-Address Payee-ID - Payee-Name, Payee-Address. Please explain why this relation is subject to insertion anomaly and deletion anomaly II- Suppose you are the database analyst designing a database for a swim team league called Water Fun League (WFL): First, WFL wants to keep track of the swim teams in the league and their swimmers. Each swim team has an official name and a captain...

SoundSpace SoundSpace is a company that is specialized in hiring out audio equipment to recording artists to be used for the recording, mixing and mastering of music projects such as music tracks and albums. The company is based on a number of recording studios located all over the world. SoundSpace offers a really wide range of studio equipment to their customers such as analog and digital recorders, mixing desks, audio interfaces, microphones, studio monitors, digital converters, controllers and other miscellaneous studio accessories. Draw the ERD of the system and map the relationship using 1...1 1...* *...1 *...* Get Project Solution by contacting us - via WhatsApp: +92-324-7042178 - via email:  codelogixstudio@gmail.com

After each question, construct the SQL statement that answers the question.  When specific attributes are not asked for, you may choose which attributes you wish to display. List all the information about the properties.  List information about damages including the street address. What were the different sources of damage (no duplicate reporting)? What was the total amount of damages assessed? What were the total damages for each property? List the damages sorted by location (where the damage was located not where the property was located). How many damages were reported? List the information about the properties whose zip codes start with 301. List the properties in Woodstock that were damaged. What properties were damaged (street address), what were the damages (description) and what was the amount of the damage? List the report information for inspectors Jones, Smith, White [use the IN keyword].  Which inspector(s) reported total damage amounts >$30,0...

Relational Algebra A database records information about athletes competing at the Olympics. An athlete competes for a particular country in one or more events. Events take place at a scheduled day and time in a particular venue. The result (rank) is recorded for all athletes in the final of the event. The medal (gold, silver or bronze) is also recorded for the medal winners in the event. Note that we are not considering team sports or heats in this example – only individuals competing in the finals. The schema for this database is as follows: (Note that primary keys are shown underlined, foreign keys in bold). ATHLETE ( AthleteNo , AthleteName, CountryName) COUNTRY ( CountryName , NumberOfCompetitors) EVENT (EventName, ScheduledStart, VenueName ) VENUE (VenueName, City, Capacity) FINAL ( AthleteNo , EventName , Rank, Medal) Provide relational algebra (NOT SQL) queries to find the following informaList the name and country of all athletes. List the event name and scheduled start time fo...

Relational Algebra A database records information about athletes competing at the Olympics. An athlete competes for a particular country in one or more events. Events take place at a scheduled day and time in a particular venue. The result (rank) is recorded for all athletes in the final of the event. The medal (gold, silver or bronze) is also recorded for the medal winners in the event. Note that we are not considering team sports or heats in this example – only individuals competing in the finals. The schema for this database is as follows: (Note that primary keys are shown underlined, foreign keys in bold). ATHLETE ( AthleteNo , AthleteName, CountryName) COUNTRY ( CountryName , NumberOfCompetitors) EVENT (EventName, ScheduledStart, VenueName ) VENUE (VenueName, City, Capacity) FINAL ( AthleteNo , EventName , Rank, Medal) Provide relational algebra (NOT SQL) queries to find the following informaList the name and country of all athletes. List the event name and scheduled...

Case Study Re-read the description of the FastFoods4U case in Assignment 1 if you need to refresh your memory. Bill is pleased with your work so far and asked you to go on to implement your design. He has made a few clarifications and additions to the specifications that you should note: Bill’s trial of the system has been very successful and he now wants to broaden his service into other suburbs as well. He has also recruited more drivers, with the expectation that there will be drivers available in each suburb. However, customers will still only be able to have orders delivered from restaurants in the same suburb. Bill needs to know whether his meals are being delivered on time as per his advertising so the database will need to be able to provide information on requested and actual delivery times/dates. Bill is pleased with the way FF4U is developing and wants to make some further additions to the concept. He has decided to offer a service whereby customers will be able to see the ...

Case Study Re-read the description of the FastFoods4U case in Assignment 1 if you need to refresh your memory. Bill is pleased with your work so far and asked you to go on to implement your design. He has made a few clarifications and additions to the specifications that you should note: Bill’s trial of the system has been very successful and he now wants to broaden his service into other suburbs as well. He has also recruited more drivers, with the expectation that there will be drivers available in each suburb. However, customers will still only be able to have orders delivered from restaurants in the same suburb. Bill needs to know whether his meals are being delivered on time as per his advertising so the database will need to be able to provide information on requested and actual delivery times/dates. Bill is pleased with the way FF4U is developing and wants to make some further additions to the concept. He has decided to offer a service whereby customers will be able to s...

Use this file as your template and place your SQL code {not the results} beneath each question. Use the following tables to answer the questions: CUSTOMERS(cid, cname, city, discnt) AGENTS(aid, aname, city, commission) PRODUCTS(pid, pname, city, quantity, price) ORDERS(ordno, ordmonth, cid, aid, pid, qty, dollars) Construct queries to answer the following: List the name of all products for which an order was placed. (w3schools --> SQL Inner Join) List the name of customers that ordered product ‘p07’ (W3schools-> SQL Inner Join & SQL Where) List name of agents that placed an order for customer c003 or customer c006 (w3schools-> SQL Inner Join and SQL IN -- or SQL And & Or) List name of customers that ordered product ‘p01’ through agent 'a01' (w3schools-> SQL Inner Join and SQL And & Or) List the name of each customer that placed an order, the pid of what they ordered and also the customers that did not place an order. (w3schools--> SQL Left Join) List ...

Use this file as your template and place your SQL code {not the results} beneath each question. Use the following tables to answer the questions: CUSTOMERS(cid, cname, city, discnt) AGENTS(aid, aname, city, commission) PRODUCTS(pid, pname, city, quantity, price) ORDERS(ordno, ordmonth, cid, aid, pid, qty, dollars) Construct queries to answer the following: List the name of all products for which an order was placed. (w3schools --> SQL Inner Join) List the name of customers that ordered product ‘p07’ (W3schools-> SQL Inner Join & SQL Where) List name of agents that placed an order for customer c003 or customer c006 (w3schools-> SQL Inner Join and SQL IN -- or SQL And & Or) List name of customers that ordered product ‘p01’ through agent 'a01' (w3schools-> SQL Inner Join and SQL And & Or) List the name of each customer that placed an order, the pid of what they ordered and also the customers that did not place an order. (w3schools--> SQL L...