Databases | SQL | Oracle | MS Access Answers

Perform the following tasks to create the database required for the application:
1. Create a database for the application. [2 Marks] 2. Create the required schemas in the database. [2 Marks] 3. Create the required tables under each of the schemas. [9 Marks] 4. Populate the tables with sample data. [2 Marks]

Perform the following tasks to create the database required for the application:
1. Create a database for the application. [2 Marks] 2. Create the required schemas in the database. [2 Marks] 3. Create the required tables under each of the schemas. [9 Marks] 4. Populate the tables with sample data. [2 Marks]

Perform the following tasks to create the database required for the application:
1. Create a database for the application. [2 Marks] 2. Create the required schemas in the database. [2 Marks] 3. Create the required tables under each of the schemas. [9 Marks] 4. Populate the tables with sample data. [2 Marks]

RockNJazz Universal Album is a leading music library in Florida. The library has various branches located in Weston, Miami, Phoenix, and Greensboro. Each branch of the library has a huge collection of music and movie cassettes, DVDs, and CDs that the members of the library can borrow. To borrow CDs, DVDs, or cassettes from the library, the members need to register themselves with the library by paying a nominal non-refundable fee.
To maintain member records, the library has hired an executive who maintains member information in the Member register. The details stored in this register consist of MemberID, MemberName, Gender, Address, and the amount paid by each member. After registration, a member receives a lifetime membership ID that he/she needs to quote while borrowing from the library. Each time a member borrows or returns a CD, DVD, or cassette, the executive at the issuing counter needs to update the Issue/Return register. The Issue/Return register stores the following details:
MemberID MemberNam

1. You have been asked to implement the following constraints in the table that stores the Issue/Return details: The fields that store MemberID, MemberName, and ItemID should not be left blank. The date stored in the DateofIssue field should always be less than or equal to the date stored in the DateofReturn field. However, while populating the table that stores the Issue/Return details with the sample data, you find that even if you leave the MemberID, MemberName, and ItemID fields blank, no error is displayed. In addition, you are able to populate the DateofIssue field with a date greater than the date stored in the DateofReturn field.
Analyze the preceding problem and implement the required constraints in the corresponding table. [5 Marks]
2. While populating the table that stores the Issue/Return details with the sample data, you find that: The ItemID field should contain unique IDs. The values stored in the Tariff, AmountPaid and Balance fields should not be less than 0. Alter the corresponding ta

Perform the following tasks to create the database required for the application:
1. Create a database for the application. [2 Marks] 2. Create the required schemas in the database. [2 Marks] 3. Create the required tables under each of the schemas. [9 Marks] 4. Populate the tables with sample data. [2 Marks]

After identifying the entities, attributes, and relationships among the entities of the application, you need to start with the design of the database. For this, you need to perform the following tasks:
1. Draw an E/R diagram to demonstrate the relationships between the various entities of the application. [8 Marks] 2. Map the E/R diagram to tables that you need create in order to accomplish the requirements of the application. [3 Marks] 3. Identify the attributes that can be used as primary keys for the corresponding tables in the relational database design. [2 Marks] 4. Identify the various schemas that need to be created while designing the database. [2 Marks]

Need a quote for attached assignment.. I have bad experience with getting help with plsql and the code not running so I really want to trust you guys. The program that we use is oracle sql plus.

Create an Entity-Relationship Diagram [ERD] and submit for approval. The ERD must show the tables and relationships amongst or between the tables. For example, if you are creating a music database you should have tables such as ARTIST, GENRE, LABEL, etc.