Search & Filtering
Databases | SQL | Oracle | MS Access
Using the relations that you have defined for the library system, normalize your relations into first, second, and third normal form. Your output should be an Entity Relationship diagram that is in 3NF. All attributes, entities, keys, and relationships should be included and labeled. Although you do not need to include an ER diagram (unless you want to) for the relations in 1st normal form or 2nd normal form, you must describe the changes required to your relations to meet the standard of first 1st normal form and then 2nd normal form and of course 3rd normal form.
Databases | SQL | Oracle | MS Access
Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of database systems. A client has recently approached your company with a view to implementing a database system, but they are not familiar with the development process.
Databases | SQL | Oracle | MS Access
Assign your last name as the value of the text variable in the executable section of the block. Include statements in the block to display each variable's value onscreen.
Databases | SQL | Oracle | MS Access
1: Produce an unduplicated list of all product IDs for all Products that have been sold. Sort the List.
2: Show the basket ID, Product ID, Product name, and description for all items. (Do it two ways-one with an ANSI join and one with a traditional Join.)
3: Modify all queries in step 2 to include the customer's last name.
4: Display all orders (basket ID, Shopper ID, and date ordered) placed in February 2012. The date should be displayed in this format: February 12, 2012.
5: Display the total quantity sold by the product ID.
6: Modify the query in step 5 to show only products that have sold less than a quantity of 3.
7: List all active coffee products (product ID, name, and price) for all coffee items priced above the overall average of coffee items.
8: Create a table named CONTACTS that includes the following columns.
2: Show the basket ID, Product ID, Product name, and description for all items. (Do it two ways-one with an ANSI join and one with a traditional Join.)
3: Modify all queries in step 2 to include the customer's last name.
4: Display all orders (basket ID, Shopper ID, and date ordered) placed in February 2012. The date should be displayed in this format: February 12, 2012.
5: Display the total quantity sold by the product ID.
6: Modify the query in step 5 to show only products that have sold less than a quantity of 3.
7: List all active coffee products (product ID, name, and price) for all coffee items priced above the overall average of coffee items.
8: Create a table named CONTACTS that includes the following columns.
Databases | SQL | Oracle | MS Access
After creating the correct structure of the required tables, you need to perform the following tasks
to create a database for the application:
1. Create a database for the application. [2 Marks]
2. Create the required schemas in the database. [3 Marks]
3. Create the required tables under each of the schemas. [10 Marks]
to create a database for the application:
1. Create a database for the application. [2 Marks]
2. Create the required schemas in the database. [3 Marks]
3. Create the required tables under each of the schemas. [10 Marks]
Databases | SQL | Oracle | MS Access
While analyzing the application, you identify the following entities and their attributes:
Patient:
Patient_ID
Patient_First_Name
Patient_Last_Name
Department_Code
Department_Name
Doctor_Name
Doctor:
Doc_ID
Doc_Name
Doc_Salary
Dept_ID
Dept_Name
Dept_Head
Doc_Fee
Department:
Dept_ID
Dept_Name
Doc_ID
Doc_Name
Dept_Head
Based on these entities and attributes, you create the structure of the table for storing the patient
details, as shown in the following table.
Similarly, you create the structure of the table for storing doctor details, as shown in the following
table.
In addition, you create the structure of the table for storing department details, as shown in the
following table.
1. Analyze the preceding structures of the tables and identify the problems that you may face while
inserting, deleting or updating data in these. Justify your answer. [4 Marks]
2. How can you solve the problems related to the structures of the preceding tables? Justify your
answer. [6 Marks]
Patient:
Patient_ID
Patient_First_Name
Patient_Last_Name
Department_Code
Department_Name
Doctor_Name
Doctor:
Doc_ID
Doc_Name
Doc_Salary
Dept_ID
Dept_Name
Dept_Head
Doc_Fee
Department:
Dept_ID
Dept_Name
Doc_ID
Doc_Name
Dept_Head
Based on these entities and attributes, you create the structure of the table for storing the patient
details, as shown in the following table.
Similarly, you create the structure of the table for storing doctor details, as shown in the following
table.
In addition, you create the structure of the table for storing department details, as shown in the
following table.
1. Analyze the preceding structures of the tables and identify the problems that you may face while
inserting, deleting or updating data in these. Justify your answer. [4 Marks]
2. How can you solve the problems related to the structures of the preceding tables? Justify your
answer. [6 Marks]
Databases | SQL | Oracle | MS Access
The Dash Cell Phone Company charges customers a basic rate of $5 per month to
send text messages. Additional rates are as follows:
l The first 60 messages per month, regardless of message length, are included in
the basic bill.
l An additional five cents is charged for each text message after the 60th
message, up to 180 messages.
l An additional 10 cents is charged for each text message after the 180th message.
l Federal, state, and local taxes add a total of 12 percent to each bill.
Design a flowchart or pseudocode for the following:
b. a program that continuously accepts date about text messages until a sentinel value is entered, and displays all the details.
send text messages. Additional rates are as follows:
l The first 60 messages per month, regardless of message length, are included in
the basic bill.
l An additional five cents is charged for each text message after the 60th
message, up to 180 messages.
l An additional 10 cents is charged for each text message after the 180th message.
l Federal, state, and local taxes add a total of 12 percent to each bill.
Design a flowchart or pseudocode for the following:
b. a program that continuously accepts date about text messages until a sentinel value is entered, and displays all the details.
Databases | SQL | Oracle | MS Access
Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of multimedia database systems. A client has recently approached your company with a view to implementing a multimedia database system, but they are not familiar with the development process. Provide a report explanation for your client.
CREATE YOUR OWN SYSTEM:
A.)Provide:
1.Introduction
2.Problem Statement
3.Scope of system
4.Mission statement and mission objective
5.Project limitation
B.)Provide your SQL query and rational table in order to present your system in detail to your client.
1.SQL – Create Table, Select Statement
2.Rational Table and business rules
3.ERD – Minimum 5 (Entity), Attribute, Relationship, Multiplicity
C.)Create minimum 4 interactive interface related to your title.
create your own interface to be your intermidiate between your database table and your user. By using any multimedia sofwate
CREATE YOUR OWN SYSTEM:
A.)Provide:
1.Introduction
2.Problem Statement
3.Scope of system
4.Mission statement and mission objective
5.Project limitation
B.)Provide your SQL query and rational table in order to present your system in detail to your client.
1.SQL – Create Table, Select Statement
2.Rational Table and business rules
3.ERD – Minimum 5 (Entity), Attribute, Relationship, Multiplicity
C.)Create minimum 4 interactive interface related to your title.
create your own interface to be your intermidiate between your database table and your user. By using any multimedia sofwate
Databases | SQL | Oracle | MS Access
Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of multimedia database systems. A client has recently approached your company with a view to implementing a multimedia database system, but they are not familiar with the development process. Provide a report explanation for your client.
CREATE YOUR OWN SYSTEM:
A.)Provide:
1.Introduction
2.Problem Statement
3.Scope of system
4.Mission statement and mission objective
5.Project limitation
B.)Provide your SQL query and rational table in order to present your system in detail to your client.
1.SQL – Create Table, Select Statement
2.Rational Table and business rules
3.ERD – Minimum 5 (Entity), Attribute, Relationship, Multiplicity
C.)Create minimum 4 interactive interface related to your title.
create your own interface to be your intermidiate between your database table and your user. By using any multimedia sofwate
CREATE YOUR OWN SYSTEM:
A.)Provide:
1.Introduction
2.Problem Statement
3.Scope of system
4.Mission statement and mission objective
5.Project limitation
B.)Provide your SQL query and rational table in order to present your system in detail to your client.
1.SQL – Create Table, Select Statement
2.Rational Table and business rules
3.ERD – Minimum 5 (Entity), Attribute, Relationship, Multiplicity
C.)Create minimum 4 interactive interface related to your title.
create your own interface to be your intermidiate between your database table and your user. By using any multimedia sofwate
Databases | SQL | Oracle | MS Access
Ms Excel book: the 2010 versions In the table document convert the tabular list beginning with Distance and ending with $20.00 into a table with two columns and six rows.
