e r diagram completed visio sql statements

ResearchPaperWriters.com has established itself as the best academic writing website through a combination of well-furnished writers, highly-rated custom research paper writing services, top-level writers, discounts, punctual delivery, and 24/7 support. These facets come together to create a platform that not only meets but often exceeds the academic writing needs of its clients. Whether you are a student grappling with tight deadlines or a researcher in need of in-depth, well-researched papers, ResearchPaperWriters.com is the pinnacle of academic writing excellence, ready to provide you with top-tier services and exceptional results. At the core of ResearchPaperWriters.com’s success are its well-furnished writers. The platform prides itself on the caliber of its writers, who are highly qualified professionals with expertise in various academic fields. These writers have a deep understanding of the intricacies and requirements of different academic disciplines, ensuring that each project is handled with the utmost care and competence. Their proficiency in conducting thorough research and crafting well-structured, academically rigorous papers is the cornerstone of the website’s success.

E-R diagram (completed in Visio )
all of the statements necessary to execute the database creation, data insert, and data manipulation within Notepad

 

 

Instructions:  You are in charge of designing and creating a database for a library.  Follow the guidelines for completing this task below.

 

Database Preparation and Design:

 

For this project, you will need to be concerned with the following types of data:

 

·         Books

·         Magazines

·         Publishers

·         Patrons

·         Fines

 

You can utilize the following assumptions in your design:

 

·         Books can have one or many authors.

·         Books need to be classified by category.

·         Magazines can have different types of issuing policies, including weekly, monthly, etc.

·         Different fine rates will apply to a book versus a magazine.  These should be stored in a separate table. 

·         You must include the date of any transaction that occurs.

·         In order to check out a book, a patron must be registered in the system.

·         A patron can take out as many items as they wish.

 

The first step of the project is to construct an E-R diagram to show the database model.  In this step, it is important to show all entities, relationships, maximum cardinality, minimum cardinality, keys, and attributes in their proper form.  Remember that each entity (or table) must be normalized.  Otherwise the subsequent components of this project may not work as expected. 

 

Based on the E-R diagram, create a data dictionary in Microsoft Excel that lists the table name, column name, column data type, as well as indicators for primary key, foreign key, and null status.  If the column name is not descriptive, include a Description column as well.

 

Database Creation:

 

Once you are complete with the diagram, you will write the SQL needed to create the database tables and relationships.  You will also write the SQL statements necessary for inserting at least five unique rows of data into each table within a script file.

 

 

Once you are complete with the above step, the next step will be to work with the data contained in your database.  You need to write at least one SQL statement for each of the following items:

·         SELECT statement involving a minimum of three columns

·         SELECT statement using a built-in function

·         SELECT statement utilizing LIKE.

·         Create a view

·         Query that executes at least one table join

·         One UPDATE statement

·         One DELETE statement

·         One PL/SQL procedure that contains at least one variable

ResearchPaperWriters.com’s pool of top-level writers is a testament to its dedication to quality. The website carefully selects its writers, ensuring they possess advanced degrees and a proven track record of academic writing excellence. This commitment to excellence translates into papers that not only meet but often exceed the expectations of clients, contributing to the platform’s well-deserved reputation as the best in the business. Affordability is another key aspect that makes ResearchPaperWriters.com the best academic writing website. The platform understands the financial constraints that students often face and strives to provide cost-effective solutions. Clients can benefit from discounts and bonuses that help make these high-quality services accessible. These financial incentives, in conjunction with exceptional writing quality, make ResearchPaperWriters.com the go-to choice for academic assistance.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

/by