MySQL代做编程辅导:CA952 Art Gallery


Arm Of The Assignment


Your task during the classwork is to design and construct a database and a set of Web pages that can be used to recover and display some of the data.


现在提到了代写服务,肯定很多人都不会觉得陌生,就算是国内也是有着专业代写作业的服务行业的,能够为有需求的学生提供很多的帮助,不过其实代写机构在国外会更获得学生的支持,这是因为国外的学校对于平时的作业要求比较严格,为了获得更高的分数顺利毕业,不少留学生就会让代写机构帮忙完成作业,比较常见的作业代写类型,就是计算机专业了,因为对于留学生来说这个技术对于Machine Learning或者AI的代码编程要求更高,所以找代写机构完成作业会简单轻松很多,那么代写机构的水平,要怎么选择才会比较高?




作业的难度相信很多人都很熟悉,特别是对于AI深度学习或者是人工神经网络这种算法来说,因为要对SVM、Design Tree、线性回归以及编程有很高的要求,可以说作业的完成要求非常高,因此才会带动代写机构的发展,找专业的代写机构,一般都是会有专业的人员帮忙进行作业的完成,因为这类型的作业对专业要求比较高,因此代写机构也要具备专业能力才可以,否则很容易导致作业的完成出现问题,出现低分的评价。






This is an individual task and must be accomplished without collaboration or collusion.


Read the following description of a data model. From the specification, produce the following:

  • An enhanced entity relationship model.
  • A list of table structures produced by logical design based on the above enhanced entity relationship model.
  • The SQL code to construct and populate only sufficient tables to carry out the query part of the exercise. The database can be built using either Oracle or MySQL.
  • A set of web pages that execute the queries and display the results.

Database specification

Art Gallery

The art gallery holds paintings on behalf of their owners so that the paintings can either be permanently on display in the gallery or on loan to exhibitions around the country. Each owner may have introduced one or more other owners to the scheme.

The catalogue of paintings held by the gallery records the name of the artist, the title of the painting, its estimated value and current location within the gallery or the venue of the exhibition at which the painting is currently on show. In addition, the gallery must record a paintings acquisition date, insurance value and owner. The location for a painting is the room number of one of the buildings owned by the gallery. Each location is maintained at a specific temperature and humidity. For the artists, basic details of name, date of birth, date of death (if applicable) and nationality are held. In order to maintain a record of the history of a particular painting, the gallery keeps details of the current owner and all previous owners.



The gallery keeps a record of all exhibitions to which each painting has been loaned while it has been held at the gallery (loans when the painting was not held at the gallery are not recorded). Exhibitions to which the gallery loans paintings are all privately sponsored and the gallery wants to keep records of which sponsors have sponsored exhibitions where their paintings have been shown. Each exhibition has a venue, a unique title, a start and finish date and details of the exhibition sponsors.



Enhanced entity relationship model

The first step in this process is to construct an enhanced entity relationship diagram.
Read the above specification and write down a list of the entities and attributes. For each entity indicate the identifier and write a sentence to describe the significance of the entity. Indicate any supertype/subtype hierarchies. Make a note of necessary assumptions. Draw an enhanced entity relationship diagram.

Logical design

Table structures should be written down in the following format:
TABLE_NAME(Primary-key-attribute,Non-key-attribute1, Non-key-attribute2…..).
Using the enhanced entity relationship model from Section 4.1, write down a table
structures for each entity taking care that:

  • each attribute becomes a column.
  • the unique identifier becomes the primary key and is indicated by underlining
  • subtype/supertype entities are represented in one of three methods described in the lectures

Physical Design

Physical database design is generally specific to the database management system that is to be used and the performance requirements of the system. In both Oracle and MySQL the chief tool is the creation of indexes, etc. For the purposes of this exercise it is sufficient to create the necessary indices. It is not necessary to optimise the database structure by merging entities etc. Make a note of the attributes from
Section that will require indexes. You would normally use an index for attributes that are involved in joins or which are the subject of an SQL ‘where’ clause. Both Oracle and MySQL automatically create indexes for primary keys but you must identify these using appropriate constraints. You will also need to note foreign key attributes for index creation as indices.

Creating and loading the database

Implement only the parts of the database that are necessary for carrying out the queries. Implement your design in Oracle or MySQL on the Departmental devweb server. Use appropriate integrity constraints. Populate each table with a limited set of data i.e. only enough to show that the queries work.

Querying the database

You now need to write some queries on your database. The queries must be useful queries and not artificially constructed simply to fulfil the criteria listed. All queries require a WHERE clause of the form ‘…WHERE ATTRIBUTE = Value…’ to limit the rows returned (Value can be a text, numeric or date value). Write SQL statements that will

  1. carry out a join between two tables and use the group by clause.
  2. execute a sub-query.
  3. execute a correlated-query.
  4. carry out a self join that uses primary key/foreign key attributes.

For MySQL, output can be saved to files using PHPmyadmin. The output of Oracle SQL queries can be captured in a file by typing:

Web Page Front End

Using PHP, HTML and CSS as appropriate design a website that has five main pages: one main page with links to four other pages to support your four queries from above. Each of these query pages should ask the user for required data and then when submit is hit, present the results in a nicely formatted table. There should be a common look and feel (i.e. consistent appearance and placement of content) across all pages and every page should include a suitable company logo.


在此对LE PHUONG对本文所作的贡献表示诚挚感谢,她在山东大学完成了计算机科学与技术专业的硕士学位,专注数据分析、数据可视化、数据采集等。擅长Python、SQL、C/C++、HTML、CSS、VSCode、Linux、Jupyter Notebook。






This will close in 0 seconds