Computer Science Projects

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 infor...

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. Onc...

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 each Exper...

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. A te...